List:General Discussion« Previous MessageNext Message »
From:Alec.Cawley Date:March 22 2004 12:43pm
Subject:Re: CHAR problem ...
View as plain text  






Rafal Kedziorski <rafcio@stripped> 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



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