1set default_storage_engine='tokudb'; 2drop table if exists t1; 3create table t1 (c nchar(10)); 4show create table t1; 5Table Create Table 6t1 CREATE TABLE `t1` ( 7 `c` char(10) CHARACTER SET utf8 DEFAULT NULL 8) ENGINE=ENGINE DEFAULT CHARSET=latin1 9drop table t1; 10create table t1 (c national char(10)); 11show create table t1; 12Table Create Table 13t1 CREATE TABLE `t1` ( 14 `c` char(10) CHARACTER SET utf8 DEFAULT NULL 15) ENGINE=ENGINE DEFAULT CHARSET=latin1 16drop table t1; 17create table t1 (c national varchar(10)); 18show create table t1; 19Table Create Table 20t1 CREATE TABLE `t1` ( 21 `c` varchar(10) CHARACTER SET utf8 DEFAULT NULL 22) ENGINE=ENGINE DEFAULT CHARSET=latin1 23drop table t1; 24create table t1 (c nvarchar(10)); 25show create table t1; 26Table Create Table 27t1 CREATE TABLE `t1` ( 28 `c` varchar(10) CHARACTER SET utf8 DEFAULT NULL 29) ENGINE=ENGINE DEFAULT CHARSET=latin1 30drop table t1; 31create table t1 (c nchar varchar(10)); 32show create table t1; 33Table Create Table 34t1 CREATE TABLE `t1` ( 35 `c` varchar(10) CHARACTER SET utf8 DEFAULT NULL 36) ENGINE=ENGINE DEFAULT CHARSET=latin1 37drop table t1; 38create table t1 (c national character varying(10)); 39show create table t1; 40Table Create Table 41t1 CREATE TABLE `t1` ( 42 `c` varchar(10) CHARACTER SET utf8 DEFAULT NULL 43) ENGINE=ENGINE DEFAULT CHARSET=latin1 44drop table t1; 45create table t1 (c nchar varying(10)); 46show create table t1; 47Table Create Table 48t1 CREATE TABLE `t1` ( 49 `c` varchar(10) CHARACTER SET utf8 DEFAULT NULL 50) ENGINE=ENGINE DEFAULT CHARSET=latin1 51drop table t1; 52