From: Martijn Tonies Date: August 23 2004 1:25pm Subject: Re: Why "VARCHAR" TO "CHAR" automatically when the length less than 4. List-Archive: http://lists.mysql.com/mysql/171390 Message-Id: <02cc01c48914$a4072760$0a02a8c0@martijn> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit > > I have a questions about "varchar columns" change to "CHAR columns" > > automatically. > > See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html In addition to that - it doesn't really matter as the CHAR datatype isn't properly implemented in MySQL and behaves the same as the VARCHAR datatype. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com