Debian Codegraph @

mysql-test/suite/jp/r/jp_where_utf8.result

raw
1 drop table if exists `T1`;
2 drop table if exists `T2`;
3 drop table if exists `T3`;
4 drop table if exists `T4`;
5 drop table if exists `T5`;
6 drop table if exists `T6`;
7 drop table if exists `T7`;
8 drop table if exists `T8`;
9 drop table if exists `T9`;
10 SET NAMES utf8;
11 Warnings:
12 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
13 SET character_set_database = utf8;
14 Warnings:
15 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
16 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
17 CREATE TABLE `T1` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
18 Warnings:
19 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
20 CREATE TABLE `T2` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
21 Warnings:
22 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
23 CREATE TABLE `T3` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
24 Warnings:
25 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
26 CREATE TABLE `T4` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
27 Warnings:
28 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
29 CREATE TABLE `T5` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
30 Warnings:
31 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
32 CREATE TABLE `T6` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
33 Warnings:
34 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
35 CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
36 Warnings:
37 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
38 CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
39 Warnings:
40 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
41 CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
42 Warnings:
43 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
44 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T1`;
45 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T2`;
46 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T3`;
47 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T4`;
48 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T5`;
49 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T6`;
50 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`;
51 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`;
52 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`;
53 SELECT * FROM `T1` WHERE `C1` = 'ーアイウエオカキクケコサシスセソ';
54 C1
55 ーアイウエオカキクケコサシスセソ
56 SELECT * FROM `T2` WHERE `C1` = '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
57 C1
58 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
59 SELECT * FROM `T3` WHERE `C1` = '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
60 C1
61 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
62 SELECT * FROM `T4` WHERE `C1` = 'ーアイウエオカキクケコサシスセソ';
63 C1
64 ーアイウエオカキクケコサシスセソ
65 SELECT * FROM `T5` WHERE `C1` = '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
66 C1
67 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
68 SELECT * FROM `T6` WHERE `C1` = '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
69 C1
70 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
71 SELECT * FROM `T7` WHERE `C1` = 'ーアイウエオカキクケコサシスセソ';
72 C1
73 ーアイウエオカキクケコサシスセソ
74 SELECT * FROM `T8` WHERE `C1` = '・ぁあぃいぅうぇえぉおかがきぎくぐけげこ';
75 C1
76 ・ぁあぃいぅうぇえぉおかがきぎくぐけげこ
77 SELECT * FROM `T9` WHERE `C1` = '鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖';
78 C1
79 鼫鼯鼱鼲鼴鼷鼹鼺鼼鼽鼿齁齃齄齅齆齇齓齕齖
80 DROP TABLE `T1`;
81 DROP TABLE `T2`;
82 DROP TABLE `T3`;
83 DROP TABLE `T4`;
84 DROP TABLE `T5`;
85 DROP TABLE `T6`;
86 DROP TABLE `T7`;
87 DROP TABLE `T8`;
88 DROP TABLE `T9`;