List:General Discussion« Previous MessageNext Message »
From:Hassan Shaikh Date:January 10 2004 12:06pm
Subject:Automatic conversion from `char` TO `varchar`
View as plain text  
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
Thread
Automatic conversion from `char` TO `varchar`Hassan Shaikh10 Jan
  • Re: Automatic conversion from `char` TO `varchar`Luciano Barcaro10 Jan
  • Re: Automatic conversion from `char` TO `varchar`Fred van Engen10 Jan
  • Re: Automatic conversion from `char` TO `varchar`Martijn Tonies10 Jan
    • Re: Automatic conversion from `char` TO `varchar`Michael Stassen10 Jan
  • Re: Automatic conversion from `char` TO `varchar`Martijn Tonies10 Jan
    • Re: Automatic conversion from `char` TO `varchar`Michael Stassen12 Jan
  • Re: Automatic conversion from `char` TO `varchar`Martijn Tonies12 Jan
    • Re: Automatic conversion from `char` TO `varchar`Michael Stassen12 Jan
  • Re: Automatic conversion from `char` TO `varchar`Matt W12 Jan
  • Re: Automatic conversion from `char` TO `varchar`Martijn Tonies12 Jan
  • Re: Automatic conversion from `char` TO `varchar`Bernard Kenik12 Jan