At 13:56 22.03.2004, Martijn Tonies wrote:
> > > 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
yes. our CHAR columns has allways the same length.