Debian Codegraph @

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

raw
1 DROP DATABASE IF EXISTS d10;
2 SHOW COLLATION;
3 Collation Charset Id Default Compiled Sortlen Pad_attribute
4 armscii8_bin armscii8 64 # # PAD SPACE
5 armscii8_general_ci armscii8 32 Yes # # PAD SPACE
6 ascii_bin ascii 65 # # PAD SPACE
7 ascii_general_ci ascii 11 Yes # # PAD SPACE
8 big5_bin big5 84 # # PAD SPACE
9 big5_chinese_ci big5 1 Yes # # PAD SPACE
10 binary binary 63 Yes # # NO PAD
11 cp1250_bin cp1250 66 # # PAD SPACE
12 cp1250_croatian_ci cp1250 44 # # PAD SPACE
13 cp1250_czech_cs cp1250 34 # # PAD SPACE
14 cp1250_general_ci cp1250 26 Yes # # PAD SPACE
15 cp1250_polish_ci cp1250 99 # # PAD SPACE
16 cp1251_bin cp1251 50 # # PAD SPACE
17 cp1251_bulgarian_ci cp1251 14 # # PAD SPACE
18 cp1251_general_ci cp1251 51 Yes # # PAD SPACE
19 cp1251_general_cs cp1251 52 # # PAD SPACE
20 cp1251_ukrainian_ci cp1251 23 # # PAD SPACE
21 cp1256_bin cp1256 67 # # PAD SPACE
22 cp1256_general_ci cp1256 57 Yes # # PAD SPACE
23 cp1257_bin cp1257 58 # # PAD SPACE
24 cp1257_general_ci cp1257 59 Yes # # PAD SPACE
25 cp1257_lithuanian_ci cp1257 29 # # PAD SPACE
26 cp850_bin cp850 80 # # PAD SPACE
27 cp850_general_ci cp850 4 Yes # # PAD SPACE
28 cp852_bin cp852 81 # # PAD SPACE
29 cp852_general_ci cp852 40 Yes # # PAD SPACE
30 cp866_bin cp866 68 # # PAD SPACE
31 cp866_general_ci cp866 36 Yes # # PAD SPACE
32 cp932_bin cp932 96 # # PAD SPACE
33 cp932_japanese_ci cp932 95 Yes # # PAD SPACE
34 dec8_bin dec8 69 # # PAD SPACE
35 dec8_swedish_ci dec8 3 Yes # # PAD SPACE
36 eucjpms_bin eucjpms 98 # # PAD SPACE
37 eucjpms_japanese_ci eucjpms 97 Yes # # PAD SPACE
38 euckr_bin euckr 85 # # PAD SPACE
39 euckr_korean_ci euckr 19 Yes # # PAD SPACE
40 gb18030_bin gb18030 249 # # PAD SPACE
41 gb18030_chinese_ci gb18030 248 Yes # # PAD SPACE
42 gb18030_unicode_520_ci gb18030 250 # # PAD SPACE
43 gb2312_bin gb2312 86 # # PAD SPACE
44 gb2312_chinese_ci gb2312 24 Yes # # PAD SPACE
45 gbk_bin gbk 87 # # PAD SPACE
46 gbk_chinese_ci gbk 28 Yes # # PAD SPACE
47 geostd8_bin geostd8 93 # # PAD SPACE
48 geostd8_general_ci geostd8 92 Yes # # PAD SPACE
49 greek_bin greek 70 # # PAD SPACE
50 greek_general_ci greek 25 Yes # # PAD SPACE
51 hebrew_bin hebrew 71 # # PAD SPACE
52 hebrew_general_ci hebrew 16 Yes # # PAD SPACE
53 hp8_bin hp8 72 # # PAD SPACE
54 hp8_english_ci hp8 6 Yes # # PAD SPACE
55 keybcs2_bin keybcs2 73 # # PAD SPACE
56 keybcs2_general_ci keybcs2 37 Yes # # PAD SPACE
57 koi8r_bin koi8r 74 # # PAD SPACE
58 koi8r_general_ci koi8r 7 Yes # # PAD SPACE
59 koi8u_bin koi8u 75 # # PAD SPACE
60 koi8u_general_ci koi8u 22 Yes # # PAD SPACE
61 latin1_bin latin1 47 # # PAD SPACE
62 latin1_danish_ci latin1 15 # # PAD SPACE
63 latin1_general_ci latin1 48 # # PAD SPACE
64 latin1_general_cs latin1 49 # # PAD SPACE
65 latin1_german1_ci latin1 5 # # PAD SPACE
66 latin1_german2_ci latin1 31 # # PAD SPACE
67 latin1_spanish_ci latin1 94 # # PAD SPACE
68 latin1_swedish_ci latin1 8 Yes # # PAD SPACE
69 latin2_bin latin2 77 # # PAD SPACE
70 latin2_croatian_ci latin2 27 # # PAD SPACE
71 latin2_czech_cs latin2 2 # # PAD SPACE
72 latin2_general_ci latin2 9 Yes # # PAD SPACE
73 latin2_hungarian_ci latin2 21 # # PAD SPACE
74 latin5_bin latin5 78 # # PAD SPACE
75 latin5_turkish_ci latin5 30 Yes # # PAD SPACE
76 latin7_bin latin7 79 # # PAD SPACE
77 latin7_estonian_cs latin7 20 # # PAD SPACE
78 latin7_general_ci latin7 41 Yes # # PAD SPACE
79 latin7_general_cs latin7 42 # # PAD SPACE
80 macce_bin macce 43 # # PAD SPACE
81 macce_general_ci macce 38 Yes # # PAD SPACE
82 macroman_bin macroman 53 # # PAD SPACE
83 macroman_general_ci macroman 39 Yes # # PAD SPACE
84 sjis_bin sjis 88 # # PAD SPACE
85 sjis_japanese_ci sjis 13 Yes # # PAD SPACE
86 swe7_bin swe7 82 # # PAD SPACE
87 swe7_swedish_ci swe7 10 Yes # # PAD SPACE
88 tis620_bin tis620 89 # # PAD SPACE
89 tis620_thai_ci tis620 18 Yes # # PAD SPACE
90 ucs2_bin ucs2 90 # # PAD SPACE
91 ucs2_croatian_ci ucs2 149 # # PAD SPACE
92 ucs2_czech_ci ucs2 138 # # PAD SPACE
93 ucs2_danish_ci ucs2 139 # # PAD SPACE
94 ucs2_esperanto_ci ucs2 145 # # PAD SPACE
95 ucs2_estonian_ci ucs2 134 # # PAD SPACE
96 ucs2_general_ci ucs2 35 Yes # # PAD SPACE
97 ucs2_general_mysql500_ci ucs2 159 # # PAD SPACE
98 ucs2_german2_ci ucs2 148 # # PAD SPACE
99 ucs2_hungarian_ci ucs2 146 # # PAD SPACE
100 ucs2_icelandic_ci ucs2 129 # # PAD SPACE
101 ucs2_latvian_ci ucs2 130 # # PAD SPACE
102 ucs2_lithuanian_ci ucs2 140 # # PAD SPACE
103 ucs2_persian_ci ucs2 144 # # PAD SPACE
104 ucs2_polish_ci ucs2 133 # # PAD SPACE
105 ucs2_romanian_ci ucs2 131 # # PAD SPACE
106 ucs2_roman_ci ucs2 143 # # PAD SPACE
107 ucs2_sinhala_ci ucs2 147 # # PAD SPACE
108 ucs2_slovak_ci ucs2 141 # # PAD SPACE
109 ucs2_slovenian_ci ucs2 132 # # PAD SPACE
110 ucs2_spanish2_ci ucs2 142 # # PAD SPACE
111 ucs2_spanish_ci ucs2 135 # # PAD SPACE
112 ucs2_swedish_ci ucs2 136 # # PAD SPACE
113 ucs2_turkish_ci ucs2 137 # # PAD SPACE
114 ucs2_unicode_520_ci ucs2 150 # # PAD SPACE
115 ucs2_unicode_ci ucs2 128 # # PAD SPACE
116 ucs2_vietnamese_ci ucs2 151 # # PAD SPACE
117 ujis_bin ujis 91 # # PAD SPACE
118 ujis_japanese_ci ujis 12 Yes # # PAD SPACE
119 utf16le_bin utf16le 62 # # PAD SPACE
120 utf16le_general_ci utf16le 56 Yes # # PAD SPACE
121 utf16_bin utf16 55 # # PAD SPACE
122 utf16_croatian_ci utf16 122 # # PAD SPACE
123 utf16_czech_ci utf16 111 # # PAD SPACE
124 utf16_danish_ci utf16 112 # # PAD SPACE
125 utf16_esperanto_ci utf16 118 # # PAD SPACE
126 utf16_estonian_ci utf16 107 # # PAD SPACE
127 utf16_general_ci utf16 54 Yes # # PAD SPACE
128 utf16_german2_ci utf16 121 # # PAD SPACE
129 utf16_hungarian_ci utf16 119 # # PAD SPACE
130 utf16_icelandic_ci utf16 102 # # PAD SPACE
131 utf16_latvian_ci utf16 103 # # PAD SPACE
132 utf16_lithuanian_ci utf16 113 # # PAD SPACE
133 utf16_persian_ci utf16 117 # # PAD SPACE
134 utf16_polish_ci utf16 106 # # PAD SPACE
135 utf16_romanian_ci utf16 104 # # PAD SPACE
136 utf16_roman_ci utf16 116 # # PAD SPACE
137 utf16_sinhala_ci utf16 120 # # PAD SPACE
138 utf16_slovak_ci utf16 114 # # PAD SPACE
139 utf16_slovenian_ci utf16 105 # # PAD SPACE
140 utf16_spanish2_ci utf16 115 # # PAD SPACE
141 utf16_spanish_ci utf16 108 # # PAD SPACE
142 utf16_swedish_ci utf16 109 # # PAD SPACE
143 utf16_turkish_ci utf16 110 # # PAD SPACE
144 utf16_unicode_520_ci utf16 123 # # PAD SPACE
145 utf16_unicode_ci utf16 101 # # PAD SPACE
146 utf16_vietnamese_ci utf16 124 # # PAD SPACE
147 utf32_bin utf32 61 # # PAD SPACE
148 utf32_croatian_ci utf32 181 # # PAD SPACE
149 utf32_czech_ci utf32 170 # # PAD SPACE
150 utf32_danish_ci utf32 171 # # PAD SPACE
151 utf32_esperanto_ci utf32 177 # # PAD SPACE
152 utf32_estonian_ci utf32 166 # # PAD SPACE
153 utf32_general_ci utf32 60 Yes # # PAD SPACE
154 utf32_german2_ci utf32 180 # # PAD SPACE
155 utf32_hungarian_ci utf32 178 # # PAD SPACE
156 utf32_icelandic_ci utf32 161 # # PAD SPACE
157 utf32_latvian_ci utf32 162 # # PAD SPACE
158 utf32_lithuanian_ci utf32 172 # # PAD SPACE
159 utf32_persian_ci utf32 176 # # PAD SPACE
160 utf32_polish_ci utf32 165 # # PAD SPACE
161 utf32_romanian_ci utf32 163 # # PAD SPACE
162 utf32_roman_ci utf32 175 # # PAD SPACE
163 utf32_sinhala_ci utf32 179 # # PAD SPACE
164 utf32_slovak_ci utf32 173 # # PAD SPACE
165 utf32_slovenian_ci utf32 164 # # PAD SPACE
166 utf32_spanish2_ci utf32 174 # # PAD SPACE
167 utf32_spanish_ci utf32 167 # # PAD SPACE
168 utf32_swedish_ci utf32 168 # # PAD SPACE
169 utf32_turkish_ci utf32 169 # # PAD SPACE
170 utf32_unicode_520_ci utf32 182 # # PAD SPACE
171 utf32_unicode_ci utf32 160 # # PAD SPACE
172 utf32_vietnamese_ci utf32 183 # # PAD SPACE
173 utf8mb3_bin utf8mb3 83 # # PAD SPACE
174 utf8mb3_croatian_ci utf8mb3 213 # # PAD SPACE
175 utf8mb3_czech_ci utf8mb3 202 # # PAD SPACE
176 utf8mb3_danish_ci utf8mb3 203 # # PAD SPACE
177 utf8mb3_esperanto_ci utf8mb3 209 # # PAD SPACE
178 utf8mb3_estonian_ci utf8mb3 198 # # PAD SPACE
179 utf8mb3_general_ci utf8mb3 33 Yes # # PAD SPACE
180 utf8mb3_general_mysql500_ci utf8mb3 223 # # PAD SPACE
181 utf8mb3_german2_ci utf8mb3 212 # # PAD SPACE
182 utf8mb3_hungarian_ci utf8mb3 210 # # PAD SPACE
183 utf8mb3_icelandic_ci utf8mb3 193 # # PAD SPACE
184 utf8mb3_latvian_ci utf8mb3 194 # # PAD SPACE
185 utf8mb3_lithuanian_ci utf8mb3 204 # # PAD SPACE
186 utf8mb3_persian_ci utf8mb3 208 # # PAD SPACE
187 utf8mb3_polish_ci utf8mb3 197 # # PAD SPACE
188 utf8mb3_romanian_ci utf8mb3 195 # # PAD SPACE
189 utf8mb3_roman_ci utf8mb3 207 # # PAD SPACE
190 utf8mb3_sinhala_ci utf8mb3 211 # # PAD SPACE
191 utf8mb3_slovak_ci utf8mb3 205 # # PAD SPACE
192 utf8mb3_slovenian_ci utf8mb3 196 # # PAD SPACE
193 utf8mb3_spanish2_ci utf8mb3 206 # # PAD SPACE
194 utf8mb3_spanish_ci utf8mb3 199 # # PAD SPACE
195 utf8mb3_swedish_ci utf8mb3 200 # # PAD SPACE
196 utf8mb3_tolower_ci utf8mb3 76 # # PAD SPACE
197 utf8mb3_turkish_ci utf8mb3 201 # # PAD SPACE
198 utf8mb3_unicode_520_ci utf8mb3 214 # # PAD SPACE
199 utf8mb3_unicode_ci utf8mb3 192 # # PAD SPACE
200 utf8mb3_vietnamese_ci utf8mb3 215 # # PAD SPACE
201 utf8mb4_0900_ai_ci utf8mb4 255 Yes # # NO PAD
202 utf8mb4_0900_as_ci utf8mb4 305 # # NO PAD
203 utf8mb4_0900_as_cs utf8mb4 278 # # NO PAD
204 utf8mb4_0900_bin utf8mb4 309 # # NO PAD
205 utf8mb4_bg_0900_ai_ci utf8mb4 318 # # NO PAD
206 utf8mb4_bg_0900_as_cs utf8mb4 319 # # NO PAD
207 utf8mb4_bin utf8mb4 46 # # PAD SPACE
208 utf8mb4_bs_0900_ai_ci utf8mb4 316 # # NO PAD
209 utf8mb4_bs_0900_as_cs utf8mb4 317 # # NO PAD
210 utf8mb4_croatian_ci utf8mb4 245 # # PAD SPACE
211 utf8mb4_cs_0900_ai_ci utf8mb4 266 # # NO PAD
212 utf8mb4_cs_0900_as_cs utf8mb4 289 # # NO PAD
213 utf8mb4_czech_ci utf8mb4 234 # # PAD SPACE
214 utf8mb4_danish_ci utf8mb4 235 # # PAD SPACE
215 utf8mb4_da_0900_ai_ci utf8mb4 267 # # NO PAD
216 utf8mb4_da_0900_as_cs utf8mb4 290 # # NO PAD
217 utf8mb4_de_pb_0900_ai_ci utf8mb4 256 # # NO PAD
218 utf8mb4_de_pb_0900_as_cs utf8mb4 279 # # NO PAD
219 utf8mb4_eo_0900_ai_ci utf8mb4 273 # # NO PAD
220 utf8mb4_eo_0900_as_cs utf8mb4 296 # # NO PAD
221 utf8mb4_esperanto_ci utf8mb4 241 # # PAD SPACE
222 utf8mb4_estonian_ci utf8mb4 230 # # PAD SPACE
223 utf8mb4_es_0900_ai_ci utf8mb4 263 # # NO PAD
224 utf8mb4_es_0900_as_cs utf8mb4 286 # # NO PAD
225 utf8mb4_es_trad_0900_ai_ci utf8mb4 270 # # NO PAD
226 utf8mb4_es_trad_0900_as_cs utf8mb4 293 # # NO PAD
227 utf8mb4_et_0900_ai_ci utf8mb4 262 # # NO PAD
228 utf8mb4_et_0900_as_cs utf8mb4 285 # # NO PAD
229 utf8mb4_general_ci utf8mb4 45 # # PAD SPACE
230 utf8mb4_german2_ci utf8mb4 244 # # PAD SPACE
231 utf8mb4_gl_0900_ai_ci utf8mb4 320 # # NO PAD
232 utf8mb4_gl_0900_as_cs utf8mb4 321 # # NO PAD
233 utf8mb4_hr_0900_ai_ci utf8mb4 275 # # NO PAD
234 utf8mb4_hr_0900_as_cs utf8mb4 298 # # NO PAD
235 utf8mb4_hungarian_ci utf8mb4 242 # # PAD SPACE
236 utf8mb4_hu_0900_ai_ci utf8mb4 274 # # NO PAD
237 utf8mb4_hu_0900_as_cs utf8mb4 297 # # NO PAD
238 utf8mb4_icelandic_ci utf8mb4 225 # # PAD SPACE
239 utf8mb4_is_0900_ai_ci utf8mb4 257 # # NO PAD
240 utf8mb4_is_0900_as_cs utf8mb4 280 # # NO PAD
241 utf8mb4_ja_0900_as_cs utf8mb4 303 # # NO PAD
242 utf8mb4_ja_0900_as_cs_ks utf8mb4 304 # # NO PAD
243 utf8mb4_latvian_ci utf8mb4 226 # # PAD SPACE
244 utf8mb4_la_0900_ai_ci utf8mb4 271 # # NO PAD
245 utf8mb4_la_0900_as_cs utf8mb4 294 # # NO PAD
246 utf8mb4_lithuanian_ci utf8mb4 236 # # PAD SPACE
247 utf8mb4_lt_0900_ai_ci utf8mb4 268 # # NO PAD
248 utf8mb4_lt_0900_as_cs utf8mb4 291 # # NO PAD
249 utf8mb4_lv_0900_ai_ci utf8mb4 258 # # NO PAD
250 utf8mb4_lv_0900_as_cs utf8mb4 281 # # NO PAD
251 utf8mb4_mn_cyrl_0900_ai_ci utf8mb4 322 # # NO PAD
252 utf8mb4_mn_cyrl_0900_as_cs utf8mb4 323 # # NO PAD
253 utf8mb4_nb_0900_ai_ci utf8mb4 310 # # NO PAD
254 utf8mb4_nb_0900_as_cs utf8mb4 311 # # NO PAD
255 utf8mb4_nn_0900_ai_ci utf8mb4 312 # # NO PAD
256 utf8mb4_nn_0900_as_cs utf8mb4 313 # # NO PAD
257 utf8mb4_persian_ci utf8mb4 240 # # PAD SPACE
258 utf8mb4_pl_0900_ai_ci utf8mb4 261 # # NO PAD
259 utf8mb4_pl_0900_as_cs utf8mb4 284 # # NO PAD
260 utf8mb4_polish_ci utf8mb4 229 # # PAD SPACE
261 utf8mb4_romanian_ci utf8mb4 227 # # PAD SPACE
262 utf8mb4_roman_ci utf8mb4 239 # # PAD SPACE
263 utf8mb4_ro_0900_ai_ci utf8mb4 259 # # NO PAD
264 utf8mb4_ro_0900_as_cs utf8mb4 282 # # NO PAD
265 utf8mb4_ru_0900_ai_ci utf8mb4 306 # # NO PAD
266 utf8mb4_ru_0900_as_cs utf8mb4 307 # # NO PAD
267 utf8mb4_sinhala_ci utf8mb4 243 # # PAD SPACE
268 utf8mb4_sk_0900_ai_ci utf8mb4 269 # # NO PAD
269 utf8mb4_sk_0900_as_cs utf8mb4 292 # # NO PAD
270 utf8mb4_slovak_ci utf8mb4 237 # # PAD SPACE
271 utf8mb4_slovenian_ci utf8mb4 228 # # PAD SPACE
272 utf8mb4_sl_0900_ai_ci utf8mb4 260 # # NO PAD
273 utf8mb4_sl_0900_as_cs utf8mb4 283 # # NO PAD
274 utf8mb4_spanish2_ci utf8mb4 238 # # PAD SPACE
275 utf8mb4_spanish_ci utf8mb4 231 # # PAD SPACE
276 utf8mb4_sr_latn_0900_ai_ci utf8mb4 314 # # NO PAD
277 utf8mb4_sr_latn_0900_as_cs utf8mb4 315 # # NO PAD
278 utf8mb4_sv_0900_ai_ci utf8mb4 264 # # NO PAD
279 utf8mb4_sv_0900_as_cs utf8mb4 287 # # NO PAD
280 utf8mb4_swedish_ci utf8mb4 232 # # PAD SPACE
281 utf8mb4_tr_0900_ai_ci utf8mb4 265 # # NO PAD
282 utf8mb4_tr_0900_as_cs utf8mb4 288 # # NO PAD
283 utf8mb4_turkish_ci utf8mb4 233 # # PAD SPACE
284 utf8mb4_unicode_520_ci utf8mb4 246 # # PAD SPACE
285 utf8mb4_unicode_ci utf8mb4 224 # # PAD SPACE
286 utf8mb4_vietnamese_ci utf8mb4 247 # # PAD SPACE
287 utf8mb4_vi_0900_ai_ci utf8mb4 277 # # NO PAD
288 utf8mb4_vi_0900_as_cs utf8mb4 300 # # NO PAD
289 utf8mb4_zh_0900_as_cs utf8mb4 308 # # NO PAD
290 CREATE DATABASE d10 DEFAULT 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 d10 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 ALTER DATABASE d10 COLLATE utf8_general_ci;
303 Warnings:
304 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
305 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
306 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
307 def d10 utf8mb3 utf8mb3_general_ci NULL NO
308 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
309 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
310 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
311 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
312 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
313 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
314 DROP DATABASE d10;
315 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
316 Warnings:
317 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.
318 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
319 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
320 def d10 utf8mb3 utf8mb3_general_ci NULL NO
321 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
322 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
323 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
324 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
325 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
326 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
327 ALTER DATABASE d10 DEFAULT COLLATE utf8_general_ci;
328 Warnings:
329 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
330 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
331 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
332 def d10 utf8mb3 utf8mb3_general_ci NULL NO
333 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
334 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
335 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
336 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
337 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
338 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
339 DROP DATABASE d10;
340 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
341 Warnings:
342 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.
343 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
344 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
345 def d10 utf8mb3 utf8mb3_general_ci NULL NO
346 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
347 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
348 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
349 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
350 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
351 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
352 ALTER DATABASE d10 COLLATE utf8_bin;
353 Warnings:
354 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
355 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
356 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
357 def d10 utf8mb3 utf8mb3_bin NULL NO
358 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
359 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
360 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
361 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
362 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
363 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
364 DROP DATABASE d10;
365 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
366 Warnings:
367 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.
368 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
369 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
370 def d10 utf8mb3 utf8mb3_general_ci NULL NO
371 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
372 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
373 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
374 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
375 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
376 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
377 ALTER DATABASE d10 DEFAULT COLLATE utf8_bin;
378 Warnings:
379 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
380 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
381 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
382 def d10 utf8mb3 utf8mb3_bin NULL NO
383 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
384 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
385 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
386 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
387 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
388 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
389 DROP DATABASE d10;
390 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
391 Warnings:
392 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.
393 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
394 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
395 def d10 utf8mb3 utf8mb3_general_ci NULL NO
396 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
397 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
398 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
399 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
400 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
401 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
402 ALTER DATABASE d10 COLLATE utf8_unicode_ci;
403 Warnings:
404 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
405 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
406 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
407 def d10 utf8mb3 utf8mb3_unicode_ci NULL NO
408 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
409 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
410 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
411 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
412 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
413 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
414 DROP DATABASE d10;
415 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
416 Warnings:
417 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.
418 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
419 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
420 def d10 utf8mb3 utf8mb3_general_ci NULL NO
421 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
422 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
423 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
424 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
425 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
426 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
427 ALTER DATABASE d10 DEFAULT COLLATE utf8_unicode_ci;
428 Warnings:
429 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
430 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
431 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
432 def d10 utf8mb3 utf8mb3_unicode_ci NULL NO
433 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
434 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
435 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
436 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
437 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
438 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
439 DROP DATABASE d10;
440 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
441 Warnings:
442 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.
443 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
444 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
445 def d10 utf8mb3 utf8mb3_general_ci NULL NO
446 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
447 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
448 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
449 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
450 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
451 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
452 ALTER DATABASE d10 COLLATE utf8_icelandic_ci;
453 Warnings:
454 Warning 3778 'utf8mb3_icelandic_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
455 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
456 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
457 def d10 utf8mb3 utf8mb3_icelandic_ci NULL NO
458 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
459 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
460 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
461 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
462 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
463 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
464 DROP DATABASE d10;
465 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
466 Warnings:
467 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.
468 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
469 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
470 def d10 utf8mb3 utf8mb3_general_ci NULL NO
471 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
472 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
473 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
474 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
475 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
476 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
477 ALTER DATABASE d10 DEFAULT COLLATE utf8_icelandic_ci;
478 Warnings:
479 Warning 3778 'utf8mb3_icelandic_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
480 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
481 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
482 def d10 utf8mb3 utf8mb3_icelandic_ci NULL NO
483 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
484 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
485 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
486 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
487 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
488 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
489 DROP DATABASE d10;
490 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
491 Warnings:
492 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.
493 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
494 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
495 def d10 utf8mb3 utf8mb3_general_ci NULL NO
496 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
497 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
498 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
499 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
500 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
501 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
502 ALTER DATABASE d10 COLLATE utf8_latvian_ci;
503 Warnings:
504 Warning 3778 'utf8mb3_latvian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
505 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
506 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
507 def d10 utf8mb3 utf8mb3_latvian_ci NULL NO
508 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
509 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
510 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
511 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
512 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
513 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
514 DROP DATABASE d10;
515 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
516 Warnings:
517 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.
518 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
519 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
520 def d10 utf8mb3 utf8mb3_general_ci NULL NO
521 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
522 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
523 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
524 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
525 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
526 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
527 ALTER DATABASE d10 DEFAULT COLLATE utf8_latvian_ci;
528 Warnings:
529 Warning 3778 'utf8mb3_latvian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
530 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
531 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
532 def d10 utf8mb3 utf8mb3_latvian_ci NULL NO
533 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
534 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
535 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
536 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
537 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
538 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
539 DROP DATABASE d10;
540 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
541 Warnings:
542 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.
543 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
544 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
545 def d10 utf8mb3 utf8mb3_general_ci NULL NO
546 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
547 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
548 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
549 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
550 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
551 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
552 ALTER DATABASE d10 COLLATE utf8_romanian_ci;
553 Warnings:
554 Warning 3778 'utf8mb3_romanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
555 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
556 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
557 def d10 utf8mb3 utf8mb3_romanian_ci NULL NO
558 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
559 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
560 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
561 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
562 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
563 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
564 DROP DATABASE d10;
565 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
566 Warnings:
567 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.
568 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
569 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
570 def d10 utf8mb3 utf8mb3_general_ci NULL NO
571 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
572 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
573 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
574 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
575 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
576 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
577 ALTER DATABASE d10 DEFAULT COLLATE utf8_romanian_ci;
578 Warnings:
579 Warning 3778 'utf8mb3_romanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
580 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
581 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
582 def d10 utf8mb3 utf8mb3_romanian_ci NULL NO
583 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
584 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
585 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
586 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
587 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
588 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
589 DROP DATABASE d10;
590 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
591 Warnings:
592 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.
593 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
594 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
595 def d10 utf8mb3 utf8mb3_general_ci NULL NO
596 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
597 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
598 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
599 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
600 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
601 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
602 ALTER DATABASE d10 COLLATE utf8_slovenian_ci;
603 Warnings:
604 Warning 3778 'utf8mb3_slovenian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
605 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
606 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
607 def d10 utf8mb3 utf8mb3_slovenian_ci NULL NO
608 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
609 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
610 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
611 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
612 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
613 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
614 DROP DATABASE d10;
615 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
616 Warnings:
617 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.
618 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
619 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
620 def d10 utf8mb3 utf8mb3_general_ci NULL NO
621 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
622 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
623 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
624 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
625 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
626 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
627 ALTER DATABASE d10 DEFAULT COLLATE utf8_slovenian_ci;
628 Warnings:
629 Warning 3778 'utf8mb3_slovenian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
630 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
631 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
632 def d10 utf8mb3 utf8mb3_slovenian_ci NULL NO
633 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
634 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
635 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
636 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
637 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
638 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
639 DROP DATABASE d10;
640 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
641 Warnings:
642 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.
643 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
644 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
645 def d10 utf8mb3 utf8mb3_general_ci NULL NO
646 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
647 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
648 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
649 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
650 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
651 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
652 ALTER DATABASE d10 COLLATE utf8_polish_ci;
653 Warnings:
654 Warning 3778 'utf8mb3_polish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
655 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
656 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
657 def d10 utf8mb3 utf8mb3_polish_ci NULL NO
658 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
659 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
660 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
661 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
662 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
663 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
664 DROP DATABASE d10;
665 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
666 Warnings:
667 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.
668 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
669 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
670 def d10 utf8mb3 utf8mb3_general_ci NULL NO
671 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
672 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
673 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
674 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
675 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
676 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
677 ALTER DATABASE d10 DEFAULT COLLATE utf8_polish_ci;
678 Warnings:
679 Warning 3778 'utf8mb3_polish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
680 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
681 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
682 def d10 utf8mb3 utf8mb3_polish_ci NULL NO
683 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
684 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
685 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
686 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
687 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
688 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
689 DROP DATABASE d10;
690 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
691 Warnings:
692 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.
693 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
694 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
695 def d10 utf8mb3 utf8mb3_general_ci NULL NO
696 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
697 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
698 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
699 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
700 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
701 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
702 ALTER DATABASE d10 COLLATE utf8_estonian_ci;
703 Warnings:
704 Warning 3778 'utf8mb3_estonian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
705 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
706 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
707 def d10 utf8mb3 utf8mb3_estonian_ci NULL NO
708 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
709 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
710 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
711 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
712 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
713 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
714 DROP DATABASE d10;
715 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
716 Warnings:
717 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.
718 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
719 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
720 def d10 utf8mb3 utf8mb3_general_ci NULL NO
721 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
722 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
723 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
724 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
725 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
726 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
727 ALTER DATABASE d10 DEFAULT COLLATE utf8_estonian_ci;
728 Warnings:
729 Warning 3778 'utf8mb3_estonian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
730 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
731 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
732 def d10 utf8mb3 utf8mb3_estonian_ci NULL NO
733 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
734 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
735 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
736 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
737 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
738 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
739 DROP DATABASE d10;
740 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
741 Warnings:
742 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.
743 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
744 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
745 def d10 utf8mb3 utf8mb3_general_ci NULL NO
746 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
747 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
748 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
749 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
750 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
751 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
752 ALTER DATABASE d10 COLLATE utf8_spanish_ci;
753 Warnings:
754 Warning 3778 'utf8mb3_spanish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
755 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
756 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
757 def d10 utf8mb3 utf8mb3_spanish_ci NULL NO
758 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
759 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
760 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
761 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
762 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
763 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
764 DROP DATABASE d10;
765 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
766 Warnings:
767 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.
768 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
769 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
770 def d10 utf8mb3 utf8mb3_general_ci NULL NO
771 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
772 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
773 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
774 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
775 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
776 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
777 ALTER DATABASE d10 DEFAULT COLLATE utf8_spanish_ci;
778 Warnings:
779 Warning 3778 'utf8mb3_spanish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
780 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
781 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
782 def d10 utf8mb3 utf8mb3_spanish_ci NULL NO
783 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
784 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
785 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
786 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
787 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
788 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
789 DROP DATABASE d10;
790 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
791 Warnings:
792 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.
793 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
794 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
795 def d10 utf8mb3 utf8mb3_general_ci NULL NO
796 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
797 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
798 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
799 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
800 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
801 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
802 ALTER DATABASE d10 COLLATE utf8_swedish_ci;
803 Warnings:
804 Warning 3778 'utf8mb3_swedish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
805 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
806 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
807 def d10 utf8mb3 utf8mb3_swedish_ci NULL NO
808 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
809 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
810 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
811 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
812 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
813 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
814 DROP DATABASE d10;
815 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
816 Warnings:
817 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.
818 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
819 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
820 def d10 utf8mb3 utf8mb3_general_ci NULL NO
821 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
822 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
823 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
824 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
825 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
826 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
827 ALTER DATABASE d10 DEFAULT COLLATE utf8_swedish_ci;
828 Warnings:
829 Warning 3778 'utf8mb3_swedish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
830 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
831 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
832 def d10 utf8mb3 utf8mb3_swedish_ci NULL NO
833 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
834 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
835 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
836 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
837 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
838 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
839 DROP DATABASE d10;
840 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
841 Warnings:
842 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.
843 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
844 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
845 def d10 utf8mb3 utf8mb3_general_ci NULL NO
846 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
847 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
848 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
849 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
850 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
851 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
852 ALTER DATABASE d10 COLLATE utf8_turkish_ci;
853 Warnings:
854 Warning 3778 'utf8mb3_turkish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
855 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
856 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
857 def d10 utf8mb3 utf8mb3_turkish_ci NULL NO
858 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
859 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
860 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
861 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
862 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
863 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
864 DROP DATABASE d10;
865 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
866 Warnings:
867 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.
868 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
869 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
870 def d10 utf8mb3 utf8mb3_general_ci NULL NO
871 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
872 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
873 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
874 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
875 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
876 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
877 ALTER DATABASE d10 DEFAULT COLLATE utf8_turkish_ci;
878 Warnings:
879 Warning 3778 'utf8mb3_turkish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
880 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
881 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
882 def d10 utf8mb3 utf8mb3_turkish_ci NULL NO
883 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
884 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
885 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
886 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
887 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
888 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
889 DROP DATABASE d10;
890 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
891 Warnings:
892 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.
893 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
894 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
895 def d10 utf8mb3 utf8mb3_general_ci NULL NO
896 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
897 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
898 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
899 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
900 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
901 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
902 ALTER DATABASE d10 COLLATE utf8_czech_ci;
903 Warnings:
904 Warning 3778 'utf8mb3_czech_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
905 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
906 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
907 def d10 utf8mb3 utf8mb3_czech_ci NULL NO
908 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
909 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
910 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
911 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
912 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
913 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
914 DROP DATABASE d10;
915 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
916 Warnings:
917 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.
918 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
919 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
920 def d10 utf8mb3 utf8mb3_general_ci NULL NO
921 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
922 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
923 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
924 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
925 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
926 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
927 ALTER DATABASE d10 DEFAULT COLLATE utf8_czech_ci;
928 Warnings:
929 Warning 3778 'utf8mb3_czech_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
930 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
931 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
932 def d10 utf8mb3 utf8mb3_czech_ci NULL NO
933 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
934 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
935 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
936 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
937 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
938 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
939 DROP DATABASE d10;
940 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
941 Warnings:
942 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.
943 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
944 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
945 def d10 utf8mb3 utf8mb3_general_ci NULL NO
946 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
947 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
948 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
949 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
950 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
951 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
952 ALTER DATABASE d10 COLLATE utf8_danish_ci;
953 Warnings:
954 Warning 3778 'utf8mb3_danish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
955 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
956 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
957 def d10 utf8mb3 utf8mb3_danish_ci NULL NO
958 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
959 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
960 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
961 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
962 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
963 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
964 DROP DATABASE d10;
965 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
966 Warnings:
967 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.
968 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
969 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
970 def d10 utf8mb3 utf8mb3_general_ci NULL NO
971 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
972 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
973 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
974 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
975 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
976 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
977 ALTER DATABASE d10 DEFAULT COLLATE utf8_danish_ci;
978 Warnings:
979 Warning 3778 'utf8mb3_danish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
980 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
981 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
982 def d10 utf8mb3 utf8mb3_danish_ci NULL NO
983 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
984 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
985 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
986 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
987 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
988 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
989 DROP DATABASE d10;
990 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
991 Warnings:
992 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.
993 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
994 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
995 def d10 utf8mb3 utf8mb3_general_ci NULL NO
996 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
997 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
998 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
999 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1000 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1001 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1002 ALTER DATABASE d10 COLLATE utf8_lithuanian_ci;
1003 Warnings:
1004 Warning 3778 'utf8mb3_lithuanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1005 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1006 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1007 def d10 utf8mb3 utf8mb3_lithuanian_ci NULL NO
1008 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1009 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1010 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1011 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1012 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1013 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1014 DROP DATABASE d10;
1015 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1016 Warnings:
1017 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.
1018 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1019 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1020 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1021 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1022 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1023 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1024 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1025 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1026 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1027 ALTER DATABASE d10 DEFAULT COLLATE utf8_lithuanian_ci;
1028 Warnings:
1029 Warning 3778 'utf8mb3_lithuanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1030 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1031 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1032 def d10 utf8mb3 utf8mb3_lithuanian_ci NULL NO
1033 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1034 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1035 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1036 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1037 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1038 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1039 DROP DATABASE d10;
1040 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1041 Warnings:
1042 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.
1043 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1044 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1045 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1046 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1047 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1048 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1049 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1050 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1051 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1052 ALTER DATABASE d10 COLLATE utf8_slovak_ci;
1053 Warnings:
1054 Warning 3778 'utf8mb3_slovak_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1055 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1056 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1057 def d10 utf8mb3 utf8mb3_slovak_ci NULL NO
1058 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1059 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1060 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1061 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1062 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1063 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1064 DROP DATABASE d10;
1065 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1066 Warnings:
1067 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.
1068 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1069 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1070 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1071 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1072 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1073 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1074 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1075 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1076 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1077 ALTER DATABASE d10 DEFAULT COLLATE utf8_slovak_ci;
1078 Warnings:
1079 Warning 3778 'utf8mb3_slovak_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1080 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1081 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1082 def d10 utf8mb3 utf8mb3_slovak_ci NULL NO
1083 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1084 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1085 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1086 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1087 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1088 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1089 DROP DATABASE d10;
1090 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1091 Warnings:
1092 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.
1093 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1094 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1095 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1096 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1097 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1098 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1099 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1100 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1101 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1102 ALTER DATABASE d10 COLLATE utf8_spanish2_ci;
1103 Warnings:
1104 Warning 3778 'utf8mb3_spanish2_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1105 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1106 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1107 def d10 utf8mb3 utf8mb3_spanish2_ci NULL NO
1108 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1109 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1110 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1111 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1112 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1113 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1114 DROP DATABASE d10;
1115 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1116 Warnings:
1117 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.
1118 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1119 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1120 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1121 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1122 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1123 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1124 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1125 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1126 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1127 ALTER DATABASE d10 DEFAULT COLLATE utf8_spanish2_ci;
1128 Warnings:
1129 Warning 3778 'utf8mb3_spanish2_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1130 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1131 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1132 def d10 utf8mb3 utf8mb3_spanish2_ci NULL NO
1133 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1134 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1135 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1136 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1137 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1138 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1139 DROP DATABASE d10;
1140 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1141 Warnings:
1142 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.
1143 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1144 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1145 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1146 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1147 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1148 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1149 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1150 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1151 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1152 ALTER DATABASE d10 COLLATE utf8_roman_ci;
1153 Warnings:
1154 Warning 3778 'utf8mb3_roman_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1155 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1156 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1157 def d10 utf8mb3 utf8mb3_roman_ci NULL NO
1158 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1159 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1160 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1161 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1162 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1163 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1164 DROP DATABASE d10;
1165 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1166 Warnings:
1167 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.
1168 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1169 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1170 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1171 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1172 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1173 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1174 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1175 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1176 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1177 ALTER DATABASE d10 DEFAULT COLLATE utf8_roman_ci;
1178 Warnings:
1179 Warning 3778 'utf8mb3_roman_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1180 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1181 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1182 def d10 utf8mb3 utf8mb3_roman_ci NULL NO
1183 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1184 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1185 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1186 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1187 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1188 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1189 DROP DATABASE d10;
1190 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1191 Warnings:
1192 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.
1193 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1194 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1195 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1196 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1197 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1198 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1199 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1200 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1201 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1202 ALTER DATABASE d10 COLLATE utf8_persian_ci;
1203 Warnings:
1204 Warning 3778 'utf8mb3_persian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1205 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1206 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1207 def d10 utf8mb3 utf8mb3_persian_ci NULL NO
1208 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1209 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1210 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1211 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1212 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1213 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1214 DROP DATABASE d10;
1215 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1216 Warnings:
1217 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.
1218 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1219 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1220 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1221 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1222 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1223 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1224 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1225 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1226 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1227 ALTER DATABASE d10 DEFAULT COLLATE utf8_persian_ci;
1228 Warnings:
1229 Warning 3778 'utf8mb3_persian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1230 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1231 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1232 def d10 utf8mb3 utf8mb3_persian_ci NULL NO
1233 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1234 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1235 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1236 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1237 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1238 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1239 DROP DATABASE d10;
1240 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1241 Warnings:
1242 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.
1243 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1244 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1245 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1246 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1247 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1248 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1249 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1250 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1251 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1252 ALTER DATABASE d10 COLLATE utf8_esperanto_ci;
1253 Warnings:
1254 Warning 3778 'utf8mb3_esperanto_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1255 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1256 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1257 def d10 utf8mb3 utf8mb3_esperanto_ci NULL NO
1258 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1259 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1260 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1261 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1262 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1263 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1264 DROP DATABASE d10;
1265 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1266 Warnings:
1267 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.
1268 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1269 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1270 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1271 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1272 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1273 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1274 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1275 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1276 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1277 ALTER DATABASE d10 DEFAULT COLLATE utf8_esperanto_ci;
1278 Warnings:
1279 Warning 3778 'utf8mb3_esperanto_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1280 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1281 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1282 def d10 utf8mb3 utf8mb3_esperanto_ci NULL NO
1283 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1284 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1285 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1286 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1287 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1288 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1289 DROP DATABASE d10;
1290 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1291 Warnings:
1292 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.
1293 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1294 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1295 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1296 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1297 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1298 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1299 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1300 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1301 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1302 ALTER DATABASE d10 COLLATE utf8_hungarian_ci;
1303 Warnings:
1304 Warning 3778 'utf8mb3_hungarian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1305 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1306 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1307 def d10 utf8mb3 utf8mb3_hungarian_ci NULL NO
1308 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1309 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1310 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1311 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1312 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1313 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1314 DROP DATABASE d10;
1315 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1316 Warnings:
1317 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.
1318 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1319 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1320 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1321 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1322 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1323 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1324 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1325 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1326 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1327 ALTER DATABASE d10 DEFAULT COLLATE utf8_hungarian_ci;
1328 Warnings:
1329 Warning 3778 'utf8mb3_hungarian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1330 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1331 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1332 def d10 utf8mb3 utf8mb3_hungarian_ci NULL NO
1333 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1334 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1335 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1336 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1337 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1338 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1339 DROP DATABASE d10;
1340 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1341 Warnings:
1342 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.
1343 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1344 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1345 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1346 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1347 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1348 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1349 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1350 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1351 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1352 ALTER SCHEMA d10 COLLATE utf8_general_ci;
1353 Warnings:
1354 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1355 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1356 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1357 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1358 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1359 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1360 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1361 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1362 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1363 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1364 DROP DATABASE d10;
1365 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1366 Warnings:
1367 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.
1368 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1369 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1370 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1371 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1372 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1373 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1374 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1375 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1376 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1377 ALTER SCHEMA d10 DEFAULT COLLATE utf8_general_ci;
1378 Warnings:
1379 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1380 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1381 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1382 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1383 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1384 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1385 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1386 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1387 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1388 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1389 DROP DATABASE d10;
1390 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1391 Warnings:
1392 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.
1393 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1394 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1395 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1396 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1397 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1398 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1399 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1400 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1401 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1402 ALTER SCHEMA d10 COLLATE utf8_bin;
1403 Warnings:
1404 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1405 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1406 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1407 def d10 utf8mb3 utf8mb3_bin NULL NO
1408 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1409 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1410 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1411 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1412 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1413 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1414 DROP DATABASE d10;
1415 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1416 Warnings:
1417 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.
1418 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1419 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1420 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1421 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1422 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1423 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1424 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1425 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1426 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1427 ALTER SCHEMA d10 DEFAULT COLLATE utf8_bin;
1428 Warnings:
1429 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1430 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1431 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1432 def d10 utf8mb3 utf8mb3_bin NULL NO
1433 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1434 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1435 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1436 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1437 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1438 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1439 DROP DATABASE d10;
1440 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1441 Warnings:
1442 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.
1443 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1444 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1445 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1446 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1447 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1448 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1449 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1450 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1451 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1452 ALTER SCHEMA d10 COLLATE utf8_unicode_ci;
1453 Warnings:
1454 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1455 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1456 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1457 def d10 utf8mb3 utf8mb3_unicode_ci NULL NO
1458 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1459 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1460 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1461 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1462 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1463 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1464 DROP DATABASE d10;
1465 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1466 Warnings:
1467 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.
1468 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1469 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1470 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1471 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1472 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1473 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1474 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1475 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1476 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1477 ALTER SCHEMA d10 DEFAULT COLLATE utf8_unicode_ci;
1478 Warnings:
1479 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1480 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1481 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1482 def d10 utf8mb3 utf8mb3_unicode_ci NULL NO
1483 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1484 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1485 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1486 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1487 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1488 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1489 DROP DATABASE d10;
1490 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1491 Warnings:
1492 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.
1493 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1494 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1495 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1496 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1497 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1498 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1499 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1500 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1501 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1502 ALTER SCHEMA d10 COLLATE utf8_icelandic_ci;
1503 Warnings:
1504 Warning 3778 'utf8mb3_icelandic_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1505 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1506 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1507 def d10 utf8mb3 utf8mb3_icelandic_ci NULL NO
1508 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1509 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1510 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1511 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1512 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1513 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1514 DROP DATABASE d10;
1515 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1516 Warnings:
1517 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.
1518 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1519 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1520 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1521 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1522 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1523 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1524 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1525 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1526 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1527 ALTER SCHEMA d10 DEFAULT COLLATE utf8_icelandic_ci;
1528 Warnings:
1529 Warning 3778 'utf8mb3_icelandic_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1530 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1531 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1532 def d10 utf8mb3 utf8mb3_icelandic_ci NULL NO
1533 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1534 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1535 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1536 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1537 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1538 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1539 DROP DATABASE d10;
1540 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1541 Warnings:
1542 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.
1543 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1544 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1545 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1546 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1547 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1548 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1549 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1550 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1551 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1552 ALTER SCHEMA d10 COLLATE utf8_latvian_ci;
1553 Warnings:
1554 Warning 3778 'utf8mb3_latvian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1555 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1556 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1557 def d10 utf8mb3 utf8mb3_latvian_ci NULL NO
1558 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1559 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1560 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1561 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1562 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1563 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1564 DROP DATABASE d10;
1565 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1566 Warnings:
1567 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.
1568 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1569 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1570 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1571 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1572 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1573 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1574 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1575 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1576 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1577 ALTER SCHEMA d10 DEFAULT COLLATE utf8_latvian_ci;
1578 Warnings:
1579 Warning 3778 'utf8mb3_latvian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1580 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1581 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1582 def d10 utf8mb3 utf8mb3_latvian_ci NULL NO
1583 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1584 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1585 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1586 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1587 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1588 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1589 DROP DATABASE d10;
1590 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1591 Warnings:
1592 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.
1593 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1594 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1595 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1596 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1597 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1598 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1599 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1600 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1601 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1602 ALTER SCHEMA d10 COLLATE utf8_romanian_ci;
1603 Warnings:
1604 Warning 3778 'utf8mb3_romanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1605 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1606 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1607 def d10 utf8mb3 utf8mb3_romanian_ci NULL NO
1608 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1609 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1610 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1611 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1612 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1613 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1614 DROP DATABASE d10;
1615 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1616 Warnings:
1617 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.
1618 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1619 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1620 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1621 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1622 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1623 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1624 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1625 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1626 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1627 ALTER SCHEMA d10 DEFAULT COLLATE utf8_romanian_ci;
1628 Warnings:
1629 Warning 3778 'utf8mb3_romanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1630 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1631 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1632 def d10 utf8mb3 utf8mb3_romanian_ci NULL NO
1633 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1634 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1635 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1636 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1637 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1638 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1639 DROP DATABASE d10;
1640 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1641 Warnings:
1642 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.
1643 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1644 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1645 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1646 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1647 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1648 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1649 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1650 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1651 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1652 ALTER SCHEMA d10 COLLATE utf8_slovenian_ci;
1653 Warnings:
1654 Warning 3778 'utf8mb3_slovenian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1655 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1656 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1657 def d10 utf8mb3 utf8mb3_slovenian_ci NULL NO
1658 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1659 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1660 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1661 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1662 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1663 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1664 DROP DATABASE d10;
1665 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1666 Warnings:
1667 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.
1668 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1669 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1670 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1671 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1672 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1673 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1674 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1675 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1676 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1677 ALTER SCHEMA d10 DEFAULT COLLATE utf8_slovenian_ci;
1678 Warnings:
1679 Warning 3778 'utf8mb3_slovenian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1680 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1681 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1682 def d10 utf8mb3 utf8mb3_slovenian_ci NULL NO
1683 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1684 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1685 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1686 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1687 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1688 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1689 DROP DATABASE d10;
1690 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1691 Warnings:
1692 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.
1693 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1694 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1695 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1696 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1697 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1698 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1699 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1700 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1701 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1702 ALTER SCHEMA d10 COLLATE utf8_polish_ci;
1703 Warnings:
1704 Warning 3778 'utf8mb3_polish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1705 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1706 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1707 def d10 utf8mb3 utf8mb3_polish_ci NULL NO
1708 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1709 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1710 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1711 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1712 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1713 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1714 DROP DATABASE d10;
1715 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1716 Warnings:
1717 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.
1718 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1719 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1720 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1721 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1722 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1723 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1724 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1725 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1726 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1727 ALTER SCHEMA d10 DEFAULT COLLATE utf8_polish_ci;
1728 Warnings:
1729 Warning 3778 'utf8mb3_polish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1730 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1731 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1732 def d10 utf8mb3 utf8mb3_polish_ci NULL NO
1733 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1734 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1735 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1736 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1737 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1738 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1739 DROP DATABASE d10;
1740 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1741 Warnings:
1742 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.
1743 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1744 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1745 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1746 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1747 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1748 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1749 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1750 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1751 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1752 ALTER SCHEMA d10 COLLATE utf8_estonian_ci;
1753 Warnings:
1754 Warning 3778 'utf8mb3_estonian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1755 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1756 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1757 def d10 utf8mb3 utf8mb3_estonian_ci NULL NO
1758 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1759 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1760 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1761 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1762 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1763 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1764 DROP DATABASE d10;
1765 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1766 Warnings:
1767 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.
1768 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1769 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1770 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1771 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1772 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1773 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1774 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1775 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1776 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1777 ALTER SCHEMA d10 DEFAULT COLLATE utf8_estonian_ci;
1778 Warnings:
1779 Warning 3778 'utf8mb3_estonian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1780 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1781 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1782 def d10 utf8mb3 utf8mb3_estonian_ci NULL NO
1783 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1784 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1785 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1786 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1787 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1788 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1789 DROP DATABASE d10;
1790 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1791 Warnings:
1792 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.
1793 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1794 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1795 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1796 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1797 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1798 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1799 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1800 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1801 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1802 ALTER SCHEMA d10 COLLATE utf8_spanish_ci;
1803 Warnings:
1804 Warning 3778 'utf8mb3_spanish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1805 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1806 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1807 def d10 utf8mb3 utf8mb3_spanish_ci NULL NO
1808 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1809 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1810 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1811 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1812 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1813 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1814 DROP DATABASE d10;
1815 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1816 Warnings:
1817 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.
1818 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1819 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1820 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1821 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1822 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1823 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1824 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1825 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1826 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1827 ALTER SCHEMA d10 DEFAULT COLLATE utf8_spanish_ci;
1828 Warnings:
1829 Warning 3778 'utf8mb3_spanish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1830 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1831 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1832 def d10 utf8mb3 utf8mb3_spanish_ci NULL NO
1833 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1834 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1835 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1836 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1837 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1838 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1839 DROP DATABASE d10;
1840 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1841 Warnings:
1842 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.
1843 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1844 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1845 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1846 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1847 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1848 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1849 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1850 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1851 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1852 ALTER SCHEMA d10 COLLATE utf8_swedish_ci;
1853 Warnings:
1854 Warning 3778 'utf8mb3_swedish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1855 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1856 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1857 def d10 utf8mb3 utf8mb3_swedish_ci NULL NO
1858 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1859 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1860 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1861 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1862 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1863 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1864 DROP DATABASE d10;
1865 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1866 Warnings:
1867 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.
1868 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1869 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1870 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1871 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1872 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1873 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1874 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1875 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1876 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1877 ALTER SCHEMA d10 DEFAULT COLLATE utf8_swedish_ci;
1878 Warnings:
1879 Warning 3778 'utf8mb3_swedish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1880 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1881 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1882 def d10 utf8mb3 utf8mb3_swedish_ci NULL NO
1883 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1884 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1885 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1886 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1887 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1888 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1889 DROP DATABASE d10;
1890 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1891 Warnings:
1892 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.
1893 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1894 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1895 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1896 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1897 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1898 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1899 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1900 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1901 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1902 ALTER SCHEMA d10 COLLATE utf8_turkish_ci;
1903 Warnings:
1904 Warning 3778 'utf8mb3_turkish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1905 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1906 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1907 def d10 utf8mb3 utf8mb3_turkish_ci NULL NO
1908 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1909 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1910 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1911 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1912 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1913 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1914 DROP DATABASE d10;
1915 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1916 Warnings:
1917 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.
1918 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1919 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1920 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1921 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1922 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1923 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1924 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1925 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1926 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1927 ALTER SCHEMA d10 DEFAULT COLLATE utf8_turkish_ci;
1928 Warnings:
1929 Warning 3778 'utf8mb3_turkish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1930 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1931 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1932 def d10 utf8mb3 utf8mb3_turkish_ci NULL NO
1933 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1934 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1935 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1936 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1937 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1938 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1939 DROP DATABASE d10;
1940 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1941 Warnings:
1942 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.
1943 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1944 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1945 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1946 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1947 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1948 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1949 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1950 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1951 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1952 ALTER SCHEMA d10 COLLATE utf8_czech_ci;
1953 Warnings:
1954 Warning 3778 'utf8mb3_czech_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1955 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1956 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1957 def d10 utf8mb3 utf8mb3_czech_ci NULL NO
1958 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1959 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1960 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1961 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1962 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1963 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1964 DROP DATABASE d10;
1965 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1966 Warnings:
1967 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.
1968 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1969 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1970 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1971 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1972 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1973 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1974 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1975 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1976 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1977 ALTER SCHEMA d10 DEFAULT COLLATE utf8_czech_ci;
1978 Warnings:
1979 Warning 3778 'utf8mb3_czech_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1980 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1981 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1982 def d10 utf8mb3 utf8mb3_czech_ci NULL NO
1983 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1984 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1985 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1986 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
1987 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
1988 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
1989 DROP DATABASE d10;
1990 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
1991 Warnings:
1992 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.
1993 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
1994 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
1995 def d10 utf8mb3 utf8mb3_general_ci NULL NO
1996 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
1997 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
1998 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
1999 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2000 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2001 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2002 ALTER SCHEMA d10 COLLATE utf8_danish_ci;
2003 Warnings:
2004 Warning 3778 'utf8mb3_danish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2005 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2006 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2007 def d10 utf8mb3 utf8mb3_danish_ci NULL NO
2008 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2009 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2010 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2011 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2012 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2013 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2014 DROP DATABASE d10;
2015 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2016 Warnings:
2017 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.
2018 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2019 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2020 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2021 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2022 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2023 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2024 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2025 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2026 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2027 ALTER SCHEMA d10 DEFAULT COLLATE utf8_danish_ci;
2028 Warnings:
2029 Warning 3778 'utf8mb3_danish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2030 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2031 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2032 def d10 utf8mb3 utf8mb3_danish_ci NULL NO
2033 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2034 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2035 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2036 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2037 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2038 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2039 DROP DATABASE d10;
2040 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2041 Warnings:
2042 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.
2043 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2044 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2045 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2046 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2047 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2048 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2049 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2050 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2051 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2052 ALTER SCHEMA d10 COLLATE utf8_lithuanian_ci;
2053 Warnings:
2054 Warning 3778 'utf8mb3_lithuanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2055 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2056 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2057 def d10 utf8mb3 utf8mb3_lithuanian_ci NULL NO
2058 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2059 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2060 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2061 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2062 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2063 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2064 DROP DATABASE d10;
2065 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2066 Warnings:
2067 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.
2068 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2069 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2070 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2071 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2072 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2073 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2074 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2075 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2076 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2077 ALTER SCHEMA d10 DEFAULT COLLATE utf8_lithuanian_ci;
2078 Warnings:
2079 Warning 3778 'utf8mb3_lithuanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2080 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2081 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2082 def d10 utf8mb3 utf8mb3_lithuanian_ci NULL NO
2083 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2084 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2085 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2086 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2087 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2088 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2089 DROP DATABASE d10;
2090 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2091 Warnings:
2092 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.
2093 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2094 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2095 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2096 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2097 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2098 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2099 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2100 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2101 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2102 ALTER SCHEMA d10 COLLATE utf8_slovak_ci;
2103 Warnings:
2104 Warning 3778 'utf8mb3_slovak_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2105 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2106 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2107 def d10 utf8mb3 utf8mb3_slovak_ci NULL NO
2108 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2109 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2110 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2111 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2112 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2113 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2114 DROP DATABASE d10;
2115 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2116 Warnings:
2117 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.
2118 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2119 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2120 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2121 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2122 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2123 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2124 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2125 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2126 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2127 ALTER SCHEMA d10 DEFAULT COLLATE utf8_slovak_ci;
2128 Warnings:
2129 Warning 3778 'utf8mb3_slovak_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2130 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2131 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2132 def d10 utf8mb3 utf8mb3_slovak_ci NULL NO
2133 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2134 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2135 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2136 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2137 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2138 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2139 DROP DATABASE d10;
2140 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2141 Warnings:
2142 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.
2143 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2144 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2145 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2146 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2147 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2148 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2149 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2150 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2151 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2152 ALTER SCHEMA d10 COLLATE utf8_spanish2_ci;
2153 Warnings:
2154 Warning 3778 'utf8mb3_spanish2_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2155 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2156 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2157 def d10 utf8mb3 utf8mb3_spanish2_ci NULL NO
2158 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2159 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2160 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2161 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2162 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2163 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2164 DROP DATABASE d10;
2165 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2166 Warnings:
2167 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.
2168 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2169 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2170 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2171 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2172 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2173 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2174 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2175 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2176 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2177 ALTER SCHEMA d10 DEFAULT COLLATE utf8_spanish2_ci;
2178 Warnings:
2179 Warning 3778 'utf8mb3_spanish2_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2180 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2181 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2182 def d10 utf8mb3 utf8mb3_spanish2_ci NULL NO
2183 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2184 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2185 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2186 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2187 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2188 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2189 DROP DATABASE d10;
2190 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2191 Warnings:
2192 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.
2193 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2194 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2195 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2196 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2197 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2198 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2199 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2200 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2201 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2202 ALTER SCHEMA d10 COLLATE utf8_roman_ci;
2203 Warnings:
2204 Warning 3778 'utf8mb3_roman_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2205 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2206 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2207 def d10 utf8mb3 utf8mb3_roman_ci NULL NO
2208 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2209 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2210 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2211 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2212 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2213 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2214 DROP DATABASE d10;
2215 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2216 Warnings:
2217 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.
2218 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2219 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2220 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2221 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2222 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2223 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2224 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2225 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2226 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2227 ALTER SCHEMA d10 DEFAULT COLLATE utf8_roman_ci;
2228 Warnings:
2229 Warning 3778 'utf8mb3_roman_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2230 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2231 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2232 def d10 utf8mb3 utf8mb3_roman_ci NULL NO
2233 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2234 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2235 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2236 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2237 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2238 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2239 DROP DATABASE d10;
2240 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2241 Warnings:
2242 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.
2243 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2244 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2245 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2246 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2247 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2248 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2249 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2250 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2251 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2252 ALTER SCHEMA d10 COLLATE utf8_persian_ci;
2253 Warnings:
2254 Warning 3778 'utf8mb3_persian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2255 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2256 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2257 def d10 utf8mb3 utf8mb3_persian_ci NULL NO
2258 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2259 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2260 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2261 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2262 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2263 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2264 DROP DATABASE d10;
2265 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2266 Warnings:
2267 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.
2268 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2269 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2270 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2271 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2272 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2273 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2274 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2275 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2276 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2277 ALTER SCHEMA d10 DEFAULT COLLATE utf8_persian_ci;
2278 Warnings:
2279 Warning 3778 'utf8mb3_persian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2280 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2281 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2282 def d10 utf8mb3 utf8mb3_persian_ci NULL NO
2283 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2284 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2285 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2286 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2287 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2288 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2289 DROP DATABASE d10;
2290 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2291 Warnings:
2292 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.
2293 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2294 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2295 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2296 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2297 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2298 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2299 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2300 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2301 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2302 ALTER SCHEMA d10 COLLATE utf8_esperanto_ci;
2303 Warnings:
2304 Warning 3778 'utf8mb3_esperanto_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2305 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2306 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2307 def d10 utf8mb3 utf8mb3_esperanto_ci NULL NO
2308 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2309 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2310 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2311 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2312 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2313 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2314 DROP DATABASE d10;
2315 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2316 Warnings:
2317 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.
2318 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2319 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2320 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2321 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2322 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2323 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2324 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2325 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2326 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2327 ALTER SCHEMA d10 DEFAULT COLLATE utf8_esperanto_ci;
2328 Warnings:
2329 Warning 3778 'utf8mb3_esperanto_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2330 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2331 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2332 def d10 utf8mb3 utf8mb3_esperanto_ci NULL NO
2333 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2334 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2335 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2336 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2337 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2338 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2339 DROP DATABASE d10;
2340 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2341 Warnings:
2342 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.
2343 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2344 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2345 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2346 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2347 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2348 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2349 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2350 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2351 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2352 ALTER SCHEMA d10 COLLATE utf8_hungarian_ci;
2353 Warnings:
2354 Warning 3778 'utf8mb3_hungarian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2355 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2356 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2357 def d10 utf8mb3 utf8mb3_hungarian_ci NULL NO
2358 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2359 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2360 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2361 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2362 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2363 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2364 DROP DATABASE d10;
2365 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
2366 Warnings:
2367 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.
2368 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2369 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2370 def d10 utf8mb3 utf8mb3_general_ci NULL NO
2371 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2372 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2373 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2374 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2375 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2376 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2377 ALTER SCHEMA d10 DEFAULT COLLATE utf8_hungarian_ci;
2378 Warnings:
2379 Warning 3778 'utf8mb3_hungarian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2380 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
2381 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
2382 def d10 utf8mb3 utf8mb3_hungarian_ci NULL NO
2383 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
2384 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
2385 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
2386 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
2387 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
2388 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
2389 DROP DATABASE d10;