Debian Codegraph @

mysql-test/suite/jp/t/jp_where_utf8.test

raw
1 --source include/have_utf8.inc
2 --source include/have_innodb.inc
3 --disable_warnings
4 drop table if exists `T1`;
5 drop table if exists `T2`;
6 drop table if exists `T3`;
7 drop table if exists `T4`;
8 drop table if exists `T5`;
9 drop table if exists `T6`;
10 drop table if exists `T7`;
11 drop table if exists `T8`;
12 drop table if exists `T9`;
13 --enable_warnings
14
15 #
16 # Test Displaying Japanese charact using WHERE condition in utf8 encoding
17 #
18
19 SET character_set_collations='utf8mb3=utf8mb3_general_ci';
20 SET NAMES utf8;
21 SET character_set_database = utf8;
22
23 CREATE TABLE `T1` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
24 CREATE TABLE `T2` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
25 CREATE TABLE `T3` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
26 CREATE TABLE `T4` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27 CREATE TABLE `T5` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
28 CREATE TABLE `T6` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
29 CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
30 CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
31 CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
32
33 #Load the following data in each table
34 # jisx0201 hankaku-katakana data
35 # jisx0208 data
36 # jisx0212 supplemental character data
37
38 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T1`;
39 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T2`;
40 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T3`;
41 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T4`;
42 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T5`;
43 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T6`;
44 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`;
45 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`;
46 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`;
47
48 #InnoDB
49 SELECT * FROM `T1` WHERE `C1` = 'ーアイウエオカキクケコサシスセソ';
50 SELECT * FROM `T2` WHERE `C1` = '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
51 SELECT * FROM `T3` WHERE `C1` = '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
52
53 #MyISAM
54 SELECT * FROM `T4` WHERE `C1` = 'ーアイウエオカキクケコサシスセソ';
55 SELECT * FROM `T5` WHERE `C1` = '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
56 SELECT * FROM `T6` WHERE `C1` = '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
57
58 #MEMORY
59 SELECT * FROM `T7` WHERE `C1` = 'ーアイウエオカキクケコサシスセソ';
60 SELECT * FROM `T8` WHERE `C1` = '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
61 SELECT * FROM `T9` WHERE `C1` = '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
62
63 DROP TABLE `T1`;
64 DROP TABLE `T2`;
65 DROP TABLE `T3`;
66 DROP TABLE `T4`;
67 DROP TABLE `T5`;
68 DROP TABLE `T6`;
69 DROP TABLE `T7`;
70 DROP TABLE `T8`;
71 DROP TABLE `T9`;