> > I have some problmes with MySQL. We have some CHAR columns, which after > > CREATE or ALTER TABLE > > > > ALTER TABLE `traffic_stat` CHANGE `media_file_class_id` > > `media_file_class_id` CHAR(32) NOT NULL > > > > will be VARCHAR. Is this an MySQL bug? We are using MySQL 4.0.18. > > http://www.mysql.com/doc/en/Silent_column_changes.html > > will answer your question: if there are any variable columns in a table, > MySQL sees no virtue in fixed size CHAR columns and silently changes CHAR > to VARCHAR.
As against the SQL standard, because CHAR and VARCHAR are conceptually different. 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]