Re: [PHP] novice: char to varchar

2005-05-19 Thread Jon Hill
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(1

Re: [PHP] novice: char to varchar

2005-05-18 Thread Philip Hallstrom
On Wed, May 18, 2005 11:15 am, tony yau said: 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 generatin

Re: [PHP] novice: char to varchar

2005-05-18 Thread Richard Lynch
On Wed, May 18, 2005 11:15 am, tony yau said: > 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 Da

Re: [PHP] novice: char to varchar

2005-05-18 Thread John Nichel
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

RE: [PHP] novice: char to varchar

2005-05-18 Thread Jay Blanchard
[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)