Debian Codegraph @

mysql-test/suite/jp/r/jp_charset_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 SET character_set_database = utf8;
12 CREATE TABLE `T1` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
13 CREATE TABLE `T2` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
14 CREATE TABLE `T3` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
15 CREATE TABLE `T4` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
16 CREATE TABLE `T5` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
17 CREATE TABLE `T6` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
18 CREATE TABLE `T7` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
19 CREATE TABLE `T8` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
20 CREATE TABLE `T9` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
21 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T1`;
22 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T2`;
23 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T3`;
24 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T4`;
25 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T5`;
26 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T6`;
27 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`;
28 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`;
29 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`;
30 SELECT DISTINCT CHARSET(`C1`) FROM `T1`;
31 CHARSET(`C1`)
32 utf8mb3
33 SELECT DISTINCT CHARSET(`C1`) FROM `T2`;
34 CHARSET(`C1`)
35 utf8mb3
36 SELECT DISTINCT CHARSET(`C1`) FROM `T3`;
37 CHARSET(`C1`)
38 utf8mb3
39 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T1`;
40 CHARSET(CONVERT(`C1` USING utf8))
41 utf8mb3
42 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T1`;
43 CHARSET(CONVERT(`C1` USING ucs2))
44 ucs2
45 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T1`;
46 CHARSET(CONVERT(`C1` USING sjis))
47 sjis
48 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T1`;
49 CHARSET(CONVERT(`C1` USING ujis))
50 ujis
51 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T2`;
52 CHARSET(CONVERT(`C1` USING utf8))
53 utf8mb3
54 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T2`;
55 CHARSET(CONVERT(`C1` USING ucs2))
56 ucs2
57 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T2`;
58 CHARSET(CONVERT(`C1` USING sjis))
59 sjis
60 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T2`;
61 CHARSET(CONVERT(`C1` USING ujis))
62 ujis
63 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T3`;
64 CHARSET(CONVERT(`C1` USING utf8))
65 utf8mb3
66 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T3`;
67 CHARSET(CONVERT(`C1` USING ucs2))
68 ucs2
69 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T3`;
70 CHARSET(CONVERT(`C1` USING sjis))
71 sjis
72 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T3`;
73 CHARSET(CONVERT(`C1` USING ujis))
74 ujis
75 SELECT DISTINCT CHARSET(`C1`) FROM `T4`;
76 CHARSET(`C1`)
77 utf8mb3
78 SELECT DISTINCT CHARSET(`C1`) FROM `T5`;
79 CHARSET(`C1`)
80 utf8mb3
81 SELECT DISTINCT CHARSET(`C1`) FROM `T6`;
82 CHARSET(`C1`)
83 utf8mb3
84 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T4`;
85 CHARSET(CONVERT(`C1` USING utf8))
86 utf8mb3
87 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T4`;
88 CHARSET(CONVERT(`C1` USING ucs2))
89 ucs2
90 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T4`;
91 CHARSET(CONVERT(`C1` USING sjis))
92 sjis
93 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T4`;
94 CHARSET(CONVERT(`C1` USING ujis))
95 ujis
96 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T5`;
97 CHARSET(CONVERT(`C1` USING utf8))
98 utf8mb3
99 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T5`;
100 CHARSET(CONVERT(`C1` USING ucs2))
101 ucs2
102 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T5`;
103 CHARSET(CONVERT(`C1` USING sjis))
104 sjis
105 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T5`;
106 CHARSET(CONVERT(`C1` USING ujis))
107 ujis
108 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T6`;
109 CHARSET(CONVERT(`C1` USING utf8))
110 utf8mb3
111 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T6`;
112 CHARSET(CONVERT(`C1` USING ucs2))
113 ucs2
114 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T6`;
115 CHARSET(CONVERT(`C1` USING sjis))
116 sjis
117 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T6`;
118 CHARSET(CONVERT(`C1` USING ujis))
119 ujis
120 SELECT DISTINCT CHARSET(`C1`) FROM `T7`;
121 CHARSET(`C1`)
122 utf8mb3
123 SELECT DISTINCT CHARSET(`C1`) FROM `T8`;
124 CHARSET(`C1`)
125 utf8mb3
126 SELECT DISTINCT CHARSET(`C1`) FROM `T9`;
127 CHARSET(`C1`)
128 utf8mb3
129 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T7`;
130 CHARSET(CONVERT(`C1` USING utf8))
131 utf8mb3
132 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T7`;
133 CHARSET(CONVERT(`C1` USING ucs2))
134 ucs2
135 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T7`;
136 CHARSET(CONVERT(`C1` USING sjis))
137 sjis
138 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T7`;
139 CHARSET(CONVERT(`C1` USING ujis))
140 ujis
141 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T8`;
142 CHARSET(CONVERT(`C1` USING utf8))
143 utf8mb3
144 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T8`;
145 CHARSET(CONVERT(`C1` USING ucs2))
146 ucs2
147 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T8`;
148 CHARSET(CONVERT(`C1` USING sjis))
149 sjis
150 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T8`;
151 CHARSET(CONVERT(`C1` USING ujis))
152 ujis
153 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T9`;
154 CHARSET(CONVERT(`C1` USING utf8))
155 utf8mb3
156 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T9`;
157 CHARSET(CONVERT(`C1` USING ucs2))
158 ucs2
159 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T9`;
160 CHARSET(CONVERT(`C1` USING sjis))
161 sjis
162 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T9`;
163 CHARSET(CONVERT(`C1` USING ujis))
164 ujis
165 drop table `T1`;
166 drop table `T2`;
167 drop table `T3`;
168 drop table `T4`;
169 drop table `T5`;
170 drop table `T6`;
171 drop table `T7`;
172 drop table `T8`;
173 drop table `T9`;