you seem to have mixed single and double quotes. this might be your problem
----- Original Message ----- From: "Hassan Shaikh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 10, 2004 7:06 AM Subject: Automatic conversion from `char` TO `varchar` > 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 '', # one double quote > `OFTXT` text, # single - double quote mismatch > `OFAMOUNT` decimal(12,2) NOT NULL default '0.00', # single - double quote mismatch > `OFTYPE` char(1) NOT NULL default 'P', > `OFSENTDT` datetime default NULL, # single - double quote mismatch > `OFREPLYDT` datetime default NULL, # single - double quote mismatch > `OFREPLYTXT` text, # single - double quote mismatch > `OFRESULT` char(1) NOT NULL default 'X', # single - double quote mismatch > `PID` char(10) NOT NULL default '', # one double quote > PRIMARY KEY (`SVID`) > ) TYPE=InnoDB ; > > > Would appreciate if someone could provide some insight. > > Thanks. > > > Hassan > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]