Re: Automatic conversion from `char` TO `varchar`

[Luciano Barcaro]

No, it´s not strange.
Look the manual at http://www.mysql.com/doc/en/Silent_column_changes.html

Best Regards
---
Luciano Barcaro
Depto. Informática - Laboratório Alvaro

Hassan Shaikh wrote:

>Hi,
>
>It's really strange but when I execute the following statement, all my char(10)
> columns turn into varchar(10). My other tables are ok and I've tried create dummy table
> also. Problem seems to be associated with this table only.
>
>CREATE TABLE `offer` (
>  `SVID` int(11) NOT NULL auto_increment,
>  `CUID` char(10) NOT NULL default '',
>  `OFTXT` text,
>  `OFAMOUNT` decimal(12,2) NOT NULL default '0.00',
>  `OFTYPE` char(1) NOT NULL default 'P',
>  `OFSENTDT` datetime default NULL,
>  `OFREPLYDT` datetime default NULL,
>  `OFREPLYTXT` text,
>  `OFRESULT` char(1) NOT NULL default 'X',
>  `PID` char(10) NOT NULL default '',
>  PRIMARY KEY  (`SVID`)
>) TYPE=InnoDB ;
>
>
>Would appreciate if someone could provide some insight.
>
>Thanks.
>
>
>Hassan
>  
>