List:General Discussion« Previous MessageNext Message »
From:Rafal Kedziorski Date:March 22 2004 1:35pm
Subject:Re: CHAR problem ...
View as plain text  
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
>conceptually different.

yes. our CHAR columns has allways the same length. 

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