List:General Discussion« Previous MessageNext Message »
From:Luciano Barcaro Date:January 10 2004 2:59pm
Subject:Re: Automatic conversion from `char` TO `varchar`
View as plain text  
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
>  
>

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