> > 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
