RE: [PHP] novice: char to varchar
| From: | Jay Blanchard | Date: | Wed, 18 May 2005 19:16:03 +0000 |
| Subject: | RE: [PHP] novice: char to varchar | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-215518@lists.php.net to get a copy of this message | ||
[snip]
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)
[/snip]
http://www.mysql.com