Hello Wout,
Appareantly it's impossible to insert a string, consisting entirely
out of
spaces, in a textual field (I've tried varchar(19) and char(2) types,
they
both don't work). MySQL doesn't complain about it, but it trims the
strings
down to the empty string. If I try a select searching
It's in the doco:
http://www.mysql.com/doc/C/H/CHAR.html
snip
Values in VARCHAR columns are variable-length strings. You can declare a
VARCHAR column to be any length between 1 and 255, just as for CHAR columns.
However, in contrast to CHAR, VARCHAR values are stored using only as many