>Thanks, then, the maximum values for those would be:
>
>POINT(-999.99999 -999.99999)
>
>which would means that Char(28) would be big enough. Then, at the code level, as you mentioned, I would kept the usage of Varchar(100) just to have a proper conversion which would remove the trailing spaces and that should fit.
Yes, with this example you can use var/char(28) field.
>
>Is this pretty much the maximum optimization I could do here if I would want to keep the field definition to its minimum declaration?
You could use varchar() field type, so if the length of the string is smaller than 28 it will be stored with its real length, not padded.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
