Re: Automatic conversion from `char` TO `varchar`

[Martijn Tonies]

Hi,


> The manual <http://www.mysql.com/doc/en/Open_bugs.html> says
>
> > The following problems are known and will be fixed in due time:
> > [...]
> > All string columns, except BLOB and TEXT columns, automatically have
> > all trailing spaces removed when retrieved. For CHAR types this is okay,
> > and may be regarded as a feature according to SQL-92. The bug is that in
> > MySQL Server, VARCHAR columns are treated the same way.
>
> That seems the reverse of what you are saying.

Indeed. Nevertheless, I'm right at this one :-)

Chars should be padded.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com