blob: b86c28e7344c6dd3eacf5e2125a17d9c04127d6b (
plain)
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
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
|
DROP DATABASE IF EXISTS d9;
SHOW COLLATION;
Collation Charset Id Default Compiled Sortlen
big5_chinese_ci big5 1 Yes # #
big5_bin big5 84 # #
big5_chinese_nopad_ci big5 1025 # #
big5_nopad_bin big5 1108 # #
dec8_swedish_ci dec8 3 Yes # #
dec8_bin dec8 69 # #
dec8_swedish_nopad_ci dec8 1027 # #
dec8_nopad_bin dec8 1093 # #
cp850_general_ci cp850 4 Yes # #
cp850_bin cp850 80 # #
cp850_general_nopad_ci cp850 1028 # #
cp850_nopad_bin cp850 1104 # #
hp8_english_ci hp8 6 Yes # #
hp8_bin hp8 72 # #
hp8_english_nopad_ci hp8 1030 # #
hp8_nopad_bin hp8 1096 # #
koi8r_general_ci koi8r 7 Yes # #
koi8r_bin koi8r 74 # #
koi8r_general_nopad_ci koi8r 1031 # #
koi8r_nopad_bin koi8r 1098 # #
latin1_german1_ci latin1 5 # #
latin1_swedish_ci latin1 8 Yes # #
latin1_danish_ci latin1 15 # #
latin1_german2_ci latin1 31 # #
latin1_bin latin1 47 # #
latin1_general_ci latin1 48 # #
latin1_general_cs latin1 49 # #
latin1_spanish_ci latin1 94 # #
latin1_swedish_nopad_ci latin1 1032 # #
latin1_nopad_bin latin1 1071 # #
latin2_czech_cs latin2 2 # #
latin2_general_ci latin2 9 Yes # #
latin2_hungarian_ci latin2 21 # #
latin2_croatian_ci latin2 27 # #
latin2_bin latin2 77 # #
latin2_general_nopad_ci latin2 1033 # #
latin2_nopad_bin latin2 1101 # #
swe7_swedish_ci swe7 10 Yes # #
swe7_bin swe7 82 # #
swe7_swedish_nopad_ci swe7 1034 # #
swe7_nopad_bin swe7 1106 # #
ascii_general_ci ascii 11 Yes # #
ascii_bin ascii 65 # #
ascii_general_nopad_ci ascii 1035 # #
ascii_nopad_bin ascii 1089 # #
ujis_japanese_ci ujis 12 Yes # #
ujis_bin ujis 91 # #
ujis_japanese_nopad_ci ujis 1036 # #
ujis_nopad_bin ujis 1115 # #
sjis_japanese_ci sjis 13 Yes # #
sjis_bin sjis 88 # #
sjis_japanese_nopad_ci sjis 1037 # #
sjis_nopad_bin sjis 1112 # #
hebrew_general_ci hebrew 16 Yes # #
hebrew_bin hebrew 71 # #
hebrew_general_nopad_ci hebrew 1040 # #
hebrew_nopad_bin hebrew 1095 # #
tis620_thai_ci tis620 18 Yes # #
tis620_bin tis620 89 # #
tis620_thai_nopad_ci tis620 1042 # #
tis620_nopad_bin tis620 1113 # #
euckr_korean_ci euckr 19 Yes # #
euckr_bin euckr 85 # #
euckr_korean_nopad_ci euckr 1043 # #
euckr_nopad_bin euckr 1109 # #
koi8u_general_ci koi8u 22 Yes # #
koi8u_bin koi8u 75 # #
koi8u_general_nopad_ci koi8u 1046 # #
koi8u_nopad_bin koi8u 1099 # #
gb2312_chinese_ci gb2312 24 Yes # #
gb2312_bin gb2312 86 # #
gb2312_chinese_nopad_ci gb2312 1048 # #
gb2312_nopad_bin gb2312 1110 # #
greek_general_ci greek 25 Yes # #
greek_bin greek 70 # #
greek_general_nopad_ci greek 1049 # #
greek_nopad_bin greek 1094 # #
cp1250_general_ci cp1250 26 Yes # #
cp1250_czech_cs cp1250 34 # #
cp1250_croatian_ci cp1250 44 # #
cp1250_bin cp1250 66 # #
cp1250_polish_ci cp1250 99 # #
cp1250_general_nopad_ci cp1250 1050 # #
cp1250_nopad_bin cp1250 1090 # #
gbk_chinese_ci gbk 28 Yes # #
gbk_bin gbk 87 # #
gbk_chinese_nopad_ci gbk 1052 # #
gbk_nopad_bin gbk 1111 # #
latin5_turkish_ci latin5 30 Yes # #
latin5_bin latin5 78 # #
latin5_turkish_nopad_ci latin5 1054 # #
latin5_nopad_bin latin5 1102 # #
armscii8_general_ci armscii8 32 Yes # #
armscii8_bin armscii8 64 # #
armscii8_general_nopad_ci armscii8 1056 # #
armscii8_nopad_bin armscii8 1088 # #
utf8mb3_general_ci utf8mb3 33 Yes # #
utf8mb3_bin utf8mb3 83 # #
utf8mb3_unicode_ci utf8mb3 192 # #
utf8mb3_icelandic_ci utf8mb3 193 # #
utf8mb3_latvian_ci utf8mb3 194 # #
utf8mb3_romanian_ci utf8mb3 195 # #
utf8mb3_slovenian_ci utf8mb3 196 # #
utf8mb3_polish_ci utf8mb3 197 # #
utf8mb3_estonian_ci utf8mb3 198 # #
utf8mb3_spanish_ci utf8mb3 199 # #
utf8mb3_swedish_ci utf8mb3 200 # #
utf8mb3_turkish_ci utf8mb3 201 # #
utf8mb3_czech_ci utf8mb3 202 # #
utf8mb3_danish_ci utf8mb3 203 # #
utf8mb3_lithuanian_ci utf8mb3 204 # #
utf8mb3_slovak_ci utf8mb3 205 # #
utf8mb3_spanish2_ci utf8mb3 206 # #
utf8mb3_roman_ci utf8mb3 207 # #
utf8mb3_persian_ci utf8mb3 208 # #
utf8mb3_esperanto_ci utf8mb3 209 # #
utf8mb3_hungarian_ci utf8mb3 210 # #
utf8mb3_sinhala_ci utf8mb3 211 # #
utf8mb3_german2_ci utf8mb3 212 # #
utf8mb3_croatian_mysql561_ci utf8mb3 213 # #
utf8mb3_unicode_520_ci utf8mb3 214 # #
utf8mb3_vietnamese_ci utf8mb3 215 # #
utf8mb3_general_mysql500_ci utf8mb3 223 # #
utf8mb3_croatian_ci utf8mb3 576 # #
utf8mb3_myanmar_ci utf8mb3 577 # #
utf8mb3_thai_520_w2 utf8mb3 578 # #
utf8mb3_general_nopad_ci utf8mb3 1057 # #
utf8mb3_nopad_bin utf8mb3 1107 # #
utf8mb3_unicode_nopad_ci utf8mb3 1216 # #
utf8mb3_unicode_520_nopad_ci utf8mb3 1238 # #
ucs2_general_ci ucs2 35 Yes # #
ucs2_bin ucs2 90 # #
ucs2_unicode_ci ucs2 128 # #
ucs2_icelandic_ci ucs2 129 # #
ucs2_latvian_ci ucs2 130 # #
ucs2_romanian_ci ucs2 131 # #
ucs2_slovenian_ci ucs2 132 # #
ucs2_polish_ci ucs2 133 # #
ucs2_estonian_ci ucs2 134 # #
ucs2_spanish_ci ucs2 135 # #
ucs2_swedish_ci ucs2 136 # #
ucs2_turkish_ci ucs2 137 # #
ucs2_czech_ci ucs2 138 # #
ucs2_danish_ci ucs2 139 # #
ucs2_lithuanian_ci ucs2 140 # #
ucs2_slovak_ci ucs2 141 # #
ucs2_spanish2_ci ucs2 142 # #
ucs2_roman_ci ucs2 143 # #
ucs2_persian_ci ucs2 144 # #
ucs2_esperanto_ci ucs2 145 # #
ucs2_hungarian_ci ucs2 146 # #
ucs2_sinhala_ci ucs2 147 # #
ucs2_german2_ci ucs2 148 # #
ucs2_croatian_mysql561_ci ucs2 149 # #
ucs2_unicode_520_ci ucs2 150 # #
ucs2_vietnamese_ci ucs2 151 # #
ucs2_general_mysql500_ci ucs2 159 # #
ucs2_croatian_ci ucs2 640 # #
ucs2_myanmar_ci ucs2 641 # #
ucs2_thai_520_w2 ucs2 642 # #
ucs2_general_nopad_ci ucs2 1059 # #
ucs2_nopad_bin ucs2 1114 # #
ucs2_unicode_nopad_ci ucs2 1152 # #
ucs2_unicode_520_nopad_ci ucs2 1174 # #
cp866_general_ci cp866 36 Yes # #
cp866_bin cp866 68 # #
cp866_general_nopad_ci cp866 1060 # #
cp866_nopad_bin cp866 1092 # #
keybcs2_general_ci keybcs2 37 Yes # #
keybcs2_bin keybcs2 73 # #
keybcs2_general_nopad_ci keybcs2 1061 # #
keybcs2_nopad_bin keybcs2 1097 # #
macce_general_ci macce 38 Yes # #
macce_bin macce 43 # #
macce_general_nopad_ci macce 1062 # #
macce_nopad_bin macce 1067 # #
macroman_general_ci macroman 39 Yes # #
macroman_bin macroman 53 # #
macroman_general_nopad_ci macroman 1063 # #
macroman_nopad_bin macroman 1077 # #
cp852_general_ci cp852 40 Yes # #
cp852_bin cp852 81 # #
cp852_general_nopad_ci cp852 1064 # #
cp852_nopad_bin cp852 1105 # #
latin7_estonian_cs latin7 20 # #
latin7_general_ci latin7 41 Yes # #
latin7_general_cs latin7 42 # #
latin7_bin latin7 79 # #
latin7_general_nopad_ci latin7 1065 # #
latin7_nopad_bin latin7 1103 # #
utf8mb4_general_ci utf8mb4 45 Yes # #
utf8mb4_bin utf8mb4 46 # #
utf8mb4_unicode_ci utf8mb4 224 # #
utf8mb4_icelandic_ci utf8mb4 225 # #
utf8mb4_latvian_ci utf8mb4 226 # #
utf8mb4_romanian_ci utf8mb4 227 # #
utf8mb4_slovenian_ci utf8mb4 228 # #
utf8mb4_polish_ci utf8mb4 229 # #
utf8mb4_estonian_ci utf8mb4 230 # #
utf8mb4_spanish_ci utf8mb4 231 # #
utf8mb4_swedish_ci utf8mb4 232 # #
utf8mb4_turkish_ci utf8mb4 233 # #
utf8mb4_czech_ci utf8mb4 234 # #
utf8mb4_danish_ci utf8mb4 235 # #
utf8mb4_lithuanian_ci utf8mb4 236 # #
utf8mb4_slovak_ci utf8mb4 237 # #
utf8mb4_spanish2_ci utf8mb4 238 # #
utf8mb4_roman_ci utf8mb4 239 # #
utf8mb4_persian_ci utf8mb4 240 # #
utf8mb4_esperanto_ci utf8mb4 241 # #
utf8mb4_hungarian_ci utf8mb4 242 # #
utf8mb4_sinhala_ci utf8mb4 243 # #
utf8mb4_german2_ci utf8mb4 244 # #
utf8mb4_croatian_mysql561_ci utf8mb4 245 # #
utf8mb4_unicode_520_ci utf8mb4 246 # #
utf8mb4_vietnamese_ci utf8mb4 247 # #
utf8mb4_croatian_ci utf8mb4 608 # #
utf8mb4_myanmar_ci utf8mb4 609 # #
utf8mb4_thai_520_w2 utf8mb4 610 # #
utf8mb4_general_nopad_ci utf8mb4 1069 # #
utf8mb4_nopad_bin utf8mb4 1070 # #
utf8mb4_unicode_nopad_ci utf8mb4 1248 # #
utf8mb4_unicode_520_nopad_ci utf8mb4 1270 # #
cp1251_bulgarian_ci cp1251 14 # #
cp1251_ukrainian_ci cp1251 23 # #
cp1251_bin cp1251 50 # #
cp1251_general_ci cp1251 51 Yes # #
cp1251_general_cs cp1251 52 # #
cp1251_nopad_bin cp1251 1074 # #
cp1251_general_nopad_ci cp1251 1075 # #
utf16_general_ci utf16 54 Yes # #
utf16_bin utf16 55 # #
utf16_unicode_ci utf16 101 # #
utf16_icelandic_ci utf16 102 # #
utf16_latvian_ci utf16 103 # #
utf16_romanian_ci utf16 104 # #
utf16_slovenian_ci utf16 105 # #
utf16_polish_ci utf16 106 # #
utf16_estonian_ci utf16 107 # #
utf16_spanish_ci utf16 108 # #
utf16_swedish_ci utf16 109 # #
utf16_turkish_ci utf16 110 # #
utf16_czech_ci utf16 111 # #
utf16_danish_ci utf16 112 # #
utf16_lithuanian_ci utf16 113 # #
utf16_slovak_ci utf16 114 # #
utf16_spanish2_ci utf16 115 # #
utf16_roman_ci utf16 116 # #
utf16_persian_ci utf16 117 # #
utf16_esperanto_ci utf16 118 # #
utf16_hungarian_ci utf16 119 # #
utf16_sinhala_ci utf16 120 # #
utf16_german2_ci utf16 121 # #
utf16_croatian_mysql561_ci utf16 122 # #
utf16_unicode_520_ci utf16 123 # #
utf16_vietnamese_ci utf16 124 # #
utf16_croatian_ci utf16 672 # #
utf16_myanmar_ci utf16 673 # #
utf16_thai_520_w2 utf16 674 # #
utf16_general_nopad_ci utf16 1078 # #
utf16_nopad_bin utf16 1079 # #
utf16_unicode_nopad_ci utf16 1125 # #
utf16_unicode_520_nopad_ci utf16 1147 # #
utf16le_general_ci utf16le 56 Yes # #
utf16le_bin utf16le 62 # #
utf16le_general_nopad_ci utf16le 1080 # #
utf16le_nopad_bin utf16le 1086 # #
cp1256_general_ci cp1256 57 Yes # #
cp1256_bin cp1256 67 # #
cp1256_general_nopad_ci cp1256 1081 # #
cp1256_nopad_bin cp1256 1091 # #
cp1257_lithuanian_ci cp1257 29 # #
cp1257_bin cp1257 58 # #
cp1257_general_ci cp1257 59 Yes # #
cp1257_nopad_bin cp1257 1082 # #
cp1257_general_nopad_ci cp1257 1083 # #
utf32_general_ci utf32 60 Yes # #
utf32_bin utf32 61 # #
utf32_unicode_ci utf32 160 # #
utf32_icelandic_ci utf32 161 # #
utf32_latvian_ci utf32 162 # #
utf32_romanian_ci utf32 163 # #
utf32_slovenian_ci utf32 164 # #
utf32_polish_ci utf32 165 # #
utf32_estonian_ci utf32 166 # #
utf32_spanish_ci utf32 167 # #
utf32_swedish_ci utf32 168 # #
utf32_turkish_ci utf32 169 # #
utf32_czech_ci utf32 170 # #
utf32_danish_ci utf32 171 # #
utf32_lithuanian_ci utf32 172 # #
utf32_slovak_ci utf32 173 # #
utf32_spanish2_ci utf32 174 # #
utf32_roman_ci utf32 175 # #
utf32_persian_ci utf32 176 # #
utf32_esperanto_ci utf32 177 # #
utf32_hungarian_ci utf32 178 # #
utf32_sinhala_ci utf32 179 # #
utf32_german2_ci utf32 180 # #
utf32_croatian_mysql561_ci utf32 181 # #
utf32_unicode_520_ci utf32 182 # #
utf32_vietnamese_ci utf32 183 # #
utf32_croatian_ci utf32 736 # #
utf32_myanmar_ci utf32 737 # #
utf32_thai_520_w2 utf32 738 # #
utf32_general_nopad_ci utf32 1084 # #
utf32_nopad_bin utf32 1085 # #
utf32_unicode_nopad_ci utf32 1184 # #
utf32_unicode_520_nopad_ci utf32 1206 # #
binary binary 63 Yes # #
geostd8_general_ci geostd8 92 Yes # #
geostd8_bin geostd8 93 # #
geostd8_general_nopad_ci geostd8 1116 # #
geostd8_nopad_bin geostd8 1117 # #
cp932_japanese_ci cp932 95 Yes # #
cp932_bin cp932 96 # #
cp932_japanese_nopad_ci cp932 1119 # #
cp932_nopad_bin cp932 1120 # #
eucjpms_japanese_ci eucjpms 97 Yes # #
eucjpms_bin eucjpms 98 # #
eucjpms_japanese_nopad_ci eucjpms 1121 # #
eucjpms_nopad_bin eucjpms 1122 # #
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_bin NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_bin NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_bin NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_bin NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
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 SCHEMA_COMMENT
def d9 ascii ascii_general_ci NULL
def information_schema utf8mb3 utf8mb3_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8mb3 utf8mb3_general_ci NULL
def sys utf8mb3 utf8mb3_general_ci NULL
def test latin1 latin1_swedish_ci NULL
DROP DATABASE d9;
|
