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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php