Automatic conversion from `char` TO `varchar`

[Hassan Shaikh]

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