Debian Codegraph @

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

raw
1 --source include/have_sjis.inc
2 --source include/have_ucs2.inc
3 --source include/have_ujis.inc
4 --source include/have_utf8.inc
5 --source include/have_innodb.inc
6 --disable_warnings
7 drop table if exists `T1`;
8 drop table if exists `T2`;
9 drop table if exists `T3`;
10 drop table if exists `T4`;
11 drop table if exists `T5`;
12 drop table if exists `T6`;
13 drop table if exists `T7`;
14 drop table if exists `T8`;
15 drop table if exists `T9`;
16 --enable_warnings
17
18 #
19 # Test CONVERT() function with Japanese character in utf8 encoding
20 #
21
22 SET character_set_collations='utf8mb3=utf8mb3_general_ci';
23 SET NAMES utf8;
24 SET character_set_database = utf8;
25
26 CREATE TABLE `T1` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
27 CREATE TABLE `T2` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
28 CREATE TABLE `T3` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = innodb;
29 CREATE TABLE `T4` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
30 CREATE TABLE `T5` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
31 CREATE TABLE `T6` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = myisam;
32 CREATE TABLE `T7` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
33 CREATE TABLE `T8` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
34 CREATE TABLE `T9` (`C1` char(20), INDEX(`C1`)) DEFAULT CHARSET = utf8 engine = MEMORY;
35
36 #Load the following data in each table
37 # jisx0201 hankaku-katakana data
38 # jisx0208 data
39 # jisx0212 supplemental character data
40
41 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T1`;
42 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T2`;
43 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T3`;
44 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T4`;
45 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T5`;
46 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T6`;
47 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`;
48 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`;
49 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`;
50
51 #InnoDB
52 SELECT `C1`, CONVERT(`C1` using ujis) FROM `T1`;
53 SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T1`;
54 SELECT `C1`, CONVERT(`C1` using sjis) FROM `T1`;
55 SELECT `C1`, CONVERT(`C1` using ujis) FROM `T2`;
56 SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T2`;
57 SELECT `C1`, CONVERT(`C1` using sjis) FROM `T2`;
58 SELECT `C1`, CONVERT(`C1` using ujis) FROM `T3`;
59 SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T3`;
60 # The result will get garbled because jisx0212 is not included in sjis
61 SELECT `C1`, CONVERT(`C1` using sjis) FROM `T3`;
62
63 #MyISAM
64 SELECT `C1`, CONVERT(`C1` using ujis) FROM `T4`;
65 SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T4`;
66 SELECT `C1`, CONVERT(`C1` using sjis) FROM `T4`;
67 SELECT `C1`, CONVERT(`C1` using ujis) FROM `T5`;
68 SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T5`;
69 SELECT `C1`, CONVERT(`C1` using sjis) FROM `T5`;
70 SELECT `C1`, CONVERT(`C1` using ujis) FROM `T6`;
71 SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T6`;
72 # The result will get garbled because jisx0212 is not included in sjis
73 SELECT `C1`, CONVERT(`C1` using sjis) FROM `T6`;
74
75 #MEMORY
76 SELECT `C1`, CONVERT(`C1` using ujis) FROM `T7`;
77 SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T7`;
78 SELECT `C1`, CONVERT(`C1` using sjis) FROM `T7`;
79 SELECT `C1`, CONVERT(`C1` using ujis) FROM `T8`;
80 SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T8`;
81 SELECT `C1`, CONVERT(`C1` using sjis) FROM `T8`;
82 SELECT `C1`, CONVERT(`C1` using ujis) FROM `T9`;
83 SELECT `C1`, CONVERT(`C1` using ucs2) FROM `T9`;
84 # The result will get garbled because jisx0212 is not included in sjis
85 SELECT `C1`, CONVERT(`C1` using sjis) FROM `T9`;
86
87 drop table `T1`;
88 drop table `T2`;
89 drop table `T3`;
90 drop table `T4`;
91 drop table `T5`;
92 drop table `T6`;
93 drop table `T7`;
94 drop table `T8`;
95 drop table `T9`;