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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]