1
DROP TABLE IF EXISTS t14;
2
CREATE TABLE t14(c1 CHAR(10) NULL DEFAULT 'x');
8
t14 CREATE TABLE `t14` (
9
`c1` char(10) DEFAULT 'x'
10
) ENGINE=ENGINE DEFAULT CHARSET=latin1
14
CREATE TABLE t14(c1 VARCHAR(10) NULL DEFAULT 'x');
18
SHOW CREATE TABLE t14;
20
t14 CREATE TABLE `t14` (
21
`c1` varchar(10) DEFAULT 'x'
22
) ENGINE=ENGINE DEFAULT CHARSET=latin1
26
CREATE TABLE t14(c1 BINARY(10) NULL DEFAULT 'x');
30
SHOW CREATE TABLE t14;
32
t14 CREATE TABLE `t14` (
33
`c1` binary(10) DEFAULT 'x\0\0\0\0\0\0\0\0\0'
34
) ENGINE=ENGINE DEFAULT CHARSET=latin1
38
CREATE TABLE t14(c1 VARBINARY(10) NULL DEFAULT 'x');
42
SHOW CREATE TABLE t14;
44
t14 CREATE TABLE `t14` (
45
`c1` varbinary(10) DEFAULT 'x'
46
) ENGINE=ENGINE DEFAULT CHARSET=latin1
50
CREATE TABLE t14(c1 CHAR(10) NOT NULL DEFAULT 'x');
54
SHOW CREATE TABLE t14;
56
t14 CREATE TABLE `t14` (
57
`c1` char(10) NOT NULL DEFAULT 'x'
58
) ENGINE=ENGINE DEFAULT CHARSET=latin1
62
CREATE TABLE t14(c1 VARCHAR(10) NOT NULL DEFAULT 'x');
66
SHOW CREATE TABLE t14;
68
t14 CREATE TABLE `t14` (
69
`c1` varchar(10) NOT NULL DEFAULT 'x'
70
) ENGINE=ENGINE DEFAULT CHARSET=latin1
74
CREATE TABLE t14(c1 BINARY(10) NOT NULL DEFAULT 'x');
78
SHOW CREATE TABLE t14;
80
t14 CREATE TABLE `t14` (
81
`c1` binary(10) NOT NULL DEFAULT 'x\0\0\0\0\0\0\0\0\0'
82
) ENGINE=ENGINE DEFAULT CHARSET=latin1
86
CREATE TABLE t14(c1 VARBINARY(10) NOT NULL DEFAULT 'x');
90
SHOW CREATE TABLE t14;
92
t14 CREATE TABLE `t14` (
93
`c1` varbinary(10) NOT NULL DEFAULT 'x'
94
) ENGINE=ENGINE DEFAULT CHARSET=latin1