List:General Discussion« Previous MessageNext Message »
From:Bernard Kenik Date:January 12 2004 6:15pm
Subject:Re: Automatic conversion from `char` TO `varchar`
View as plain text  
you seem to have mixed single and double quotes.
this might be your problem

----- Original Message ----- 
From: "Hassan Shaikh" <hassan@stripped>
To: <mysql@stripped>; <win32@stripped>
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
>

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