Re: novice: char to varchar
| From: | tony yau | Date: | Wed, 18 May 2005 19:02:55 +0000 |
| Subject: | Re: novice: char to varchar | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-215517@lists.php.net to get a copy of this message | ||
found the answer sorry about this
"Tony Yau" <tony.yau@emigen.co.uk> wrote in message
news:20050518181658.10441.qmail@lists.php.net...
> Hi all,
>
> I try to do the following:
>
> CREATE TABLE IF NOT EXISTS Invoice(
> PKey INTEGER,
> Received DATETIME,
> Cost DECIMAL(10,2),
> FileName VARCHAR(50),
> RefNum CHAR(10),
>
> PRIMARY KEY (PKey)
> ) TYPE=MyISAM COMMENT='Invoice Data';
>
> but it keep generating RefNum VARCHAR(10) instead of CHAR(10)
>
> I don't understand, please help (or point me to RTFM page)
> Tony Yau