DROP TABLE IF EXISTS t6; CREATE TABLE t6(c1 CHAR(0) NULL); SHOW TABLES; Tables_in_test t6 SHOW CREATE TABLE t6; Table Create Table t6 CREATE TABLE `t6` ( `c1` char(0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t6; SHOW TABLES; Tables_in_test CREATE TABLE t6(c1 VARCHAR(0) NULL); SHOW TABLES; Tables_in_test t6 SHOW CREATE TABLE t6; Table Create Table t6 CREATE TABLE `t6` ( `c1` varchar(0) DEFAULT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t6; SHOW TABLES; Tables_in_test CREATE TABLE t6(c1 CHAR(0) NOT NULL); SHOW TABLES; Tables_in_test t6 SHOW CREATE TABLE t6; Table Create Table t6 CREATE TABLE `t6` ( `c1` char(0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t6; SHOW TABLES; Tables_in_test CREATE TABLE t6(c1 VARCHAR(0) NOT NULL); SHOW TABLES; Tables_in_test t6 SHOW CREATE TABLE t6; Table Create Table t6 CREATE TABLE `t6` ( `c1` varchar(0) NOT NULL ) ENGINE=ENGINE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t6; SHOW TABLES; Tables_in_test