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
|
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 # #
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 # #
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 # #
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 # #
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 # #
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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_bin NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_bin NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_bin NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_bin NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL 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
NULL d9 ascii ascii_general_ci NULL
NULL information_schema utf8 utf8_general_ci NULL
NULL mtr latin1 latin1_swedish_ci NULL
NULL mysql latin1 latin1_swedish_ci NULL
NULL test latin1 latin1_swedish_ci NULL
DROP DATABASE d9;
|