Debian Codegraph @

mysql-test/suite/engines/funcs/r/db_alter_character_set.result

raw
1 DROP DATABASE IF EXISTS d8;
2 SHOW CHARACTER SET;
3 Charset Description Default collation Maxlen
4 big5 Big5 Traditional Chinese big5_chinese_ci 2
5 dec8 DEC West European dec8_swedish_ci 1
6 cp850 DOS West European cp850_general_ci 1
7 hp8 HP West European hp8_english_ci 1
8 koi8r KOI8-R Relcom Russian koi8r_general_ci 1
9 latin1 cp1252 West European latin1_swedish_ci 1
10 latin2 ISO 8859-2 Central European latin2_general_ci 1
11 swe7 7bit Swedish swe7_swedish_ci 1
12 ascii US ASCII ascii_general_ci 1
13 ujis EUC-JP Japanese ujis_japanese_ci 3
14 sjis Shift-JIS Japanese sjis_japanese_ci 2
15 hebrew ISO 8859-8 Hebrew hebrew_general_ci 1
16 tis620 TIS620 Thai tis620_thai_ci 1
17 euckr EUC-KR Korean euckr_korean_ci 2
18 koi8u KOI8-U Ukrainian koi8u_general_ci 1
19 gb2312 GB2312 Simplified Chinese gb2312_chinese_ci 2
20 greek ISO 8859-7 Greek greek_general_ci 1
21 cp1250 Windows Central European cp1250_general_ci 1
22 gbk GBK Simplified Chinese gbk_chinese_ci 2
23 latin5 ISO 8859-9 Turkish latin5_turkish_ci 1
24 armscii8 ARMSCII-8 Armenian armscii8_general_ci 1
25 utf8mb3 UTF-8 Unicode utf8mb3_uca1400_ai_ci 3
26 ucs2 UCS-2 Unicode ucs2_uca1400_ai_ci 2
27 cp866 DOS Russian cp866_general_ci 1
28 keybcs2 DOS Kamenicky Czech-Slovak keybcs2_general_ci 1
29 macce Mac Central European macce_general_ci 1
30 macroman Mac West European macroman_general_ci 1
31 cp852 DOS Central European cp852_general_ci 1
32 latin7 ISO 8859-13 Baltic latin7_general_ci 1
33 utf8mb4 UTF-8 Unicode utf8mb4_uca1400_ai_ci 4
34 cp1251 Windows Cyrillic cp1251_general_ci 1
35 utf16 UTF-16 Unicode utf16_uca1400_ai_ci 4
36 utf16le UTF-16LE Unicode utf16le_general_ci 4
37 cp1256 Windows Arabic cp1256_general_ci 1
38 cp1257 Windows Baltic cp1257_general_ci 1
39 utf32 UTF-32 Unicode utf32_uca1400_ai_ci 4
40 binary Binary pseudo charset binary 1
41 geostd8 GEOSTD8 Georgian geostd8_general_ci 1
42 cp932 SJIS for Windows Japanese cp932_japanese_ci 2
43 eucjpms UJIS for Windows Japanese eucjpms_japanese_ci 3
44 CREATE DATABASE d8;
45 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
46 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
47 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
48 def information_schema utf8mb3 utf8mb3_general_ci NULL
49 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
50 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
51 def performance_schema utf8mb3 utf8mb3_general_ci NULL
52 def sys utf8mb3 utf8mb3_general_ci NULL
53 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
54 ALTER DATABASE d8 CHARACTER SET ascii;
55 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
56 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
57 def d8 ascii ascii_general_ci NULL
58 def information_schema utf8mb3 utf8mb3_general_ci NULL
59 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
60 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
61 def performance_schema utf8mb3 utf8mb3_general_ci NULL
62 def sys utf8mb3 utf8mb3_general_ci NULL
63 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
64 DROP DATABASE d8;
65 CREATE DATABASE d8;
66 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
67 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
68 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
69 def information_schema utf8mb3 utf8mb3_general_ci NULL
70 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
71 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
72 def performance_schema utf8mb3 utf8mb3_general_ci NULL
73 def sys utf8mb3 utf8mb3_general_ci NULL
74 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
75 ALTER DATABASE d8 CHARACTER SET utf8;
76 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
77 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
78 def d8 utf8mb3 utf8mb3_uca1400_ai_ci NULL
79 def information_schema utf8mb3 utf8mb3_general_ci NULL
80 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
81 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
82 def performance_schema utf8mb3 utf8mb3_general_ci NULL
83 def sys utf8mb3 utf8mb3_general_ci NULL
84 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
85 DROP DATABASE d8;
86 CREATE DATABASE d8;
87 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
88 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
89 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
90 def information_schema utf8mb3 utf8mb3_general_ci NULL
91 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
92 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
93 def performance_schema utf8mb3 utf8mb3_general_ci NULL
94 def sys utf8mb3 utf8mb3_general_ci NULL
95 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
96 ALTER DATABASE d8 CHARACTER SET binary;
97 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
98 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
99 def d8 binary binary NULL
100 def information_schema utf8mb3 utf8mb3_general_ci NULL
101 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
102 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
103 def performance_schema utf8mb3 utf8mb3_general_ci NULL
104 def sys utf8mb3 utf8mb3_general_ci NULL
105 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
106 DROP DATABASE d8;
107 CREATE DATABASE d8;
108 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
109 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
110 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
111 def information_schema utf8mb3 utf8mb3_general_ci NULL
112 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
113 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
114 def performance_schema utf8mb3 utf8mb3_general_ci NULL
115 def sys utf8mb3 utf8mb3_general_ci NULL
116 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
117 ALTER DATABASE d8 CHARACTER SET swe7;
118 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
119 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
120 def d8 swe7 swe7_swedish_ci NULL
121 def information_schema utf8mb3 utf8mb3_general_ci NULL
122 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
123 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
124 def performance_schema utf8mb3 utf8mb3_general_ci NULL
125 def sys utf8mb3 utf8mb3_general_ci NULL
126 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
127 DROP DATABASE d8;
128 CREATE DATABASE d8;
129 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
130 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
131 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
132 def information_schema utf8mb3 utf8mb3_general_ci NULL
133 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
134 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
135 def performance_schema utf8mb3 utf8mb3_general_ci NULL
136 def sys utf8mb3 utf8mb3_general_ci NULL
137 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
138 ALTER DATABASE d8 CHARACTER SET cp1251;
139 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
140 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
141 def d8 cp1251 cp1251_general_ci NULL
142 def information_schema utf8mb3 utf8mb3_general_ci NULL
143 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
144 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
145 def performance_schema utf8mb3 utf8mb3_general_ci NULL
146 def sys utf8mb3 utf8mb3_general_ci NULL
147 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
148 DROP DATABASE d8;
149 CREATE DATABASE d8;
150 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
151 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
152 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
153 def information_schema utf8mb3 utf8mb3_general_ci NULL
154 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
155 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
156 def performance_schema utf8mb3 utf8mb3_general_ci NULL
157 def sys utf8mb3 utf8mb3_general_ci NULL
158 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
159 ALTER DATABASE d8 DEFAULT CHARACTER SET ascii;
160 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
161 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
162 def d8 ascii ascii_general_ci NULL
163 def information_schema utf8mb3 utf8mb3_general_ci NULL
164 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
165 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
166 def performance_schema utf8mb3 utf8mb3_general_ci NULL
167 def sys utf8mb3 utf8mb3_general_ci NULL
168 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
169 DROP DATABASE d8;
170 CREATE DATABASE d8;
171 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
172 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
173 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
174 def information_schema utf8mb3 utf8mb3_general_ci NULL
175 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
176 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
177 def performance_schema utf8mb3 utf8mb3_general_ci NULL
178 def sys utf8mb3 utf8mb3_general_ci NULL
179 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
180 ALTER DATABASE d8 DEFAULT CHARACTER SET utf8;
181 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
182 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
183 def d8 utf8mb3 utf8mb3_uca1400_ai_ci NULL
184 def information_schema utf8mb3 utf8mb3_general_ci NULL
185 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
186 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
187 def performance_schema utf8mb3 utf8mb3_general_ci NULL
188 def sys utf8mb3 utf8mb3_general_ci NULL
189 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
190 DROP DATABASE d8;
191 CREATE DATABASE d8;
192 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
193 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
194 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
195 def information_schema utf8mb3 utf8mb3_general_ci NULL
196 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
197 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
198 def performance_schema utf8mb3 utf8mb3_general_ci NULL
199 def sys utf8mb3 utf8mb3_general_ci NULL
200 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
201 ALTER DATABASE d8 DEFAULT CHARACTER SET binary;
202 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
203 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
204 def d8 binary binary NULL
205 def information_schema utf8mb3 utf8mb3_general_ci NULL
206 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
207 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
208 def performance_schema utf8mb3 utf8mb3_general_ci NULL
209 def sys utf8mb3 utf8mb3_general_ci NULL
210 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
211 DROP DATABASE d8;
212 CREATE DATABASE d8;
213 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
214 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
215 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
216 def information_schema utf8mb3 utf8mb3_general_ci NULL
217 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
218 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
219 def performance_schema utf8mb3 utf8mb3_general_ci NULL
220 def sys utf8mb3 utf8mb3_general_ci NULL
221 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
222 ALTER DATABASE d8 DEFAULT CHARACTER SET swe7;
223 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
224 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
225 def d8 swe7 swe7_swedish_ci NULL
226 def information_schema utf8mb3 utf8mb3_general_ci NULL
227 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
228 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
229 def performance_schema utf8mb3 utf8mb3_general_ci NULL
230 def sys utf8mb3 utf8mb3_general_ci NULL
231 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
232 DROP DATABASE d8;
233 CREATE DATABASE d8;
234 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
235 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
236 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
237 def information_schema utf8mb3 utf8mb3_general_ci NULL
238 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
239 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
240 def performance_schema utf8mb3 utf8mb3_general_ci NULL
241 def sys utf8mb3 utf8mb3_general_ci NULL
242 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
243 ALTER DATABASE d8 DEFAULT CHARACTER SET cp1251;
244 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
245 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
246 def d8 cp1251 cp1251_general_ci NULL
247 def information_schema utf8mb3 utf8mb3_general_ci NULL
248 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
249 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
250 def performance_schema utf8mb3 utf8mb3_general_ci NULL
251 def sys utf8mb3 utf8mb3_general_ci NULL
252 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
253 DROP DATABASE d8;
254 CREATE DATABASE d8;
255 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
256 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
257 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
258 def information_schema utf8mb3 utf8mb3_general_ci NULL
259 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
260 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
261 def performance_schema utf8mb3 utf8mb3_general_ci NULL
262 def sys utf8mb3 utf8mb3_general_ci NULL
263 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
264 ALTER SCHEMA d8 CHARACTER SET ascii;
265 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
266 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
267 def d8 ascii ascii_general_ci NULL
268 def information_schema utf8mb3 utf8mb3_general_ci NULL
269 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
270 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
271 def performance_schema utf8mb3 utf8mb3_general_ci NULL
272 def sys utf8mb3 utf8mb3_general_ci NULL
273 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
274 DROP DATABASE d8;
275 CREATE DATABASE d8;
276 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
277 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
278 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
279 def information_schema utf8mb3 utf8mb3_general_ci NULL
280 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
281 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
282 def performance_schema utf8mb3 utf8mb3_general_ci NULL
283 def sys utf8mb3 utf8mb3_general_ci NULL
284 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
285 ALTER SCHEMA d8 CHARACTER SET utf8;
286 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
287 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
288 def d8 utf8mb3 utf8mb3_uca1400_ai_ci NULL
289 def information_schema utf8mb3 utf8mb3_general_ci NULL
290 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
291 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
292 def performance_schema utf8mb3 utf8mb3_general_ci NULL
293 def sys utf8mb3 utf8mb3_general_ci NULL
294 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
295 DROP DATABASE d8;
296 CREATE DATABASE d8;
297 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
298 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
299 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
300 def information_schema utf8mb3 utf8mb3_general_ci NULL
301 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
302 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
303 def performance_schema utf8mb3 utf8mb3_general_ci NULL
304 def sys utf8mb3 utf8mb3_general_ci NULL
305 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
306 ALTER SCHEMA d8 CHARACTER SET binary;
307 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
308 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
309 def d8 binary binary NULL
310 def information_schema utf8mb3 utf8mb3_general_ci NULL
311 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
312 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
313 def performance_schema utf8mb3 utf8mb3_general_ci NULL
314 def sys utf8mb3 utf8mb3_general_ci NULL
315 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
316 DROP DATABASE d8;
317 CREATE DATABASE d8;
318 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
319 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
320 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
321 def information_schema utf8mb3 utf8mb3_general_ci NULL
322 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
323 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
324 def performance_schema utf8mb3 utf8mb3_general_ci NULL
325 def sys utf8mb3 utf8mb3_general_ci NULL
326 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
327 ALTER SCHEMA d8 CHARACTER SET swe7;
328 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
329 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
330 def d8 swe7 swe7_swedish_ci NULL
331 def information_schema utf8mb3 utf8mb3_general_ci NULL
332 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
333 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
334 def performance_schema utf8mb3 utf8mb3_general_ci NULL
335 def sys utf8mb3 utf8mb3_general_ci NULL
336 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
337 DROP DATABASE d8;
338 CREATE DATABASE d8;
339 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
340 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
341 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
342 def information_schema utf8mb3 utf8mb3_general_ci NULL
343 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
344 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
345 def performance_schema utf8mb3 utf8mb3_general_ci NULL
346 def sys utf8mb3 utf8mb3_general_ci NULL
347 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
348 ALTER SCHEMA d8 CHARACTER SET cp1251;
349 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
350 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
351 def d8 cp1251 cp1251_general_ci NULL
352 def information_schema utf8mb3 utf8mb3_general_ci NULL
353 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
354 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
355 def performance_schema utf8mb3 utf8mb3_general_ci NULL
356 def sys utf8mb3 utf8mb3_general_ci NULL
357 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
358 DROP DATABASE d8;
359 CREATE DATABASE d8;
360 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
361 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
362 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
363 def information_schema utf8mb3 utf8mb3_general_ci NULL
364 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
365 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
366 def performance_schema utf8mb3 utf8mb3_general_ci NULL
367 def sys utf8mb3 utf8mb3_general_ci NULL
368 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
369 ALTER SCHEMA d8 DEFAULT CHARACTER SET ascii;
370 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
371 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
372 def d8 ascii ascii_general_ci NULL
373 def information_schema utf8mb3 utf8mb3_general_ci NULL
374 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
375 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
376 def performance_schema utf8mb3 utf8mb3_general_ci NULL
377 def sys utf8mb3 utf8mb3_general_ci NULL
378 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
379 DROP DATABASE d8;
380 CREATE DATABASE d8;
381 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
382 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
383 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
384 def information_schema utf8mb3 utf8mb3_general_ci NULL
385 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
386 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
387 def performance_schema utf8mb3 utf8mb3_general_ci NULL
388 def sys utf8mb3 utf8mb3_general_ci NULL
389 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
390 ALTER SCHEMA d8 DEFAULT CHARACTER SET utf8;
391 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
392 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
393 def d8 utf8mb3 utf8mb3_uca1400_ai_ci NULL
394 def information_schema utf8mb3 utf8mb3_general_ci NULL
395 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
396 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
397 def performance_schema utf8mb3 utf8mb3_general_ci NULL
398 def sys utf8mb3 utf8mb3_general_ci NULL
399 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
400 DROP DATABASE d8;
401 CREATE DATABASE d8;
402 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
403 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
404 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
405 def information_schema utf8mb3 utf8mb3_general_ci NULL
406 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
407 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
408 def performance_schema utf8mb3 utf8mb3_general_ci NULL
409 def sys utf8mb3 utf8mb3_general_ci NULL
410 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
411 ALTER SCHEMA d8 DEFAULT CHARACTER SET binary;
412 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
413 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
414 def d8 binary binary NULL
415 def information_schema utf8mb3 utf8mb3_general_ci NULL
416 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
417 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
418 def performance_schema utf8mb3 utf8mb3_general_ci NULL
419 def sys utf8mb3 utf8mb3_general_ci NULL
420 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
421 DROP DATABASE d8;
422 CREATE DATABASE d8;
423 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
424 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
425 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
426 def information_schema utf8mb3 utf8mb3_general_ci NULL
427 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
428 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
429 def performance_schema utf8mb3 utf8mb3_general_ci NULL
430 def sys utf8mb3 utf8mb3_general_ci NULL
431 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
432 ALTER SCHEMA d8 DEFAULT CHARACTER SET swe7;
433 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
434 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
435 def d8 swe7 swe7_swedish_ci NULL
436 def information_schema utf8mb3 utf8mb3_general_ci NULL
437 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
438 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
439 def performance_schema utf8mb3 utf8mb3_general_ci NULL
440 def sys utf8mb3 utf8mb3_general_ci NULL
441 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
442 DROP DATABASE d8;
443 CREATE DATABASE d8;
444 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
445 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
446 def d8 utf8mb4 utf8mb4_uca1400_ai_ci NULL
447 def information_schema utf8mb3 utf8mb3_general_ci NULL
448 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
449 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
450 def performance_schema utf8mb3 utf8mb3_general_ci NULL
451 def sys utf8mb3 utf8mb3_general_ci NULL
452 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
453 ALTER SCHEMA d8 DEFAULT CHARACTER SET cp1251;
454 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
455 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH SCHEMA_COMMENT
456 def d8 cp1251 cp1251_general_ci NULL
457 def information_schema utf8mb3 utf8mb3_general_ci NULL
458 def mtr utf8mb4 utf8mb4_uca1400_ai_ci NULL
459 def mysql utf8mb4 utf8mb4_uca1400_ai_ci NULL
460 def performance_schema utf8mb3 utf8mb3_general_ci NULL
461 def sys utf8mb3 utf8mb3_general_ci NULL
462 def test utf8mb4 utf8mb4_uca1400_ai_ci NULL
463 DROP DATABASE d8;