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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
