Debian Codegraph @

mysql-test/suite/engines/funcs/r/db_alter_collate_ascii.result

raw
1 DROP DATABASE IF EXISTS d9;
2 SHOW COLLATION;
3 Collation Charset Id Default Compiled Sortlen Pad_attribute
4 armscii8_bin armscii8 64 # # PAD SPACE
5 armscii8_general_ci armscii8 32 Yes # # PAD SPACE
6 ascii_bin ascii 65 # # PAD SPACE
7 ascii_general_ci ascii 11 Yes # # PAD SPACE
8 big5_bin big5 84 # # PAD SPACE
9 big5_chinese_ci big5 1 Yes # # PAD SPACE
10 binary binary 63 Yes # # NO PAD
11 cp1250_bin cp1250 66 # # PAD SPACE
12 cp1250_croatian_ci cp1250 44 # # PAD SPACE
13 cp1250_czech_cs cp1250 34 # # PAD SPACE
14 cp1250_general_ci cp1250 26 Yes # # PAD SPACE
15 cp1250_polish_ci cp1250 99 # # PAD SPACE
16 cp1251_bin cp1251 50 # # PAD SPACE
17 cp1251_bulgarian_ci cp1251 14 # # PAD SPACE
18 cp1251_general_ci cp1251 51 Yes # # PAD SPACE
19 cp1251_general_cs cp1251 52 # # PAD SPACE
20 cp1251_ukrainian_ci cp1251 23 # # PAD SPACE
21 cp1256_bin cp1256 67 # # PAD SPACE
22 cp1256_general_ci cp1256 57 Yes # # PAD SPACE
23 cp1257_bin cp1257 58 # # PAD SPACE
24 cp1257_general_ci cp1257 59 Yes # # PAD SPACE
25 cp1257_lithuanian_ci cp1257 29 # # PAD SPACE
26 cp850_bin cp850 80 # # PAD SPACE
27 cp850_general_ci cp850 4 Yes # # PAD SPACE
28 cp852_bin cp852 81 # # PAD SPACE
29 cp852_general_ci cp852 40 Yes # # PAD SPACE
30 cp866_bin cp866 68 # # PAD SPACE
31 cp866_general_ci cp866 36 Yes # # PAD SPACE
32 cp932_bin cp932 96 # # PAD SPACE
33 cp932_japanese_ci cp932 95 Yes # # PAD SPACE
34 dec8_bin dec8 69 # # PAD SPACE
35 dec8_swedish_ci dec8 3 Yes # # PAD SPACE
36 eucjpms_bin eucjpms 98 # # PAD SPACE
37 eucjpms_japanese_ci eucjpms 97 Yes # # PAD SPACE
38 euckr_bin euckr 85 # # PAD SPACE
39 euckr_korean_ci euckr 19 Yes # # PAD SPACE
40 gb18030_bin gb18030 249 # # PAD SPACE
41 gb18030_chinese_ci gb18030 248 Yes # # PAD SPACE
42 gb18030_unicode_520_ci gb18030 250 # # PAD SPACE
43 gb2312_bin gb2312 86 # # PAD SPACE
44 gb2312_chinese_ci gb2312 24 Yes # # PAD SPACE
45 gbk_bin gbk 87 # # PAD SPACE
46 gbk_chinese_ci gbk 28 Yes # # PAD SPACE
47 geostd8_bin geostd8 93 # # PAD SPACE
48 geostd8_general_ci geostd8 92 Yes # # PAD SPACE
49 greek_bin greek 70 # # PAD SPACE
50 greek_general_ci greek 25 Yes # # PAD SPACE
51 hebrew_bin hebrew 71 # # PAD SPACE
52 hebrew_general_ci hebrew 16 Yes # # PAD SPACE
53 hp8_bin hp8 72 # # PAD SPACE
54 hp8_english_ci hp8 6 Yes # # PAD SPACE
55 keybcs2_bin keybcs2 73 # # PAD SPACE
56 keybcs2_general_ci keybcs2 37 Yes # # PAD SPACE
57 koi8r_bin koi8r 74 # # PAD SPACE
58 koi8r_general_ci koi8r 7 Yes # # PAD SPACE
59 koi8u_bin koi8u 75 # # PAD SPACE
60 koi8u_general_ci koi8u 22 Yes # # PAD SPACE
61 latin1_bin latin1 47 # # PAD SPACE
62 latin1_danish_ci latin1 15 # # PAD SPACE
63 latin1_general_ci latin1 48 # # PAD SPACE
64 latin1_general_cs latin1 49 # # PAD SPACE
65 latin1_german1_ci latin1 5 # # PAD SPACE
66 latin1_german2_ci latin1 31 # # PAD SPACE
67 latin1_spanish_ci latin1 94 # # PAD SPACE
68 latin1_swedish_ci latin1 8 Yes # # PAD SPACE
69 latin2_bin latin2 77 # # PAD SPACE
70 latin2_croatian_ci latin2 27 # # PAD SPACE
71 latin2_czech_cs latin2 2 # # PAD SPACE
72 latin2_general_ci latin2 9 Yes # # PAD SPACE
73 latin2_hungarian_ci latin2 21 # # PAD SPACE
74 latin5_bin latin5 78 # # PAD SPACE
75 latin5_turkish_ci latin5 30 Yes # # PAD SPACE
76 latin7_bin latin7 79 # # PAD SPACE
77 latin7_estonian_cs latin7 20 # # PAD SPACE
78 latin7_general_ci latin7 41 Yes # # PAD SPACE
79 latin7_general_cs latin7 42 # # PAD SPACE
80 macce_bin macce 43 # # PAD SPACE
81 macce_general_ci macce 38 Yes # # PAD SPACE
82 macroman_bin macroman 53 # # PAD SPACE
83 macroman_general_ci macroman 39 Yes # # PAD SPACE
84 sjis_bin sjis 88 # # PAD SPACE
85 sjis_japanese_ci sjis 13 Yes # # PAD SPACE
86 swe7_bin swe7 82 # # PAD SPACE
87 swe7_swedish_ci swe7 10 Yes # # PAD SPACE
88 tis620_bin tis620 89 # # PAD SPACE
89 tis620_thai_ci tis620 18 Yes # # PAD SPACE
90 ucs2_bin ucs2 90 # # PAD SPACE
91 ucs2_croatian_ci ucs2 149 # # PAD SPACE
92 ucs2_czech_ci ucs2 138 # # PAD SPACE
93 ucs2_danish_ci ucs2 139 # # PAD SPACE
94 ucs2_esperanto_ci ucs2 145 # # PAD SPACE
95 ucs2_estonian_ci ucs2 134 # # PAD SPACE
96 ucs2_general_ci ucs2 35 Yes # # PAD SPACE
97 ucs2_general_mysql500_ci ucs2 159 # # PAD SPACE
98 ucs2_german2_ci ucs2 148 # # PAD SPACE
99 ucs2_hungarian_ci ucs2 146 # # PAD SPACE
100 ucs2_icelandic_ci ucs2 129 # # PAD SPACE
101 ucs2_latvian_ci ucs2 130 # # PAD SPACE
102 ucs2_lithuanian_ci ucs2 140 # # PAD SPACE
103 ucs2_persian_ci ucs2 144 # # PAD SPACE
104 ucs2_polish_ci ucs2 133 # # PAD SPACE
105 ucs2_romanian_ci ucs2 131 # # PAD SPACE
106 ucs2_roman_ci ucs2 143 # # PAD SPACE
107 ucs2_sinhala_ci ucs2 147 # # PAD SPACE
108 ucs2_slovak_ci ucs2 141 # # PAD SPACE
109 ucs2_slovenian_ci ucs2 132 # # PAD SPACE
110 ucs2_spanish2_ci ucs2 142 # # PAD SPACE
111 ucs2_spanish_ci ucs2 135 # # PAD SPACE
112 ucs2_swedish_ci ucs2 136 # # PAD SPACE
113 ucs2_turkish_ci ucs2 137 # # PAD SPACE
114 ucs2_unicode_520_ci ucs2 150 # # PAD SPACE
115 ucs2_unicode_ci ucs2 128 # # PAD SPACE
116 ucs2_vietnamese_ci ucs2 151 # # PAD SPACE
117 ujis_bin ujis 91 # # PAD SPACE
118 ujis_japanese_ci ujis 12 Yes # # PAD SPACE
119 utf16le_bin utf16le 62 # # PAD SPACE
120 utf16le_general_ci utf16le 56 Yes # # PAD SPACE
121 utf16_bin utf16 55 # # PAD SPACE
122 utf16_croatian_ci utf16 122 # # PAD SPACE
123 utf16_czech_ci utf16 111 # # PAD SPACE
124 utf16_danish_ci utf16 112 # # PAD SPACE
125 utf16_esperanto_ci utf16 118 # # PAD SPACE
126 utf16_estonian_ci utf16 107 # # PAD SPACE
127 utf16_general_ci utf16 54 Yes # # PAD SPACE
128 utf16_german2_ci utf16 121 # # PAD SPACE
129 utf16_hungarian_ci utf16 119 # # PAD SPACE
130 utf16_icelandic_ci utf16 102 # # PAD SPACE
131 utf16_latvian_ci utf16 103 # # PAD SPACE
132 utf16_lithuanian_ci utf16 113 # # PAD SPACE
133 utf16_persian_ci utf16 117 # # PAD SPACE
134 utf16_polish_ci utf16 106 # # PAD SPACE
135 utf16_romanian_ci utf16 104 # # PAD SPACE
136 utf16_roman_ci utf16 116 # # PAD SPACE
137 utf16_sinhala_ci utf16 120 # # PAD SPACE
138 utf16_slovak_ci utf16 114 # # PAD SPACE
139 utf16_slovenian_ci utf16 105 # # PAD SPACE
140 utf16_spanish2_ci utf16 115 # # PAD SPACE
141 utf16_spanish_ci utf16 108 # # PAD SPACE
142 utf16_swedish_ci utf16 109 # # PAD SPACE
143 utf16_turkish_ci utf16 110 # # PAD SPACE
144 utf16_unicode_520_ci utf16 123 # # PAD SPACE
145 utf16_unicode_ci utf16 101 # # PAD SPACE
146 utf16_vietnamese_ci utf16 124 # # PAD SPACE
147 utf32_bin utf32 61 # # PAD SPACE
148 utf32_croatian_ci utf32 181 # # PAD SPACE
149 utf32_czech_ci utf32 170 # # PAD SPACE
150 utf32_danish_ci utf32 171 # # PAD SPACE
151 utf32_esperanto_ci utf32 177 # # PAD SPACE
152 utf32_estonian_ci utf32 166 # # PAD SPACE
153 utf32_general_ci utf32 60 Yes # # PAD SPACE
154 utf32_german2_ci utf32 180 # # PAD SPACE
155 utf32_hungarian_ci utf32 178 # # PAD SPACE
156 utf32_icelandic_ci utf32 161 # # PAD SPACE
157 utf32_latvian_ci utf32 162 # # PAD SPACE
158 utf32_lithuanian_ci utf32 172 # # PAD SPACE
159 utf32_persian_ci utf32 176 # # PAD SPACE
160 utf32_polish_ci utf32 165 # # PAD SPACE
161 utf32_romanian_ci utf32 163 # # PAD SPACE
162 utf32_roman_ci utf32 175 # # PAD SPACE
163 utf32_sinhala_ci utf32 179 # # PAD SPACE
164 utf32_slovak_ci utf32 173 # # PAD SPACE
165 utf32_slovenian_ci utf32 164 # # PAD SPACE
166 utf32_spanish2_ci utf32 174 # # PAD SPACE
167 utf32_spanish_ci utf32 167 # # PAD SPACE
168 utf32_swedish_ci utf32 168 # # PAD SPACE
169 utf32_turkish_ci utf32 169 # # PAD SPACE
170 utf32_unicode_520_ci utf32 182 # # PAD SPACE
171 utf32_unicode_ci utf32 160 # # PAD SPACE
172 utf32_vietnamese_ci utf32 183 # # PAD SPACE
173 utf8mb3_bin utf8mb3 83 # # PAD SPACE
174 utf8mb3_croatian_ci utf8mb3 213 # # PAD SPACE
175 utf8mb3_czech_ci utf8mb3 202 # # PAD SPACE
176 utf8mb3_danish_ci utf8mb3 203 # # PAD SPACE
177 utf8mb3_esperanto_ci utf8mb3 209 # # PAD SPACE
178 utf8mb3_estonian_ci utf8mb3 198 # # PAD SPACE
179 utf8mb3_general_ci utf8mb3 33 Yes # # PAD SPACE
180 utf8mb3_general_mysql500_ci utf8mb3 223 # # PAD SPACE
181 utf8mb3_german2_ci utf8mb3 212 # # PAD SPACE
182 utf8mb3_hungarian_ci utf8mb3 210 # # PAD SPACE
183 utf8mb3_icelandic_ci utf8mb3 193 # # PAD SPACE
184 utf8mb3_latvian_ci utf8mb3 194 # # PAD SPACE
185 utf8mb3_lithuanian_ci utf8mb3 204 # # PAD SPACE
186 utf8mb3_persian_ci utf8mb3 208 # # PAD SPACE
187 utf8mb3_polish_ci utf8mb3 197 # # PAD SPACE
188 utf8mb3_romanian_ci utf8mb3 195 # # PAD SPACE
189 utf8mb3_roman_ci utf8mb3 207 # # PAD SPACE
190 utf8mb3_sinhala_ci utf8mb3 211 # # PAD SPACE
191 utf8mb3_slovak_ci utf8mb3 205 # # PAD SPACE
192 utf8mb3_slovenian_ci utf8mb3 196 # # PAD SPACE
193 utf8mb3_spanish2_ci utf8mb3 206 # # PAD SPACE
194 utf8mb3_spanish_ci utf8mb3 199 # # PAD SPACE
195 utf8mb3_swedish_ci utf8mb3 200 # # PAD SPACE
196 utf8mb3_tolower_ci utf8mb3 76 # # PAD SPACE
197 utf8mb3_turkish_ci utf8mb3 201 # # PAD SPACE
198 utf8mb3_unicode_520_ci utf8mb3 214 # # PAD SPACE
199 utf8mb3_unicode_ci utf8mb3 192 # # PAD SPACE
200 utf8mb3_vietnamese_ci utf8mb3 215 # # PAD SPACE
201 utf8mb4_0900_ai_ci utf8mb4 255 Yes # # NO PAD
202 utf8mb4_0900_as_ci utf8mb4 305 # # NO PAD
203 utf8mb4_0900_as_cs utf8mb4 278 # # NO PAD
204 utf8mb4_0900_bin utf8mb4 309 # # NO PAD
205 utf8mb4_bg_0900_ai_ci utf8mb4 318 # # NO PAD
206 utf8mb4_bg_0900_as_cs utf8mb4 319 # # NO PAD
207 utf8mb4_bin utf8mb4 46 # # PAD SPACE
208 utf8mb4_bs_0900_ai_ci utf8mb4 316 # # NO PAD
209 utf8mb4_bs_0900_as_cs utf8mb4 317 # # NO PAD
210 utf8mb4_croatian_ci utf8mb4 245 # # PAD SPACE
211 utf8mb4_cs_0900_ai_ci utf8mb4 266 # # NO PAD
212 utf8mb4_cs_0900_as_cs utf8mb4 289 # # NO PAD
213 utf8mb4_czech_ci utf8mb4 234 # # PAD SPACE
214 utf8mb4_danish_ci utf8mb4 235 # # PAD SPACE
215 utf8mb4_da_0900_ai_ci utf8mb4 267 # # NO PAD
216 utf8mb4_da_0900_as_cs utf8mb4 290 # # NO PAD
217 utf8mb4_de_pb_0900_ai_ci utf8mb4 256 # # NO PAD
218 utf8mb4_de_pb_0900_as_cs utf8mb4 279 # # NO PAD
219 utf8mb4_eo_0900_ai_ci utf8mb4 273 # # NO PAD
220 utf8mb4_eo_0900_as_cs utf8mb4 296 # # NO PAD
221 utf8mb4_esperanto_ci utf8mb4 241 # # PAD SPACE
222 utf8mb4_estonian_ci utf8mb4 230 # # PAD SPACE
223 utf8mb4_es_0900_ai_ci utf8mb4 263 # # NO PAD
224 utf8mb4_es_0900_as_cs utf8mb4 286 # # NO PAD
225 utf8mb4_es_trad_0900_ai_ci utf8mb4 270 # # NO PAD
226 utf8mb4_es_trad_0900_as_cs utf8mb4 293 # # NO PAD
227 utf8mb4_et_0900_ai_ci utf8mb4 262 # # NO PAD
228 utf8mb4_et_0900_as_cs utf8mb4 285 # # NO PAD
229 utf8mb4_general_ci utf8mb4 45 # # PAD SPACE
230 utf8mb4_german2_ci utf8mb4 244 # # PAD SPACE
231 utf8mb4_gl_0900_ai_ci utf8mb4 320 # # NO PAD
232 utf8mb4_gl_0900_as_cs utf8mb4 321 # # NO PAD
233 utf8mb4_hr_0900_ai_ci utf8mb4 275 # # NO PAD
234 utf8mb4_hr_0900_as_cs utf8mb4 298 # # NO PAD
235 utf8mb4_hungarian_ci utf8mb4 242 # # PAD SPACE
236 utf8mb4_hu_0900_ai_ci utf8mb4 274 # # NO PAD
237 utf8mb4_hu_0900_as_cs utf8mb4 297 # # NO PAD
238 utf8mb4_icelandic_ci utf8mb4 225 # # PAD SPACE
239 utf8mb4_is_0900_ai_ci utf8mb4 257 # # NO PAD
240 utf8mb4_is_0900_as_cs utf8mb4 280 # # NO PAD
241 utf8mb4_ja_0900_as_cs utf8mb4 303 # # NO PAD
242 utf8mb4_ja_0900_as_cs_ks utf8mb4 304 # # NO PAD
243 utf8mb4_latvian_ci utf8mb4 226 # # PAD SPACE
244 utf8mb4_la_0900_ai_ci utf8mb4 271 # # NO PAD
245 utf8mb4_la_0900_as_cs utf8mb4 294 # # NO PAD
246 utf8mb4_lithuanian_ci utf8mb4 236 # # PAD SPACE
247 utf8mb4_lt_0900_ai_ci utf8mb4 268 # # NO PAD
248 utf8mb4_lt_0900_as_cs utf8mb4 291 # # NO PAD
249 utf8mb4_lv_0900_ai_ci utf8mb4 258 # # NO PAD
250 utf8mb4_lv_0900_as_cs utf8mb4 281 # # NO PAD
251 utf8mb4_mn_cyrl_0900_ai_ci utf8mb4 322 # # NO PAD
252 utf8mb4_mn_cyrl_0900_as_cs utf8mb4 323 # # NO PAD
253 utf8mb4_nb_0900_ai_ci utf8mb4 310 # # NO PAD
254 utf8mb4_nb_0900_as_cs utf8mb4 311 # # NO PAD
255 utf8mb4_nn_0900_ai_ci utf8mb4 312 # # NO PAD
256 utf8mb4_nn_0900_as_cs utf8mb4 313 # # NO PAD
257 utf8mb4_persian_ci utf8mb4 240 # # PAD SPACE
258 utf8mb4_pl_0900_ai_ci utf8mb4 261 # # NO PAD
259 utf8mb4_pl_0900_as_cs utf8mb4 284 # # NO PAD
260 utf8mb4_polish_ci utf8mb4 229 # # PAD SPACE
261 utf8mb4_romanian_ci utf8mb4 227 # # PAD SPACE
262 utf8mb4_roman_ci utf8mb4 239 # # PAD SPACE
263 utf8mb4_ro_0900_ai_ci utf8mb4 259 # # NO PAD
264 utf8mb4_ro_0900_as_cs utf8mb4 282 # # NO PAD
265 utf8mb4_ru_0900_ai_ci utf8mb4 306 # # NO PAD
266 utf8mb4_ru_0900_as_cs utf8mb4 307 # # NO PAD
267 utf8mb4_sinhala_ci utf8mb4 243 # # PAD SPACE
268 utf8mb4_sk_0900_ai_ci utf8mb4 269 # # NO PAD
269 utf8mb4_sk_0900_as_cs utf8mb4 292 # # NO PAD
270 utf8mb4_slovak_ci utf8mb4 237 # # PAD SPACE
271 utf8mb4_slovenian_ci utf8mb4 228 # # PAD SPACE
272 utf8mb4_sl_0900_ai_ci utf8mb4 260 # # NO PAD
273 utf8mb4_sl_0900_as_cs utf8mb4 283 # # NO PAD
274 utf8mb4_spanish2_ci utf8mb4 238 # # PAD SPACE
275 utf8mb4_spanish_ci utf8mb4 231 # # PAD SPACE
276 utf8mb4_sr_latn_0900_ai_ci utf8mb4 314 # # NO PAD
277 utf8mb4_sr_latn_0900_as_cs utf8mb4 315 # # NO PAD
278 utf8mb4_sv_0900_ai_ci utf8mb4 264 # # NO PAD
279 utf8mb4_sv_0900_as_cs utf8mb4 287 # # NO PAD
280 utf8mb4_swedish_ci utf8mb4 232 # # PAD SPACE
281 utf8mb4_tr_0900_ai_ci utf8mb4 265 # # NO PAD
282 utf8mb4_tr_0900_as_cs utf8mb4 288 # # NO PAD
283 utf8mb4_turkish_ci utf8mb4 233 # # PAD SPACE
284 utf8mb4_unicode_520_ci utf8mb4 246 # # PAD SPACE
285 utf8mb4_unicode_ci utf8mb4 224 # # PAD SPACE
286 utf8mb4_vietnamese_ci utf8mb4 247 # # PAD SPACE
287 utf8mb4_vi_0900_ai_ci utf8mb4 277 # # NO PAD
288 utf8mb4_vi_0900_as_cs utf8mb4 300 # # NO PAD
289 utf8mb4_zh_0900_as_cs utf8mb4 308 # # NO PAD
290 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
291 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
292 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
293 def d9 ascii ascii_general_ci NULL NO
294 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
295 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
296 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
297 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
298 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
299 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
300 ALTER DATABASE d9 COLLATE ascii_bin;
301 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
302 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
303 def d9 ascii ascii_bin NULL NO
304 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
305 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
306 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
307 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
308 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
309 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
310 DROP DATABASE d9;
311 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
312 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
313 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
314 def d9 ascii ascii_general_ci NULL NO
315 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
316 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
317 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
318 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
319 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
320 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
321 ALTER DATABASE d9 DEFAULT COLLATE ascii_bin;
322 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
323 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
324 def d9 ascii ascii_bin NULL NO
325 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
326 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
327 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
328 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
329 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
330 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
331 DROP DATABASE d9;
332 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
333 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
334 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
335 def d9 ascii ascii_general_ci NULL NO
336 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
337 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
338 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
339 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
340 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
341 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
342 ALTER DATABASE d9 COLLATE ascii_general_ci;
343 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
344 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
345 def d9 ascii ascii_general_ci NULL NO
346 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
347 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
348 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
349 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
350 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
351 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
352 DROP DATABASE d9;
353 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
354 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
355 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
356 def d9 ascii ascii_general_ci NULL NO
357 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
358 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
359 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
360 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
361 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
362 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
363 ALTER DATABASE d9 DEFAULT COLLATE ascii_general_ci;
364 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
365 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
366 def d9 ascii ascii_general_ci NULL NO
367 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
368 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
369 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
370 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
371 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
372 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
373 DROP DATABASE d9;
374 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
375 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
376 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
377 def d9 ascii ascii_general_ci NULL NO
378 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
379 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
380 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
381 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
382 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
383 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
384 ALTER SCHEMA d9 COLLATE ascii_bin;
385 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
386 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
387 def d9 ascii ascii_bin NULL NO
388 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
389 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
390 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
391 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
392 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
393 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
394 DROP DATABASE d9;
395 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
396 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
397 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
398 def d9 ascii ascii_general_ci NULL NO
399 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
400 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
401 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
402 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
403 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
404 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
405 ALTER SCHEMA d9 DEFAULT COLLATE ascii_bin;
406 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
407 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
408 def d9 ascii ascii_bin NULL NO
409 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
410 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
411 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
412 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
413 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
414 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
415 DROP DATABASE d9;
416 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
417 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
418 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
419 def d9 ascii ascii_general_ci NULL NO
420 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
421 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
422 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
423 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
424 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
425 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
426 ALTER SCHEMA d9 COLLATE ascii_general_ci;
427 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
428 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
429 def d9 ascii ascii_general_ci NULL NO
430 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
431 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
432 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
433 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
434 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
435 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
436 DROP DATABASE d9;
437 CREATE DATABASE d9 DEFAULT CHARACTER SET ascii;
438 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
439 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
440 def d9 ascii ascii_general_ci NULL NO
441 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
442 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
443 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
444 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
445 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
446 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
447 ALTER SCHEMA d9 DEFAULT COLLATE ascii_general_ci;
448 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
449 CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH DEFAULT_ENCRYPTION
450 def d9 ascii ascii_general_ci NULL NO
451 def information_schema utf8mb3 utf8mb3_general_ci NULL NO
452 def mtr utf8mb4 utf8mb4_0900_ai_ci NULL NO
453 def mysql utf8mb4 utf8mb4_0900_ai_ci NULL NO
454 def performance_schema utf8mb4 utf8mb4_0900_ai_ci NULL NO
455 def sys utf8mb4 utf8mb4_0900_ai_ci NULL NO
456 def test utf8mb4 utf8mb4_0900_ai_ci NULL NO
457 DROP DATABASE d9;