On 24 Nov 2006 07:14:59 -0800, Logos wrote:
> That does work, thank you
>
> I chose VARCHAR over CHAR because of this excerpt from the MySQL online
> dox:
> "If a given value is stored into the CHAR(4) and VARCHAR(4) columns,
> the values retrieved from the columns are not always the same because
> trailing spaces are removed from CHAR columns upon retrieval."
>
> So I chose VARCHAR, and then made sure the insertion cose space-pads
> the field value up to the field length.

.... which always puzzled me as it's precisely the OPPOSITE as one would
expect from the type names (not to mention how every other RDBS I've
worked with does it). You'd thing the "VAR" one would be the one that
would strip trailing space and do it on the record write...

--
The pluses in my current job include laughing in the face of Nobel
laureates who have just lost the only copy of their data. (Hey,
I'm still a BOFH).
-- Bob Dowling