Debian Codegraph @

mysql-test/suite/jp/t/jp_charset_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
7 --disable_warnings
8 drop table if exists `T1`;
9 drop table if exists `T2`;
10 drop table if exists `T3`;
11 drop table if exists `T4`;
12 drop table if exists `T5`;
13 drop table if exists `T6`;
14 drop table if exists `T7`;
15 drop table if exists `T8`;
16 drop table if exists `T9`;
17 --enable_warnings
18
19 #
20 # Test CHARSET() function with Japanese characters in utf8 encoding
21 #
22
23 SET NAMES utf8;
24 SET character_set_database = utf8;
25
26 CREATE TABLE `T1` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
27 CREATE TABLE `T2` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
28 CREATE TABLE `T3` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
29 CREATE TABLE `T4` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
30 CREATE TABLE `T5` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
31 CREATE TABLE `T6` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
32 CREATE TABLE `T7` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
33 CREATE TABLE `T8` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
34 CREATE TABLE `T9` (`C1` char(20)) 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 DISTINCT CHARSET(`C1`) FROM `T1`;
53 SELECT DISTINCT CHARSET(`C1`) FROM `T2`;
54 SELECT DISTINCT CHARSET(`C1`) FROM `T3`;
55 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T1`;
56 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T1`;
57 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T1`;
58 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T1`;
59 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T2`;
60 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T2`;
61 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T2`;
62 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T2`;
63 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T3`;
64 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T3`;
65 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T3`;
66 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T3`;
67
68 #MyISAM
69 SELECT DISTINCT CHARSET(`C1`) FROM `T4`;
70 SELECT DISTINCT CHARSET(`C1`) FROM `T5`;
71 SELECT DISTINCT CHARSET(`C1`) FROM `T6`;
72 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T4`;
73 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T4`;
74 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T4`;
75 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T4`;
76 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T5`;
77 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T5`;
78 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T5`;
79 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T5`;
80 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T6`;
81 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T6`;
82 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T6`;
83 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T6`;
84
85 #MEMORY
86 SELECT DISTINCT CHARSET(`C1`) FROM `T7`;
87 SELECT DISTINCT CHARSET(`C1`) FROM `T8`;
88 SELECT DISTINCT CHARSET(`C1`) FROM `T9`;
89 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T7`;
90 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T7`;
91 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T7`;
92 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T7`;
93 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T8`;
94 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T8`;
95 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T8`;
96 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T8`;
97 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T9`;
98 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T9`;
99 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T9`;
100 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T9`;
101
102 drop table `T1`;
103 drop table `T2`;
104 drop table `T3`;
105 drop table `T4`;
106 drop table `T5`;
107 drop table `T6`;
108 drop table `T7`;
109 drop table `T8`;
110 drop table `T9`;