In attempting to solve a problem posted earlier (see "non-tab delimited output?)
I discovered that, in their infinite wisdom, the MySQL developers elected to
trim spaces from CHAR data when retrieved from the database. Is this a new
interpretation of the ANSI-standard for the CHAR datatype? Most of us use the
VARCHAR datatype to achieve this goal - well, at least *I* do.
I am baffled as to why you would waste space storing space-padded data, then
trimming it when retrieved from the database. This is apparently a doented
"The length of a CHAR column is fixed ...