Re: novice: char to varchar

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

 



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)

How about the MySQL website, and/or a MySQL mailing list?

--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@xxxxxxxxxxxx

--
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