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