Re: CHAR problem ...

2004-03-22 Thread Rafal Kedziorski
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 bu

Re: CHAR problem ...

2004-03-22 Thread Rafal Kedziorski
thx. At 13:43 22.03.2004, [EMAIL PROTECTED] wrote: Rafal Kedziorski <[EMAIL PROTECTED]> 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` > `med

Re: CHAR problem ...

2004-03-22 Thread Martijn Tonies
> > 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://ww

Re: CHAR problem ...

2004-03-22 Thread Alec . Cawley
Rafal Kedziorski <[EMAIL PROTECTED]> 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 VAR

Re: char() problem

2001-06-01 Thread Andreas Karl Wittwer
On Fri, 1 Jun 2001, Toth Dalibor wrote: > I really need to know this: I have a column defined as char(2), default > 'no', not null. > When I create new entry into the table, I skip entering value into mentioned > column > because I expect to be filled with the default value, that is 'no'. Bu