/
db_alter_collate_ascii.result
457 lines (457 loc) · 20.8 KB
/
db_alter_collate_ascii.result
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
DROP DATABASE IF EXISTS d9;
SHOW COLLATION;
Collation Charset Id Default Compiled Sortlen Pad_attribute
armscii8_bin armscii8 64 # # PAD SPACE
armscii8_general_ci armscii8 32 Yes # # PAD SPACE
ascii_bin ascii 65 # # PAD SPACE
ascii_general_ci ascii 11 Yes # # PAD SPACE
big5_bin big5 84 # # PAD SPACE
big5_chinese_ci big5 1 Yes # # PAD SPACE
binary binary 63 Yes # # NO PAD
cp1250_bin cp1250 66 # # PAD SPACE
cp1250_croatian_ci cp1250 44 # # PAD SPACE
cp1250_czech_cs cp1250 34 # # PAD SPACE
cp1250_general_ci cp1250 26 Yes # # PAD SPACE
cp1250_polish_ci cp1250 99 # # PAD SPACE
cp1251_bin cp1251 50 # # PAD SPACE
cp1251_bulgarian_ci cp1251 14 # # PAD SPACE
cp1251_general_ci cp1251 51 Yes # # PAD SPACE
cp1251_general_cs cp1251 52 # # PAD SPACE
cp1251_ukrainian_ci cp1251 23 # # PAD SPACE
cp1256_bin cp1256 67 # # PAD SPACE
cp1256_general_ci cp1256 57 Yes # # PAD SPACE
cp1257_bin cp1257 58 # # PAD SPACE
cp1257_general_ci cp1257 59 Yes # # PAD SPACE
cp1257_lithuanian_ci cp1257 29 # # PAD SPACE
cp850_bin cp850 80 # # PAD SPACE
cp850_general_ci cp850 4 Yes # # PAD SPACE
cp852_bin cp852 81 # # PAD SPACE
cp852_general_ci cp852 40 Yes # # PAD SPACE
cp866_bin cp866 68 # # PAD SPACE
cp866_general_ci cp866 36 Yes # # PAD SPACE
cp932_bin cp932 96 # # PAD SPACE
cp932_japanese_ci cp932 95 Yes # # PAD SPACE
dec8_bin dec8 69 # # PAD SPACE
dec8_swedish_ci dec8 3 Yes # # PAD SPACE
eucjpms_bin eucjpms 98 # # PAD SPACE
eucjpms_japanese_ci eucjpms 97 Yes # # PAD SPACE
euckr_bin euckr 85 # # PAD SPACE
euckr_korean_ci euckr 19 Yes # # PAD SPACE
gb18030_bin gb18030 249 # # PAD SPACE
gb18030_chinese_ci gb18030 248 Yes # # PAD SPACE
gb18030_unicode_520_ci gb18030 250 # # PAD SPACE
gb2312_bin gb2312 86 # # PAD SPACE
gb2312_chinese_ci gb2312 24 Yes # # PAD SPACE
gbk_bin gbk 87 # # PAD SPACE
gbk_chinese_ci gbk 28 Yes # # PAD SPACE
geostd8_bin geostd8 93 # # PAD SPACE
geostd8_general_ci geostd8 92 Yes # # PAD SPACE
greek_bin greek 70 # # PAD SPACE
greek_general_ci greek 25 Yes # # PAD SPACE
hebrew_bin hebrew 71 # # PAD SPACE
hebrew_general_ci hebrew 16 Yes # # PAD SPACE
hp8_bin hp8 72 # # PAD SPACE
hp8_english_ci hp8 6 Yes # # PAD SPACE
keybcs2_bin keybcs2 73 # # PAD SPACE
keybcs2_general_ci keybcs2 37 Yes # # PAD SPACE
koi8r_bin koi8r 74 # # PAD SPACE
koi8r_general_ci koi8r 7 Yes # # PAD SPACE
koi8u_bin koi8u 75 # # PAD SPACE
koi8u_general_ci koi8u 22 Yes # # PAD SPACE
latin1_bin latin1 47 # # PAD SPACE
latin1_danish_ci latin1 15 # # PAD SPACE
latin1_general_ci latin1 48 # # PAD SPACE
latin1_general_cs latin1 49 # # PAD SPACE
latin1_german1_ci latin1 5 # # PAD SPACE
latin1_german2_ci latin1 31 # # PAD SPACE
latin1_spanish_ci latin1 94 # # PAD SPACE
latin1_swedish_ci latin1 8 Yes # # PAD SPACE
latin2_bin latin2 77 # # PAD SPACE
latin2_croatian_ci latin2 27 # # PAD SPACE
latin2_czech_cs latin2 2 # # PAD SPACE
latin2_general_ci latin2 9 Yes # # PAD SPACE
latin2_hungarian_ci latin2 21 # # PAD SPACE
latin5_bin latin5 78 # # PAD SPACE
latin5_turkish_ci latin5 30 Yes # # PAD SPACE
latin7_bin latin7 79 # # PAD SPACE
latin7_estonian_cs latin7 20 # # PAD SPACE
latin7_general_ci latin7 41 Yes # # PAD SPACE
latin7_general_cs latin7 42 # # PAD SPACE
macce_bin macce 43 # # PAD SPACE
macce_general_ci macce 38 Yes # # PAD SPACE
macroman_bin macroman 53 # # PAD SPACE
macroman_general_ci macroman 39 Yes # # PAD SPACE
sjis_bin sjis 88 # # PAD SPACE
sjis_japanese_ci sjis 13 Yes # # PAD SPACE
swe7_bin swe7 82 # # PAD SPACE
swe7_swedish_ci swe7 10 Yes # # PAD SPACE
tis620_bin tis620 89 # # PAD SPACE
tis620_thai_ci tis620 18 Yes # # PAD SPACE
ucs2_bin ucs2 90 # # PAD SPACE
ucs2_croatian_ci ucs2 149 # # PAD SPACE
ucs2_czech_ci ucs2 138 # # PAD SPACE
ucs2_danish_ci ucs2 139 # # PAD SPACE
ucs2_esperanto_ci ucs2 145 # # PAD SPACE
ucs2_estonian_ci ucs2 134 # # PAD SPACE
ucs2_general_ci ucs2 35 Yes # # PAD SPACE
ucs2_general_mysql500_ci ucs2 159 # # PAD SPACE
ucs2_german2_ci ucs2 148 # # PAD SPACE
ucs2_hungarian_ci ucs2 146 # # PAD SPACE
ucs2_icelandic_ci ucs2 129 # # PAD SPACE
ucs2_latvian_ci ucs2 130 # # PAD SPACE
ucs2_lithuanian_ci ucs2 140 # # PAD SPACE
ucs2_persian_ci ucs2 144 # # PAD SPACE
ucs2_polish_ci ucs2 133 # # PAD SPACE
ucs2_romanian_ci ucs2 131 # # PAD SPACE
ucs2_roman_ci ucs2 143 # # PAD SPACE
ucs2_sinhala_ci ucs2 147 # # PAD SPACE
ucs2_slovak_ci ucs2 141 # # PAD SPACE
ucs2_slovenian_ci ucs2 132 # # PAD SPACE
ucs2_spanish2_ci ucs2 142 # # PAD SPACE
ucs2_spanish_ci ucs2 135 # # PAD SPACE
ucs2_swedish_ci ucs2 136 # # PAD SPACE
ucs2_turkish_ci ucs2 137 # # PAD SPACE
ucs2_unicode_520_ci ucs2 150 # # PAD SPACE
ucs2_unicode_ci ucs2 128 # # PAD SPACE
ucs2_vietnamese_ci ucs2 151 # # PAD SPACE
ujis_bin ujis 91 # # PAD SPACE
ujis_japanese_ci ujis 12 Yes # # PAD SPACE
utf16le_bin utf16le 62 # # PAD SPACE
utf16le_general_ci utf16le 56 Yes # # PAD SPACE
utf16_bin utf16 55 # # PAD SPACE
utf16_croatian_ci utf16 122 # # PAD SPACE
utf16_czech_ci utf16 111 # # PAD SPACE
utf16_danish_ci utf16 112 # # PAD SPACE
utf16_esperanto_ci utf16 118 # # PAD SPACE
utf16_estonian_ci utf16 107 # # PAD SPACE
utf16_general_ci utf16 54 Yes # # PAD SPACE
utf16_german2_ci utf16 121 # # PAD SPACE
utf16_hungarian_ci utf16 119 # # PAD SPACE
utf16_icelandic_ci utf16 102 # # PAD SPACE
utf16_latvian_ci utf16 103 # # PAD SPACE
utf16_lithuanian_ci utf16 113 # # PAD SPACE
utf16_persian_ci utf16 117 # # PAD SPACE
utf16_polish_ci utf16 106 # # PAD SPACE
utf16_romanian_ci utf16 104 # # PAD SPACE
utf16_roman_ci utf16 116 # # PAD SPACE
utf16_sinhala_ci utf16 120 # # PAD SPACE
utf16_slovak_ci utf16 114 # # PAD SPACE
utf16_slovenian_ci utf16 105 # # PAD SPACE
utf16_spanish2_ci utf16 115 # # PAD SPACE
utf16_spanish_ci utf16 108 # # PAD SPACE
utf16_swedish_ci utf16 109 # # PAD SPACE
utf16_turkish_ci utf16 110 # # PAD SPACE
utf16_unicode_520_ci utf16 123 # # PAD SPACE
utf16_unicode_ci utf16 101 # # PAD SPACE
utf16_vietnamese_ci utf16 124 # # PAD SPACE
utf32_bin utf32 61 # # PAD SPACE
utf32_croatian_ci utf32 181 # # PAD SPACE
utf32_czech_ci utf32 170 # # PAD SPACE
utf32_danish_ci utf32 171 # # PAD SPACE
utf32_esperanto_ci utf32 177 # # PAD SPACE
utf32_estonian_ci utf32 166 # # PAD SPACE
utf32_general_ci utf32 60 Yes # # PAD SPACE
utf32_german2_ci utf32 180 # # PAD SPACE
utf32_hungarian_ci utf32 178 # # PAD SPACE
utf32_icelandic_ci utf32 161 # # PAD SPACE
utf32_latvian_ci utf32 162 # # PAD SPACE
utf32_lithuanian_ci utf32 172 # # PAD SPACE
utf32_persian_ci utf32 176 # # PAD SPACE
utf32_polish_ci utf32 165 # # PAD SPACE
utf32_romanian_ci utf32 163 # # PAD SPACE
utf32_roman_ci utf32 175 # # PAD SPACE
utf32_sinhala_ci utf32 179 # # PAD SPACE
utf32_slovak_ci utf32 173 # # PAD SPACE
utf32_slovenian_ci utf32 164 # # PAD SPACE
utf32_spanish2_ci utf32 174 # # PAD SPACE
utf32_spanish_ci utf32 167 # # PAD SPACE
utf32_swedish_ci utf32 168 # # PAD SPACE
utf32_turkish_ci utf32 169 # # PAD SPACE
utf32_unicode_520_ci utf32 182 # # PAD SPACE
utf32_unicode_ci utf32 160 # # PAD SPACE
utf32_vietnamese_ci utf32 183 # # PAD SPACE
utf8mb3_bin utf8mb3 83 # # PAD SPACE
utf8mb3_croatian_ci utf8mb3 213 # # PAD SPACE
utf8mb3_czech_ci utf8mb3 202 # # PAD SPACE
utf8mb3_danish_ci utf8mb3 203 # # PAD SPACE
utf8mb3_esperanto_ci utf8mb3 209 # # PAD SPACE
utf8mb3_estonian_ci utf8mb3 198 # # PAD SPACE
utf8mb3_general_ci utf8mb3 33 Yes # # PAD SPACE
utf8mb3_general_mysql500_ci utf8mb3 223 # # PAD SPACE
utf8mb3_german2_ci utf8mb3 212 # # PAD SPACE
utf8mb3_hungarian_ci utf8mb3 210 # # PAD SPACE
utf8mb3_icelandic_ci utf8mb3 193 # # PAD SPACE
utf8mb3_latvian_ci utf8mb3 194 # # PAD SPACE
utf8mb3_lithuanian_ci utf8mb3 204 # # PAD SPACE
utf8mb3_persian_ci utf8mb3 208 # # PAD SPACE
utf8mb3_polish_ci utf8mb3 197 # # PAD SPACE
utf8mb3_romanian_ci utf8mb3 195 # # PAD SPACE
utf8mb3_roman_ci utf8mb3 207 # # PAD SPACE
utf8mb3_sinhala_ci utf8mb3 211 # # PAD SPACE
utf8mb3_slovak_ci utf8mb3 205 # # PAD SPACE
utf8mb3_slovenian_ci utf8mb3 196 # # PAD SPACE
utf8mb3_spanish2_ci utf8mb3 206 # # PAD SPACE
utf8mb3_spanish_ci utf8mb3 199 # # PAD SPACE
utf8mb3_swedish_ci utf8mb3 200 # # PAD SPACE
utf8mb3_tolower_ci utf8mb3 76 # # PAD SPACE
utf8mb3_turkish_ci utf8mb3 201 # # PAD SPACE
utf8mb3_unicode_520_ci utf8mb3 214 # # PAD SPACE
utf8mb3_unicode_ci utf8mb3 192 # # PAD SPACE
utf8mb3_vietnamese_ci utf8mb3 215 # # PAD SPACE
utf8mb4_0900_ai_ci utf8mb4 255 Yes # # NO PAD
utf8mb4_0900_as_ci utf8mb4 305 # # NO PAD
utf8mb4_0900_as_cs utf8mb4 278 # # NO PAD
utf8mb4_0900_bin utf8mb4 309 # # NO PAD
utf8mb4_bg_0900_ai_ci utf8mb4 318 # # NO PAD
utf8mb4_bg_0900_as_cs utf8mb4 319 # # NO PAD
utf8mb4_bin utf8mb4 46 # # PAD SPACE
utf8mb4_bs_0900_ai_ci utf8mb4 316 # # NO PAD
utf8mb4_bs_0900_as_cs utf8mb4 317 # # NO PAD
utf8mb4_croatian_ci utf8mb4 245 # # PAD SPACE
utf8mb4_cs_0900_ai_ci utf8mb4 266 # # NO PAD
utf8mb4_cs_0900_as_cs utf8mb4 289 # # NO PAD
utf8mb4_czech_ci utf8mb4 234 # # PAD SPACE
utf8mb4_danish_ci utf8mb4 235 # # PAD SPACE
utf8mb4_da_0900_ai_ci utf8mb4 267 # # NO PAD
utf8mb4_da_0900_as_cs utf8mb4 290 # # NO PAD
utf8mb4_de_pb_0900_ai_ci utf8mb4 256 # # NO PAD
utf8mb4_de_pb_0900_as_cs utf8mb4 279 # # NO PAD
utf8mb4_eo_0900_ai_ci utf8mb4 273 # # NO PAD
utf8mb4_eo_0900_as_cs utf8mb4 296 # # NO PAD
utf8mb4_esperanto_ci utf8mb4 241 # # PAD SPACE
utf8mb4_estonian_ci utf8mb4 230 # # PAD SPACE
utf8mb4_es_0900_ai_ci utf8mb4 263 # # NO PAD
utf8mb4_es_0900_as_cs utf8mb4 286 # # NO PAD
utf8mb4_es_trad_0900_ai_ci utf8mb4 270 # # NO PAD
utf8mb4_es_trad_0900_as_cs utf8mb4 293 # # NO PAD
utf8mb4_et_0900_ai_ci utf8mb4 262 # # NO PAD
utf8mb4_et_0900_as_cs utf8mb4 285 # # NO PAD
utf8mb4_general_ci utf8mb4 45 # # PAD SPACE
utf8mb4_german2_ci utf8mb4 244 # # PAD SPACE
utf8mb4_gl_0900_ai_ci utf8mb4 320 # # NO PAD
utf8mb4_gl_0900_as_cs utf8mb4 321 # # NO PAD
utf8mb4_hr_0900_ai_ci utf8mb4 275 # # NO PAD
utf8mb4_hr_0900_as_cs utf8mb4 298 # # NO PAD
utf8mb4_hungarian_ci utf8mb4 242 # # PAD SPACE
utf8mb4_hu_0900_ai_ci utf8mb4 274 # # NO PAD
utf8mb4_hu_0900_as_cs utf8mb4 297 # # NO PAD
utf8mb4_icelandic_ci utf8mb4 225 # # PAD SPACE
utf8mb4_is_0900_ai_ci utf8mb4 257 # # NO PAD
utf8mb4_is_0900_as_cs utf8mb4 280 # # NO PAD
utf8mb4_ja_0900_as_cs utf8mb4 303 # # NO PAD
utf8mb4_ja_0900_as_cs_ks utf8mb4 304 # # NO PAD
utf8mb4_latvian_ci utf8mb4 226 # # PAD SPACE
utf8mb4_la_0900_ai_ci utf8mb4 271 # # NO PAD
utf8mb4_la_0900_as_cs utf8mb4 294 # # NO PAD
utf8mb4_lithuanian_ci utf8mb4 236 # # PAD SPACE
utf8mb4_lt_0900_ai_ci utf8mb4 268 # # NO PAD
utf8mb4_lt_0900_as_cs utf8mb4 291 # # NO PAD
utf8mb4_lv_0900_ai_ci utf8mb4 258 # # NO PAD
utf8mb4_lv_0900_as_cs utf8mb4 281 # # NO PAD
utf8mb4_mn_cyrl_0900_ai_ci utf8mb4 322 # # NO PAD
utf8mb4_mn_cyrl_0900_as_cs utf8mb4 323 # # NO PAD
utf8mb4_nb_0900_ai_ci utf8mb4 310 # # NO PAD
utf8mb4_nb_0900_as_cs utf8mb4 311 # # NO PAD
utf8mb4_nn_0900_ai_ci utf8mb4 312 # # NO PAD
utf8mb4_nn_0900_as_cs utf8mb4 313 # # NO PAD
utf8mb4_persian_ci utf8mb4 240 # # PAD SPACE
utf8mb4_pl_0900_ai_ci utf8mb4 261 # # NO PAD
utf8mb4_pl_0900_as_cs utf8mb4 284 # # NO PAD
utf8mb4_polish_ci utf8mb4 229 # # PAD SPACE
utf8mb4_romanian_ci utf8mb4 227 # # PAD SPACE
utf8mb4_roman_ci utf8mb4 239 # # PAD SPACE
utf8mb4_ro_0900_ai_ci utf8mb4 259 # # NO PAD
utf8mb4_ro_0900_as_cs utf8mb4 282 # # NO PAD
utf8mb4_ru_0900_ai_ci utf8mb4 306 # # NO PAD
utf8mb4_ru_0900_as_cs utf8mb4 307 # # NO PAD
utf8mb4_sinhala_ci utf8mb4 243 # # PAD SPACE
utf8mb4_sk_0900_ai_ci utf8mb4 269 # # NO PAD
utf8mb4_sk_0900_as_cs utf8mb4 292 # # NO PAD
utf8mb4_slovak_ci utf8mb4 237 # # PAD SPACE
utf8mb4_slovenian_ci utf8mb4 228 # # PAD SPACE
utf8mb4_sl_0900_ai_ci utf8mb4 260 # # NO PAD
utf8mb4_sl_0900_as_cs utf8mb4 283 # # NO PAD
utf8mb4_spanish2_ci utf8mb4 238 # # PAD SPACE
utf8mb4_spanish_ci utf8mb4 231 # # PAD SPACE
utf8mb4_sr_latn_0900_ai_ci utf8mb4 314 # # NO PAD
utf8mb4_sr_latn_0900_as_cs utf8mb4 315 # # NO PAD
utf8mb4_sv_0900_ai_ci utf8mb4 264 # # NO PAD
utf8mb4_sv_0900_as_cs utf8mb4 287 # # NO PAD
utf8mb4_swedish_ci utf8mb4 232 # # PAD SPACE
utf8mb4_tr_0900_ai_ci utf8mb4 265 # # NO PAD
utf8mb4_tr_0900_as_cs utf8mb4 288 # # NO PAD
utf8mb4_turkish_ci utf8mb4 233 # # PAD SPACE
utf8mb4_unicode_520_ci utf8mb4 246 # # PAD SPACE
utf8mb4_unicode_ci utf8mb4 224 # # PAD SPACE
utf8mb4_vietnamese_ci utf8mb4 247 # # PAD SPACE
utf8mb4_vi_0900_ai_ci utf8mb4 277 # # NO PAD
utf8mb4_vi_0900_as_cs utf8mb4 300 # # NO PAD
utf8mb4_zh_0900_as_cs utf8mb4 308 # # NO PAD
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
ALTER DATABASE d9 COLLATE ascii_bin;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_bin NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
DROP DATABASE d9;
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
ALTER DATABASE d9 DEFAULT COLLATE ascii_bin;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_bin NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
DROP DATABASE d9;
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
ALTER DATABASE d9 COLLATE ascii_general_ci;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
DROP DATABASE d9;
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
ALTER DATABASE d9 DEFAULT COLLATE ascii_general_ci;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
DROP DATABASE d9;
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
ALTER SCHEMA d9 COLLATE ascii_bin;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_bin NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
DROP DATABASE d9;
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
ALTER SCHEMA d9 DEFAULT COLLATE ascii_bin;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_bin NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
DROP DATABASE d9;
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
ALTER SCHEMA d9 COLLATE ascii_general_ci;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
DROP DATABASE d9;
CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
ALTER SCHEMA d9 DEFAULT COLLATE ascii_general_ci;
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
def d9 ascii ascii_general_ci NULL NO
def information_schema utf8mb3 utf8mb3_general_ci NULL NO
def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
DROP DATABASE d9;