|
I have just tried to set the below table in a MYSQL database, but when I do the show columns from, all of the columns of which I have set to with 'CHAR', are all shown as 'VARCHAR", and the table is listed as 'dynamic' rather than 'fixed'
What is going on?
Is there some variable of which is confusing the system in some way?
CREATE TABLE watchregcontact (
wtcctsp TIMESTAMP,
wtccip CHAR(20),
wtccjacn INT UNSIGNED,
wtccrow BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
wtccdte DATETIME,
wtccmt CHAR(10),
wtccmr CHAR(8),
wtcchead CHAR(50),
wtccmbod TEXT,
wtccpd DATETIME,
wtccpb TINYTEXT,
wtccfd DATETIME,
wtccfb TEXT,
wtccpi CHAR(20),
wtccpu CHAR(30),
wtccfi CHAR(20),
wtccfu CHAR(30)
);
|