Re: novice: char to varchar
| From: | Jon Hill | Date: | Thu, 19 May 2005 11:41:40 +0000 |
| Subject: | Re: novice: char to varchar | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-215581@lists.php.net to get a copy of this message | ||
You can't mix CHAR and VARCHAR types in the same table.
jon
On Wednesday 18 May 2005 19:15, tony yau wrote:
> 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