Posted by Jon Hill on 11/26/00 11:16

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

• Next in forum: Re: [PHP] Refresh (F5) adds another SQL record.
• Prev in forum: Re: multiple inserts into a db
• Thread view: Re: [PHP] novice: char to varchar

[Reply to this message]