List:General Discussion« Previous MessageNext Message »
From:Rafal Kedziorski Date:March 22 2004 1:33pm
Subject:Re: CHAR problem ...
View as plain text  
thx.

At 13:43 22.03.2004, Alec.Cawley@stripped wrote:







>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
>
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

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