1SET NAMES utf8; 2CREATE TABLE t1 (c1 VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_thai_520_w2) 3PARTITION BY KEY(c1) PARTITIONS 3; 4SHOW CREATE TABLE t1; 5Table Create Table 6t1 CREATE TABLE `t1` ( 7 `c1` varchar(10) CHARACTER SET utf8 COLLATE utf8_thai_520_w2 DEFAULT NULL 8) ENGINE=MyISAM DEFAULT CHARSET=latin1 9 PARTITION BY KEY (`c1`) 10PARTITIONS 3 11INSERT INTO t1 VALUES ('A'),('À'),('Á'),('Â'),('Ã'),('Ä'),('Å'); 12INSERT INTO t1 VALUES ('B'); 13INSERT INTO t1 VALUES ('C'); 14INSERT INTO t1 VALUES ('D'); 15INSERT INTO t1 VALUES ('E'); 16INSERT INTO t1 VALUES ('F'); 17INSERT INTO t1 VALUES ('G'); 18INSERT INTO t1 VALUES ('H'); 19INSERT INTO t1 VALUES ('I'); 20INSERT INTO t1 VALUES ('J'); 21INSERT INTO t1 VALUES ('K'); 22INSERT INTO t1 VALUES ('L'),('Ĺ'),('Ļ'),('Ľ'),('Ŀ'),('Ł'); 23INSERT INTO t1 VALUES ('M'); 24INSERT INTO t1 VALUES ('N'); 25INSERT INTO t1 VALUES ('O'),('Ò'),('Ó'),('Ô'),('Õ'),('Ö'),('Ø'); 26INSERT INTO t1 VALUES ('P'); 27INSERT INTO t1 VALUES ('Q'); 28INSERT INTO t1 VALUES ('R'); 29INSERT INTO t1 VALUES ('S'); 30INSERT INTO t1 VALUES ('T'); 31INSERT INTO t1 VALUES ('U'); 32INSERT INTO t1 VALUES ('V'); 33INSERT INTO t1 VALUES ('W'); 34INSERT INTO t1 VALUES ('X'); 35INSERT INTO t1 VALUES ('Y'); 36INSERT INTO t1 VALUES ('Z'); 37SELECT * FROM t1 PARTITION (p0) ORDER BY c1; 38c1 39J 40K 41L 42Ĺ 43Ľ 44Ļ 45Ł 46Ŀ 47M 48Q 49R 50T 51V 52X 53SELECT * FROM t1 PARTITION (p1) ORDER BY c1; 54c1 55A 56Á 57À 58Â 59Å 60Ä 61Ã 62D 63E 64F 65G 66I 67N 68S 69U 70W 71Z 72SELECT * FROM t1 PARTITION (p2) ORDER BY c1; 73c1 74B 75C 76H 77O 78Ó 79Ò 80Ô 81Ö 82Õ 83Ø 84P 85Y 86DROP TABLE t1; 87