Debian Codegraph @

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

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