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 Warnings:
12 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
13 SET character_set_database = utf8;
14 Warnings:
15 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
16 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
17 CREATE TABLE `T1` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
18 Warnings:
19 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
20 CREATE TABLE `T2` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
21 Warnings:
22 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
23 CREATE TABLE `T3` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = innodb;
24 Warnings:
25 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
26 CREATE TABLE `T4` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
27 Warnings:
28 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
29 CREATE TABLE `T5` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
30 Warnings:
31 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
32 CREATE TABLE `T6` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = myisam;
33 Warnings:
34 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
35 CREATE TABLE `T7` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
36 Warnings:
37 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
38 CREATE TABLE `T8` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
39 Warnings:
40 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
41 CREATE TABLE `T9` (`C1` char(20)) DEFAULT CHARSET = utf8 engine = MEMORY;
42 Warnings:
43 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
44 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T1`;
45 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T2`;
46 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T3`;
47 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T4`;
48 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T5`;
49 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T6`;
50 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0201_utf8.dat' INTO TABLE `T7`;
51 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0208_utf8.dat' INTO TABLE `T8`;
52 LOAD DATA LOCAL INFILE 'suite/jp/std_data/jisx0212_utf8.dat' INTO TABLE `T9`;
53 SELECT DISTINCT CHARSET(`C1`) FROM `T1`;
54 CHARSET(`C1`)
55 utf8mb3
56 SELECT DISTINCT CHARSET(`C1`) FROM `T2`;
57 CHARSET(`C1`)
58 utf8mb3
59 SELECT DISTINCT CHARSET(`C1`) FROM `T3`;
60 CHARSET(`C1`)
61 utf8mb3
62 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T1`;
63 CHARSET(CONVERT(`C1` USING utf8))
64 utf8mb3
65 Warnings:
66 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
67 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T1`;
68 CHARSET(CONVERT(`C1` USING ucs2))
69 ucs2
70 Warnings:
71 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
72 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T1`;
73 CHARSET(CONVERT(`C1` USING sjis))
74 sjis
75 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T1`;
76 CHARSET(CONVERT(`C1` USING ujis))
77 ujis
78 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T2`;
79 CHARSET(CONVERT(`C1` USING utf8))
80 utf8mb3
81 Warnings:
82 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
83 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T2`;
84 CHARSET(CONVERT(`C1` USING ucs2))
85 ucs2
86 Warnings:
87 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
88 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T2`;
89 CHARSET(CONVERT(`C1` USING sjis))
90 sjis
91 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T2`;
92 CHARSET(CONVERT(`C1` USING ujis))
93 ujis
94 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T3`;
95 CHARSET(CONVERT(`C1` USING utf8))
96 utf8mb3
97 Warnings:
98 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
99 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T3`;
100 CHARSET(CONVERT(`C1` USING ucs2))
101 ucs2
102 Warnings:
103 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
104 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T3`;
105 CHARSET(CONVERT(`C1` USING sjis))
106 sjis
107 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T3`;
108 CHARSET(CONVERT(`C1` USING ujis))
109 ujis
110 SELECT DISTINCT CHARSET(`C1`) FROM `T4`;
111 CHARSET(`C1`)
112 utf8mb3
113 SELECT DISTINCT CHARSET(`C1`) FROM `T5`;
114 CHARSET(`C1`)
115 utf8mb3
116 SELECT DISTINCT CHARSET(`C1`) FROM `T6`;
117 CHARSET(`C1`)
118 utf8mb3
119 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T4`;
120 CHARSET(CONVERT(`C1` USING utf8))
121 utf8mb3
122 Warnings:
123 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
124 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T4`;
125 CHARSET(CONVERT(`C1` USING ucs2))
126 ucs2
127 Warnings:
128 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
129 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T4`;
130 CHARSET(CONVERT(`C1` USING sjis))
131 sjis
132 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T4`;
133 CHARSET(CONVERT(`C1` USING ujis))
134 ujis
135 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T5`;
136 CHARSET(CONVERT(`C1` USING utf8))
137 utf8mb3
138 Warnings:
139 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
140 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T5`;
141 CHARSET(CONVERT(`C1` USING ucs2))
142 ucs2
143 Warnings:
144 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
145 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T5`;
146 CHARSET(CONVERT(`C1` USING sjis))
147 sjis
148 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T5`;
149 CHARSET(CONVERT(`C1` USING ujis))
150 ujis
151 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T6`;
152 CHARSET(CONVERT(`C1` USING utf8))
153 utf8mb3
154 Warnings:
155 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
156 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T6`;
157 CHARSET(CONVERT(`C1` USING ucs2))
158 ucs2
159 Warnings:
160 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
161 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T6`;
162 CHARSET(CONVERT(`C1` USING sjis))
163 sjis
164 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T6`;
165 CHARSET(CONVERT(`C1` USING ujis))
166 ujis
167 SELECT DISTINCT CHARSET(`C1`) FROM `T7`;
168 CHARSET(`C1`)
169 utf8mb3
170 SELECT DISTINCT CHARSET(`C1`) FROM `T8`;
171 CHARSET(`C1`)
172 utf8mb3
173 SELECT DISTINCT CHARSET(`C1`) FROM `T9`;
174 CHARSET(`C1`)
175 utf8mb3
176 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T7`;
177 CHARSET(CONVERT(`C1` USING utf8))
178 utf8mb3
179 Warnings:
180 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
181 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T7`;
182 CHARSET(CONVERT(`C1` USING ucs2))
183 ucs2
184 Warnings:
185 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
186 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T7`;
187 CHARSET(CONVERT(`C1` USING sjis))
188 sjis
189 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T7`;
190 CHARSET(CONVERT(`C1` USING ujis))
191 ujis
192 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T8`;
193 CHARSET(CONVERT(`C1` USING utf8))
194 utf8mb3
195 Warnings:
196 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
197 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T8`;
198 CHARSET(CONVERT(`C1` USING ucs2))
199 ucs2
200 Warnings:
201 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
202 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T8`;
203 CHARSET(CONVERT(`C1` USING sjis))
204 sjis
205 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T8`;
206 CHARSET(CONVERT(`C1` USING ujis))
207 ujis
208 SELECT DISTINCT CHARSET(CONVERT(`C1` USING utf8)) FROM `T9`;
209 CHARSET(CONVERT(`C1` USING utf8))
210 utf8mb3
211 Warnings:
212 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
213 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ucs2)) FROM `T9`;
214 CHARSET(CONVERT(`C1` USING ucs2))
215 ucs2
216 Warnings:
217 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
218 SELECT DISTINCT CHARSET(CONVERT(`C1` USING sjis)) FROM `T9`;
219 CHARSET(CONVERT(`C1` USING sjis))
220 sjis
221 SELECT DISTINCT CHARSET(CONVERT(`C1` USING ujis)) FROM `T9`;
222 CHARSET(CONVERT(`C1` USING ujis))
223 ujis
224 drop table `T1`;
225 drop table `T2`;
226 drop table `T3`;
227 drop table `T4`;
228 drop table `T5`;
229 drop table `T6`;
230 drop table `T7`;
231 drop table `T8`;
232 drop table `T9`;