At 13:43 22.03.2004, [EMAIL PROTECTED] wrote:
Rafal Kedziorski <[EMAIL PROTECTED]> wrote on 22/03/2004 12:36:33:
> hi, > > 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.
Alec
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]