From: Martijn Tonies
Date: January 10 2004 6:20pm
Subject: Re: Automatic conversion from `char` TO `varchar`
List-Archive: http://lists.mysql.com/mysql/157370
Message-Id: <000501c3d7a6$7013e1c0$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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