1
DROP USER dbdict_test@localhost;
2
CREATE USER dbdict_test@localhost;
3
# Establish connection con (user=dbdict_test)
6
FROM information_schema.character_sets
7
ORDER BY character_set_name;
8
CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN
9
armscii8 armscii8_general_ci ARMSCII-8 Armenian 1
10
ascii ascii_general_ci US ASCII 1
11
big5 big5_chinese_ci Big5 Traditional Chinese 2
12
binary binary Binary pseudo charset 1
13
cp1250 cp1250_general_ci Windows Central European 1
14
cp1251 cp1251_general_ci Windows Cyrillic 1
15
cp1256 cp1256_general_ci Windows Arabic 1
16
cp1257 cp1257_general_ci Windows Baltic 1
17
cp850 cp850_general_ci DOS West European 1
18
cp852 cp852_general_ci DOS Central European 1
19
cp866 cp866_general_ci DOS Russian 1
20
cp932 cp932_japanese_ci SJIS for Windows Japanese 2
21
dec8 dec8_swedish_ci DEC West European 1
22
eucjpms eucjpms_japanese_ci UJIS for Windows Japanese 3
23
euckr euckr_korean_ci EUC-KR Korean 2
24
gb2312 gb2312_chinese_ci GB2312 Simplified Chinese 2
25
gbk gbk_chinese_ci GBK Simplified Chinese 2
26
geostd8 geostd8_general_ci GEOSTD8 Georgian 1
27
greek greek_general_ci ISO 8859-7 Greek 1
28
hebrew hebrew_general_ci ISO 8859-8 Hebrew 1
29
hp8 hp8_english_ci HP West European 1
30
keybcs2 keybcs2_general_ci DOS Kamenicky Czech-Slovak 1
31
koi8r koi8r_general_ci KOI8-R Relcom Russian 1
32
koi8u koi8u_general_ci KOI8-U Ukrainian 1
33
latin1 latin1_swedish_ci cp1252 West European 1
34
latin2 latin2_general_ci ISO 8859-2 Central European 1
35
latin5 latin5_turkish_ci ISO 8859-9 Turkish 1
36
latin7 latin7_general_ci ISO 8859-13 Baltic 1
37
macce macce_general_ci Mac Central European 1
38
macroman macroman_general_ci Mac West European 1
39
sjis sjis_japanese_ci Shift-JIS Japanese 2
40
swe7 swe7_swedish_ci 7bit Swedish 1
41
tis620 tis620_thai_ci TIS620 Thai 1
42
ucs2 ucs2_general_ci UCS-2 Unicode 2
43
ujis ujis_japanese_ci EUC-JP Japanese 3
44
utf16 utf16_general_ci UTF-16 Unicode 4
45
utf32 utf32_general_ci UTF-32 Unicode 4
46
utf8 utf8_general_ci UTF-8 Unicode 4
47
utf8mb3 utf8mb3_general_ci UTF-8 Unicode 3
50
FROM information_schema.collations
51
ORDER BY collation_name;
52
COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN
53
armscii8_bin armscii8 64 0
54
armscii8_general_ci armscii8 32 Yes 0
56
ascii_general_ci ascii 11 Yes 0
57
big5_bin big5 84 Yes 1
58
big5_chinese_ci big5 1 Yes Yes 1
59
binary binary 63 Yes Yes 1
60
cp1250_bin cp1250 66 Yes 1
61
cp1250_croatian_ci cp1250 44 Yes 1
62
cp1250_czech_cs cp1250 34 Yes 2
63
cp1250_general_ci cp1250 26 Yes Yes 1
64
cp1250_polish_ci cp1250 99 Yes 1
65
cp1251_bin cp1251 50 0
66
cp1251_bulgarian_ci cp1251 14 0
67
cp1251_general_ci cp1251 51 Yes 0
68
cp1251_general_cs cp1251 52 0
69
cp1251_ukrainian_ci cp1251 23 0
70
cp1256_bin cp1256 67 0
71
cp1256_general_ci cp1256 57 Yes 0
72
cp1257_bin cp1257 58 0
73
cp1257_general_ci cp1257 59 Yes 0
74
cp1257_lithuanian_ci cp1257 29 0
76
cp850_general_ci cp850 4 Yes 0
78
cp852_general_ci cp852 40 Yes 0
80
cp866_general_ci cp866 36 Yes 0
81
cp932_bin cp932 96 Yes 1
82
cp932_japanese_ci cp932 95 Yes Yes 1
84
dec8_swedish_ci dec8 3 Yes 0
85
eucjpms_bin eucjpms 98 Yes 1
86
eucjpms_japanese_ci eucjpms 97 Yes Yes 1
87
euckr_bin euckr 85 Yes 1
88
euckr_korean_ci euckr 19 Yes Yes 1
89
gb2312_bin gb2312 86 Yes 1
90
gb2312_chinese_ci gb2312 24 Yes Yes 1
92
gbk_chinese_ci gbk 28 Yes Yes 1
93
geostd8_bin geostd8 93 0
94
geostd8_general_ci geostd8 92 Yes 0
96
greek_general_ci greek 25 Yes 0
97
hebrew_bin hebrew 71 0
98
hebrew_general_ci hebrew 16 Yes 0
100
hp8_english_ci hp8 6 Yes 0
101
keybcs2_bin keybcs2 73 0
102
keybcs2_general_ci keybcs2 37 Yes 0
104
koi8r_general_ci koi8r 7 Yes 0
106
koi8u_general_ci koi8u 22 Yes 0
107
latin1_bin latin1 47 Yes 1
108
latin1_danish_ci latin1 15 Yes 1
109
latin1_general_ci latin1 48 Yes 1
110
latin1_general_cs latin1 49 Yes 1
111
latin1_german1_ci latin1 5 Yes 1
112
latin1_german2_ci latin1 31 Yes 2
113
latin1_spanish_ci latin1 94 Yes 1
114
latin1_swedish_ci latin1 8 Yes Yes 1
115
latin2_bin latin2 77 Yes 1
116
latin2_croatian_ci latin2 27 Yes 1
117
latin2_czech_cs latin2 2 Yes 4
118
latin2_general_ci latin2 9 Yes Yes 1
119
latin2_hungarian_ci latin2 21 Yes 1
120
latin5_bin latin5 78 0
121
latin5_turkish_ci latin5 30 Yes 0
122
latin7_bin latin7 79 0
123
latin7_estonian_cs latin7 20 0
124
latin7_general_ci latin7 41 Yes 0
125
latin7_general_cs latin7 42 0
127
macce_general_ci macce 38 Yes 0
128
macroman_bin macroman 53 0
129
macroman_general_ci macroman 39 Yes 0
130
sjis_bin sjis 88 Yes 1
131
sjis_japanese_ci sjis 13 Yes Yes 1
133
swe7_swedish_ci swe7 10 Yes 0
134
tis620_bin tis620 89 Yes 1
135
tis620_thai_ci tis620 18 Yes Yes 4
136
ucs2_bin ucs2 90 Yes 1
137
ucs2_czech_ci ucs2 138 Yes 8
138
ucs2_danish_ci ucs2 139 Yes 8
139
ucs2_esperanto_ci ucs2 145 Yes 8
140
ucs2_estonian_ci ucs2 134 Yes 8
141
ucs2_general_ci ucs2 35 Yes Yes 1
142
ucs2_hungarian_ci ucs2 146 Yes 8
143
ucs2_icelandic_ci ucs2 129 Yes 8
144
ucs2_latvian_ci ucs2 130 Yes 8
145
ucs2_lithuanian_ci ucs2 140 Yes 8
146
ucs2_persian_ci ucs2 144 Yes 8
147
ucs2_polish_ci ucs2 133 Yes 8
148
ucs2_romanian_ci ucs2 131 Yes 8
149
ucs2_roman_ci ucs2 143 Yes 8
150
ucs2_sinhala_ci ucs2 147 Yes 8
151
ucs2_slovak_ci ucs2 141 Yes 8
152
ucs2_slovenian_ci ucs2 132 Yes 8
153
ucs2_spanish2_ci ucs2 142 Yes 8
154
ucs2_spanish_ci ucs2 135 Yes 8
155
ucs2_swedish_ci ucs2 136 Yes 8
156
ucs2_turkish_ci ucs2 137 Yes 8
157
ucs2_unicode_ci ucs2 128 Yes 8
158
ujis_bin ujis 91 Yes 1
159
ujis_japanese_ci ujis 12 Yes Yes 1
160
utf16_bin utf16 55 Yes 1
161
utf16_czech_ci utf16 111 Yes 8
162
utf16_danish_ci utf16 112 Yes 8
163
utf16_esperanto_ci utf16 118 Yes 8
164
utf16_estonian_ci utf16 107 Yes 8
165
utf16_general_ci utf16 54 Yes Yes 1
166
utf16_hungarian_ci utf16 119 Yes 8
167
utf16_icelandic_ci utf16 102 Yes 8
168
utf16_latvian_ci utf16 103 Yes 8
169
utf16_lithuanian_ci utf16 113 Yes 8
170
utf16_persian_ci utf16 117 Yes 8
171
utf16_polish_ci utf16 106 Yes 8
172
utf16_romanian_ci utf16 104 Yes 8
173
utf16_roman_ci utf16 116 Yes 8
174
utf16_sinhala_ci utf16 120 Yes 8
175
utf16_slovak_ci utf16 114 Yes 8
176
utf16_slovenian_ci utf16 105 Yes 8
177
utf16_spanish2_ci utf16 115 Yes 8
178
utf16_spanish_ci utf16 108 Yes 8
179
utf16_swedish_ci utf16 109 Yes 8
180
utf16_turkish_ci utf16 110 Yes 8
181
utf16_unicode_ci utf16 101 Yes 8
182
utf32_bin utf32 61 Yes 1
183
utf32_czech_ci utf32 170 Yes 8
184
utf32_danish_ci utf32 171 Yes 8
185
utf32_esperanto_ci utf32 177 Yes 8
186
utf32_estonian_ci utf32 166 Yes 8
187
utf32_general_ci utf32 60 Yes Yes 1
188
utf32_hungarian_ci utf32 178 Yes 8
189
utf32_icelandic_ci utf32 161 Yes 8
190
utf32_latvian_ci utf32 162 Yes 8
191
utf32_lithuanian_ci utf32 172 Yes 8
192
utf32_persian_ci utf32 176 Yes 8
193
utf32_polish_ci utf32 165 Yes 8
194
utf32_romanian_ci utf32 163 Yes 8
195
utf32_roman_ci utf32 175 Yes 8
196
utf32_sinhala_ci utf32 179 Yes 8
197
utf32_slovak_ci utf32 173 Yes 8
198
utf32_slovenian_ci utf32 164 Yes 8
199
utf32_spanish2_ci utf32 174 Yes 8
200
utf32_spanish_ci utf32 167 Yes 8
201
utf32_swedish_ci utf32 168 Yes 8
202
utf32_turkish_ci utf32 169 Yes 8
203
utf32_unicode_ci utf32 160 Yes 8
204
utf8mb3_bin utf8mb3 83 Yes 1
205
utf8mb3_czech_ci utf8mb3 202 Yes 8
206
utf8mb3_danish_ci utf8mb3 203 Yes 8
207
utf8mb3_esperanto_ci utf8mb3 209 Yes 8
208
utf8mb3_estonian_ci utf8mb3 198 Yes 8
209
utf8mb3_general_ci utf8mb3 33 Yes Yes 1
210
utf8mb3_hungarian_ci utf8mb3 210 Yes 8
211
utf8mb3_icelandic_ci utf8mb3 193 Yes 8
212
utf8mb3_latvian_ci utf8mb3 194 Yes 8
213
utf8mb3_lithuanian_ci utf8mb3 204 Yes 8
214
utf8mb3_persian_ci utf8mb3 208 Yes 8
215
utf8mb3_polish_ci utf8mb3 197 Yes 8
216
utf8mb3_romanian_ci utf8mb3 195 Yes 8
217
utf8mb3_roman_ci utf8mb3 207 Yes 8
218
utf8mb3_sinhala_ci utf8mb3 211 Yes 8
219
utf8mb3_slovak_ci utf8mb3 205 Yes 8
220
utf8mb3_slovenian_ci utf8mb3 196 Yes 8
221
utf8mb3_spanish2_ci utf8mb3 206 Yes 8
222
utf8mb3_spanish_ci utf8mb3 199 Yes 8
223
utf8mb3_swedish_ci utf8mb3 200 Yes 8
224
utf8mb3_turkish_ci utf8mb3 201 Yes 8
225
utf8mb3_unicode_ci utf8mb3 192 Yes 8
226
utf8_bin utf8 46 Yes 1
227
utf8_czech_ci utf8 234 Yes 8
228
utf8_danish_ci utf8 235 Yes 8
229
utf8_esperanto_ci utf8 241 Yes 8
230
utf8_estonian_ci utf8 230 Yes 8
231
utf8_general_ci utf8 45 Yes Yes 1
232
utf8_hungarian_ci utf8 242 Yes 8
233
utf8_icelandic_ci utf8 225 Yes 8
234
utf8_latvian_ci utf8 226 Yes 8
235
utf8_lithuanian_ci utf8 236 Yes 8
236
utf8_persian_ci utf8 240 Yes 8
237
utf8_polish_ci utf8 229 Yes 8
238
utf8_romanian_ci utf8 227 Yes 8
239
utf8_roman_ci utf8 239 Yes 8
240
utf8_sinhala_ci utf8 243 Yes 8
241
utf8_slovak_ci utf8 237 Yes 8
242
utf8_slovenian_ci utf8 228 Yes 8
243
utf8_spanish2_ci utf8 238 Yes 8
244
utf8_spanish_ci utf8 231 Yes 8
245
utf8_swedish_ci utf8 232 Yes 8
246
utf8_turkish_ci utf8 233 Yes 8
247
utf8_unicode_ci utf8 224 Yes 8
251
FROM information_schema.collation_character_set_applicability
252
ORDER BY collation_name, character_set_name;
253
COLLATION_NAME CHARACTER_SET_NAME
254
armscii8_bin armscii8
255
armscii8_general_ci armscii8
257
ascii_general_ci ascii
262
cp1250_croatian_ci cp1250
263
cp1250_czech_cs cp1250
264
cp1250_general_ci cp1250
265
cp1250_polish_ci cp1250
267
cp1251_bulgarian_ci cp1251
268
cp1251_general_ci cp1251
269
cp1251_general_cs cp1251
270
cp1251_ukrainian_ci cp1251
272
cp1256_general_ci cp1256
274
cp1257_general_ci cp1257
275
cp1257_lithuanian_ci cp1257
277
cp850_general_ci cp850
279
cp852_general_ci cp852
281
cp866_general_ci cp866
283
cp932_japanese_ci cp932
287
eucjpms_japanese_ci eucjpms
289
euckr_korean_ci euckr
292
gb2312_chinese_ci gb2312
296
geostd8_general_ci geostd8
298
greek_general_ci greek
300
hebrew_general_ci hebrew
304
keybcs2_general_ci keybcs2
306
koi8r_general_ci koi8r
308
koi8u_general_ci koi8u
310
latin1_danish_ci latin1
311
latin1_general_ci latin1
312
latin1_general_cs latin1
313
latin1_german1_ci latin1
314
latin1_german2_ci latin1
315
latin1_spanish_ci latin1
316
latin1_swedish_ci latin1
318
latin2_croatian_ci latin2
319
latin2_czech_cs latin2
320
latin2_general_ci latin2
321
latin2_hungarian_ci latin2
323
latin5_turkish_ci latin5
325
latin7_estonian_cs latin7
326
latin7_general_ci latin7
327
latin7_general_cs latin7
329
macce_general_ci macce
330
macroman_bin macroman
331
macroman_general_ci macroman
333
sjis_japanese_ci sjis
337
tis620_thai_ci tis620
341
ucs2_esperanto_ci ucs2
342
ucs2_estonian_ci ucs2
344
ucs2_hungarian_ci ucs2
345
ucs2_icelandic_ci ucs2
347
ucs2_lithuanian_ci ucs2
350
ucs2_romanian_ci ucs2
354
ucs2_slovenian_ci ucs2
355
ucs2_spanish2_ci ucs2
361
ujis_japanese_ci ujis
364
utf16_danish_ci utf16
365
utf16_esperanto_ci utf16
366
utf16_estonian_ci utf16
367
utf16_general_ci utf16
368
utf16_hungarian_ci utf16
369
utf16_icelandic_ci utf16
370
utf16_latvian_ci utf16
371
utf16_lithuanian_ci utf16
372
utf16_persian_ci utf16
373
utf16_polish_ci utf16
374
utf16_romanian_ci utf16
376
utf16_sinhala_ci utf16
377
utf16_slovak_ci utf16
378
utf16_slovenian_ci utf16
379
utf16_spanish2_ci utf16
380
utf16_spanish_ci utf16
381
utf16_swedish_ci utf16
382
utf16_turkish_ci utf16
383
utf16_unicode_ci utf16
386
utf32_danish_ci utf32
387
utf32_esperanto_ci utf32
388
utf32_estonian_ci utf32
389
utf32_general_ci utf32
390
utf32_hungarian_ci utf32
391
utf32_icelandic_ci utf32
392
utf32_latvian_ci utf32
393
utf32_lithuanian_ci utf32
394
utf32_persian_ci utf32
395
utf32_polish_ci utf32
396
utf32_romanian_ci utf32
398
utf32_sinhala_ci utf32
399
utf32_slovak_ci utf32
400
utf32_slovenian_ci utf32
401
utf32_spanish2_ci utf32
402
utf32_spanish_ci utf32
403
utf32_swedish_ci utf32
404
utf32_turkish_ci utf32
405
utf32_unicode_ci utf32
407
utf8mb3_czech_ci utf8mb3
408
utf8mb3_danish_ci utf8mb3
409
utf8mb3_esperanto_ci utf8mb3
410
utf8mb3_estonian_ci utf8mb3
411
utf8mb3_general_ci utf8mb3
412
utf8mb3_hungarian_ci utf8mb3
413
utf8mb3_icelandic_ci utf8mb3
414
utf8mb3_latvian_ci utf8mb3
415
utf8mb3_lithuanian_ci utf8mb3
416
utf8mb3_persian_ci utf8mb3
417
utf8mb3_polish_ci utf8mb3
418
utf8mb3_romanian_ci utf8mb3
419
utf8mb3_roman_ci utf8mb3
420
utf8mb3_sinhala_ci utf8mb3
421
utf8mb3_slovak_ci utf8mb3
422
utf8mb3_slovenian_ci utf8mb3
423
utf8mb3_spanish2_ci utf8mb3
424
utf8mb3_spanish_ci utf8mb3
425
utf8mb3_swedish_ci utf8mb3
426
utf8mb3_turkish_ci utf8mb3
427
utf8mb3_unicode_ci utf8mb3
431
utf8_esperanto_ci utf8
432
utf8_estonian_ci utf8
434
utf8_hungarian_ci utf8
435
utf8_icelandic_ci utf8
437
utf8_lithuanian_ci utf8
440
utf8_romanian_ci utf8
444
utf8_slovenian_ci utf8
445
utf8_spanish2_ci utf8
450
# Switch to connection default + disconnect con
451
DROP USER dbdict_test@localhost;