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