List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:March 22 2004 12:56pm
Subject:Re: CHAR problem ...
View as plain text  
> > 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

Thread
CHAR problem ...Rafal Kedziorski22 Mar
  • Re: CHAR problem ...Alec.Cawley22 Mar
    • Re: CHAR problem ...Martijn Tonies22 Mar
      • Re: CHAR problem ...Rafal Kedziorski22 Mar
    • Re: CHAR problem ...Rafal Kedziorski22 Mar