Re: novice: char to varchar

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



found the answer sorry about this

"Tony Yau" <tony.yau@xxxxxxxxxxxx> wrote in message
news:20050518181658.10441.qmail@xxxxxxxxxxxxxxxx
> 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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux