1
drop table if exists t1;
2
create table t1 (c nchar(10));
6
`c` char(10) CHARACTER SET utf8 DEFAULT NULL
7
) ENGINE=MyISAM DEFAULT CHARSET=latin1
9
create table t1 (c national char(10));
12
t1 CREATE TABLE `t1` (
13
`c` char(10) CHARACTER SET utf8 DEFAULT NULL
14
) ENGINE=MyISAM DEFAULT CHARSET=latin1
16
create table t1 (c national varchar(10));
19
t1 CREATE TABLE `t1` (
20
`c` varchar(10) CHARACTER SET utf8 DEFAULT NULL
21
) ENGINE=MyISAM DEFAULT CHARSET=latin1
23
create table t1 (c nvarchar(10));
26
t1 CREATE TABLE `t1` (
27
`c` varchar(10) CHARACTER SET utf8 DEFAULT NULL
28
) ENGINE=MyISAM DEFAULT CHARSET=latin1
30
create table t1 (c nchar varchar(10));
33
t1 CREATE TABLE `t1` (
34
`c` varchar(10) CHARACTER SET utf8 DEFAULT NULL
35
) ENGINE=MyISAM DEFAULT CHARSET=latin1
37
create table t1 (c national character varying(10));
40
t1 CREATE TABLE `t1` (
41
`c` varchar(10) CHARACTER SET utf8 DEFAULT NULL
42
) ENGINE=MyISAM DEFAULT CHARSET=latin1
44
create table t1 (c nchar varying(10));
47
t1 CREATE TABLE `t1` (
48
`c` varchar(10) CHARACTER SET utf8 DEFAULT NULL
49
) ENGINE=MyISAM DEFAULT CHARSET=latin1