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),
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
[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)
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)
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
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
6 matches
Mail list logo