Re: novice: char to varchar
| From: | John Nichel | Date: | Wed, 18 May 2005 19:19:17 +0000 |
| Subject: | Re: novice: char to varchar | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-215519@lists.php.net to get a copy of this message | ||
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@kegworks.com