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
|
DROP DATABASE IF EXISTS d9;
SHOW COLLATION;
Collation Charset Id Default Compiled Sortlen
big5_chinese_ci big5 1 Yes # #
big5_bin big5 84 # #
dec8_swedish_ci dec8 3 Yes # #
dec8_bin dec8 69 # #
cp850_general_ci cp850 4 Yes # #
cp850_bin cp850 80 # #
hp8_english_ci hp8 6 Yes # #
hp8_bin hp8 72 # #
koi8r_general_ci koi8r 7 Yes # #
koi8r_bin koi8r 74 # #
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 # #
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 # #
swe7_swedish_ci swe7 10 Yes # #
swe7_bin swe7 82 # #
ascii_general_ci ascii 11 Yes # #
ascii_bin ascii 65 # #
ujis_japanese_ci ujis 12 Yes # #
ujis_bin ujis 91 # #
sjis_japanese_ci sjis 13 Yes # #
sjis_bin sjis 88 # #
hebrew_general_ci hebrew 16 Yes # #
hebrew_bin hebrew 71 # #
tis620_thai_ci tis620 18 Yes # #
tis620_bin tis620 89 # #
euckr_korean_ci euckr 19 Yes # #
euckr_bin euckr 85 # #
koi8u_general_ci koi8u 22 Yes # #
koi8u_bin koi8u 75 # #
gb2312_chinese_ci gb2312 24 Yes # #
gb2312_bin gb2312 86 # #
greek_general_ci greek 25 Yes # #
greek_bin greek 70 # #
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 # #
gbk_chinese_ci gbk 28 Yes # #
gbk_bin gbk 87 # #
latin5_turkish_ci latin5 30 Yes # #
latin5_bin latin5 78 # #
armscii8_general_ci armscii8 32 Yes # #
armscii8_bin armscii8 64 # #
utf8_general_ci utf8 33 Yes # #
utf8_bin utf8 83 # #
utf8_unicode_ci utf8 192 # #
utf8_icelandic_ci utf8 193 # #
utf8_latvian_ci utf8 194 # #
utf8_romanian_ci utf8 195 # #
utf8_slovenian_ci utf8 196 # #
utf8_polish_ci utf8 197 # #
utf8_estonian_ci utf8 198 # #
utf8_spanish_ci utf8 199 # #
utf8_swedish_ci utf8 200 # #
utf8_turkish_ci utf8 201 # #
utf8_czech_ci utf8 202 # #
utf8_danish_ci utf8 203 # #
utf8_lithuanian_ci utf8 204 # #
utf8_slovak_ci utf8 205 # #
utf8_spanish2_ci utf8 206 # #
utf8_roman_ci utf8 207 # #
utf8_persian_ci utf8 208 # #
utf8_esperanto_ci utf8 209 # #
utf8_hungarian_ci utf8 210 # #
utf8_sinhala_ci utf8 211 # #
utf8_german2_ci utf8 212 # #
utf8_croatian_mysql561_ci utf8 213 # #
utf8_unicode_520_ci utf8 214 # #
utf8_vietnamese_ci utf8 215 # #
utf8_general_mysql500_ci utf8 223 # #
utf8_croatian_ci utf8 576 # #
utf8_myanmar_ci utf8 577 # #
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 # #
cp866_general_ci cp866 36 Yes # #
cp866_bin cp866 68 # #
keybcs2_general_ci keybcs2 37 Yes # #
keybcs2_bin keybcs2 73 # #
macce_general_ci macce 38 Yes # #
macce_bin macce 43 # #
macroman_general_ci macroman 39 Yes # #
macroman_bin macroman 53 # #
cp852_general_ci cp852 40 Yes # #
cp852_bin cp852 81 # #
latin7_estonian_cs latin7 20 # #
latin7_general_ci latin7 41 Yes # #
latin7_general_cs latin7 42 # #
latin7_bin latin7 79 # #
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 # #
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 # #
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 # #
utf16le_general_ci utf16le 56 Yes # #
utf16le_bin utf16le 62 # #
cp1256_general_ci cp1256 57 Yes # #
cp1256_bin cp1256 67 # #
cp1257_lithuanian_ci cp1257 29 # #
cp1257_bin cp1257 58 # #
cp1257_general_ci cp1257 59 Yes # #
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 # #
binary binary 63 Yes # #
geostd8_general_ci geostd8 92 Yes # #
geostd8_bin geostd8 93 # #
cp932_japanese_ci cp932 95 Yes # #
cp932_bin cp932 96 # #
eucjpms_japanese_ci eucjpms 97 Yes # #
eucjpms_bin eucjpms 98 # #
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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_bin NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_bin NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_bin NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_bin NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_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
def d9 ascii ascii_general_ci NULL
def information_schema utf8 utf8_general_ci NULL
def mtr latin1 latin1_swedish_ci NULL
def mysql latin1 latin1_swedish_ci NULL
def performance_schema utf8 utf8_general_ci NULL
def test latin1 latin1_swedish_ci NULL
DROP DATABASE d9;
|
