Debian Codegraph @

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

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