> > 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.
> 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
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL