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
utf8 utf8_general_ci UTF-8 Unicode 3
47
FROM information_schema.collations
48
ORDER BY collation_name;
49
COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN
50
armscii8_bin armscii8 64 Yes 1
51
armscii8_general_ci armscii8 32 Yes Yes 1
52
ascii_bin ascii 65 Yes 1
53
ascii_general_ci ascii 11 Yes Yes 1
54
big5_bin big5 84 Yes 1
55
big5_chinese_ci big5 1 Yes Yes 1
56
binary binary 63 Yes Yes 1
57
cp1250_bin cp1250 66 Yes 1
58
cp1250_croatian_ci cp1250 44 Yes 1
59
cp1250_czech_cs cp1250 34 Yes 2
60
cp1250_general_ci cp1250 26 Yes Yes 1
61
cp1251_bin cp1251 50 Yes 1
62
cp1251_bulgarian_ci cp1251 14 Yes 1
63
cp1251_general_ci cp1251 51 Yes Yes 1
64
cp1251_general_cs cp1251 52 Yes 1
65
cp1251_ukrainian_ci cp1251 23 Yes 1
66
cp1256_bin cp1256 67 Yes 1
67
cp1256_general_ci cp1256 57 Yes Yes 1
68
cp1257_bin cp1257 58 Yes 1
69
cp1257_general_ci cp1257 59 Yes Yes 1
70
cp1257_lithuanian_ci cp1257 29 Yes 1
71
cp850_bin cp850 80 Yes 1
72
cp850_general_ci cp850 4 Yes Yes 1
73
cp852_bin cp852 81 Yes 1
74
cp852_general_ci cp852 40 Yes Yes 1
75
cp866_bin cp866 68 Yes 1
76
cp866_general_ci cp866 36 Yes Yes 1
77
cp932_bin cp932 96 Yes 1
78
cp932_japanese_ci cp932 95 Yes Yes 1
79
dec8_bin dec8 69 Yes 1
80
dec8_swedish_ci dec8 3 Yes Yes 1
81
eucjpms_bin eucjpms 98 Yes 1
82
eucjpms_japanese_ci eucjpms 97 Yes Yes 1
83
euckr_bin euckr 85 Yes 1
84
euckr_korean_ci euckr 19 Yes Yes 1
85
gb2312_bin gb2312 86 Yes 1
86
gb2312_chinese_ci gb2312 24 Yes Yes 1
88
gbk_chinese_ci gbk 28 Yes Yes 1
89
geostd8_bin geostd8 93 Yes 1
90
geostd8_general_ci geostd8 92 Yes Yes 1
91
greek_bin greek 70 Yes 1
92
greek_general_ci greek 25 Yes Yes 1
93
hebrew_bin hebrew 71 Yes 1
94
hebrew_general_ci hebrew 16 Yes Yes 1
96
hp8_english_ci hp8 6 Yes Yes 1
97
keybcs2_bin keybcs2 73 Yes 1
98
keybcs2_general_ci keybcs2 37 Yes Yes 1
99
koi8r_bin koi8r 74 Yes 1
100
koi8r_general_ci koi8r 7 Yes Yes 1
101
koi8u_bin koi8u 75 Yes 1
102
koi8u_general_ci koi8u 22 Yes Yes 1
103
latin1_bin latin1 47 Yes 1
104
latin1_danish_ci latin1 15 Yes 1
105
latin1_general_ci latin1 48 Yes 1
106
latin1_general_cs latin1 49 Yes 1
107
latin1_german1_ci latin1 5 Yes 1
108
latin1_german2_ci latin1 31 Yes 2
109
latin1_spanish_ci latin1 94 Yes 1
110
latin1_swedish_ci latin1 8 Yes Yes 1
111
latin2_bin latin2 77 Yes 1
112
latin2_croatian_ci latin2 27 Yes 1
113
latin2_czech_cs latin2 2 Yes 4
114
latin2_general_ci latin2 9 Yes Yes 1
115
latin2_hungarian_ci latin2 21 Yes 1
116
latin5_bin latin5 78 Yes 1
117
latin5_turkish_ci latin5 30 Yes Yes 1
118
latin7_bin latin7 79 Yes 1
119
latin7_estonian_cs latin7 20 Yes 1
120
latin7_general_ci latin7 41 Yes Yes 1
121
latin7_general_cs latin7 42 Yes 1
122
macce_bin macce 43 Yes 1
123
macce_general_ci macce 38 Yes Yes 1
124
macroman_bin macroman 53 Yes 1
125
macroman_general_ci macroman 39 Yes Yes 1
126
sjis_bin sjis 88 Yes 1
127
sjis_japanese_ci sjis 13 Yes Yes 1
128
swe7_bin swe7 82 Yes 1
129
swe7_swedish_ci swe7 10 Yes Yes 1
130
tis620_bin tis620 89 Yes 1
131
tis620_thai_ci tis620 18 Yes Yes 4
132
ucs2_bin ucs2 90 Yes 1
133
ucs2_czech_ci ucs2 138 Yes 8
134
ucs2_danish_ci ucs2 139 Yes 8
135
ucs2_esperanto_ci ucs2 145 Yes 8
136
ucs2_estonian_ci ucs2 134 Yes 8
137
ucs2_general_ci ucs2 35 Yes Yes 1
138
ucs2_hungarian_ci ucs2 146 Yes 8
139
ucs2_icelandic_ci ucs2 129 Yes 8
140
ucs2_latvian_ci ucs2 130 Yes 8
141
ucs2_lithuanian_ci ucs2 140 Yes 8
142
ucs2_persian_ci ucs2 144 Yes 8
143
ucs2_polish_ci ucs2 133 Yes 8
144
ucs2_romanian_ci ucs2 131 Yes 8
145
ucs2_roman_ci ucs2 143 Yes 8
146
ucs2_slovak_ci ucs2 141 Yes 8
147
ucs2_slovenian_ci ucs2 132 Yes 8
148
ucs2_spanish2_ci ucs2 142 Yes 8
149
ucs2_spanish_ci ucs2 135 Yes 8
150
ucs2_swedish_ci ucs2 136 Yes 8
151
ucs2_turkish_ci ucs2 137 Yes 8
152
ucs2_unicode_ci ucs2 128 Yes 8
153
ujis_bin ujis 91 Yes 1
154
ujis_japanese_ci ujis 12 Yes Yes 1
155
utf8_bin utf8 83 Yes 1
156
utf8_czech_ci utf8 202 Yes 8
157
utf8_danish_ci utf8 203 Yes 8
158
utf8_esperanto_ci utf8 209 Yes 8
159
utf8_estonian_ci utf8 198 Yes 8
160
utf8_general_ci utf8 33 Yes Yes 1
161
utf8_hungarian_ci utf8 210 Yes 8
162
utf8_icelandic_ci utf8 193 Yes 8
163
utf8_latvian_ci utf8 194 Yes 8
164
utf8_lithuanian_ci utf8 204 Yes 8
165
utf8_persian_ci utf8 208 Yes 8
166
utf8_polish_ci utf8 197 Yes 8
167
utf8_romanian_ci utf8 195 Yes 8
168
utf8_roman_ci utf8 207 Yes 8
169
utf8_slovak_ci utf8 205 Yes 8
170
utf8_slovenian_ci utf8 196 Yes 8
171
utf8_spanish2_ci utf8 206 Yes 8
172
utf8_spanish_ci utf8 199 Yes 8
173
utf8_swedish_ci utf8 200 Yes 8
174
utf8_turkish_ci utf8 201 Yes 8
175
utf8_unicode_ci utf8 192 Yes 8
179
FROM information_schema.collation_character_set_applicability
180
ORDER BY collation_name, character_set_name;
181
COLLATION_NAME CHARACTER_SET_NAME
182
armscii8_bin armscii8
183
armscii8_general_ci armscii8
185
ascii_general_ci ascii
190
cp1250_croatian_ci cp1250
191
cp1250_czech_cs cp1250
192
cp1250_general_ci cp1250
194
cp1251_bulgarian_ci cp1251
195
cp1251_general_ci cp1251
196
cp1251_general_cs cp1251
197
cp1251_ukrainian_ci cp1251
199
cp1256_general_ci cp1256
201
cp1257_general_ci cp1257
202
cp1257_lithuanian_ci cp1257
204
cp850_general_ci cp850
206
cp852_general_ci cp852
208
cp866_general_ci cp866
210
cp932_japanese_ci cp932
214
eucjpms_japanese_ci eucjpms
216
euckr_korean_ci euckr
218
gb2312_chinese_ci gb2312
222
geostd8_general_ci geostd8
224
greek_general_ci greek
226
hebrew_general_ci hebrew
230
keybcs2_general_ci keybcs2
232
koi8r_general_ci koi8r
234
koi8u_general_ci koi8u
236
latin1_danish_ci latin1
237
latin1_general_ci latin1
238
latin1_general_cs latin1
239
latin1_german1_ci latin1
240
latin1_german2_ci latin1
241
latin1_spanish_ci latin1
242
latin1_swedish_ci latin1
244
latin2_croatian_ci latin2
245
latin2_czech_cs latin2
246
latin2_general_ci latin2
247
latin2_hungarian_ci latin2
249
latin5_turkish_ci latin5
251
latin7_estonian_cs latin7
252
latin7_general_ci latin7
253
latin7_general_cs latin7
255
macce_general_ci macce
256
macroman_bin macroman
257
macroman_general_ci macroman
259
sjis_japanese_ci sjis
263
tis620_thai_ci tis620
267
ucs2_esperanto_ci ucs2
268
ucs2_estonian_ci ucs2
270
ucs2_hungarian_ci ucs2
271
ucs2_icelandic_ci ucs2
273
ucs2_lithuanian_ci ucs2
276
ucs2_romanian_ci ucs2
279
ucs2_slovenian_ci ucs2
280
ucs2_spanish2_ci ucs2
286
ujis_japanese_ci ujis
290
utf8_esperanto_ci utf8
291
utf8_estonian_ci utf8
293
utf8_hungarian_ci utf8
294
utf8_icelandic_ci utf8
296
utf8_lithuanian_ci utf8
299
utf8_romanian_ci utf8
302
utf8_slovenian_ci utf8
303
utf8_spanish2_ci utf8
308
# Switch to connection default + disconnect con
309
DROP USER dbdict_test@localhost;