Debian Codegraph @

mysql-test/suite/engines/funcs/t/db_alter_collate_utf8.test

raw
1 --disable_warnings
2 DROP DATABASE IF EXISTS d10;
3 --enable_warnings
4 --replace_column 5 # 6 #
5 SHOW COLLATION;
6 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
7 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
8 ALTER DATABASE d10 COLLATE utf8_general_ci;
9 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
10 DROP DATABASE d10;
11 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
12 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
13 ALTER DATABASE d10 DEFAULT COLLATE utf8_general_ci;
14 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
15 DROP DATABASE d10;
16 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
17 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
18 ALTER DATABASE d10 COLLATE utf8_bin;
19 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
20 DROP DATABASE d10;
21 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
22 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
23 ALTER DATABASE d10 DEFAULT COLLATE utf8_bin;
24 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
25 DROP DATABASE d10;
26 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
27 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
28 ALTER DATABASE d10 COLLATE utf8_unicode_ci;
29 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
30 DROP DATABASE d10;
31 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
32 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
33 ALTER DATABASE d10 DEFAULT COLLATE utf8_unicode_ci;
34 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
35 DROP DATABASE d10;
36 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
37 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
38 ALTER DATABASE d10 COLLATE utf8_icelandic_ci;
39 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
40 DROP DATABASE d10;
41 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
42 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
43 ALTER DATABASE d10 DEFAULT COLLATE utf8_icelandic_ci;
44 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
45 DROP DATABASE d10;
46 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
47 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
48 ALTER DATABASE d10 COLLATE utf8_latvian_ci;
49 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
50 DROP DATABASE d10;
51 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
52 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
53 ALTER DATABASE d10 DEFAULT COLLATE utf8_latvian_ci;
54 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
55 DROP DATABASE d10;
56 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
57 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
58 ALTER DATABASE d10 COLLATE utf8_romanian_ci;
59 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
60 DROP DATABASE d10;
61 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
62 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
63 ALTER DATABASE d10 DEFAULT COLLATE utf8_romanian_ci;
64 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
65 DROP DATABASE d10;
66 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
67 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
68 ALTER DATABASE d10 COLLATE utf8_slovenian_ci;
69 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
70 DROP DATABASE d10;
71 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
72 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
73 ALTER DATABASE d10 DEFAULT COLLATE utf8_slovenian_ci;
74 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
75 DROP DATABASE d10;
76 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
77 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
78 ALTER DATABASE d10 COLLATE utf8_polish_ci;
79 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
80 DROP DATABASE d10;
81 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
82 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
83 ALTER DATABASE d10 DEFAULT COLLATE utf8_polish_ci;
84 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
85 DROP DATABASE d10;
86 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
87 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
88 ALTER DATABASE d10 COLLATE utf8_estonian_ci;
89 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
90 DROP DATABASE d10;
91 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
92 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
93 ALTER DATABASE d10 DEFAULT COLLATE utf8_estonian_ci;
94 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
95 DROP DATABASE d10;
96 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
97 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
98 ALTER DATABASE d10 COLLATE utf8_spanish_ci;
99 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
100 DROP DATABASE d10;
101 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
102 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
103 ALTER DATABASE d10 DEFAULT COLLATE utf8_spanish_ci;
104 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
105 DROP DATABASE d10;
106 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
107 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
108 ALTER DATABASE d10 COLLATE utf8_swedish_ci;
109 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
110 DROP DATABASE d10;
111 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
112 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
113 ALTER DATABASE d10 DEFAULT COLLATE utf8_swedish_ci;
114 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
115 DROP DATABASE d10;
116 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
117 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
118 ALTER DATABASE d10 COLLATE utf8_turkish_ci;
119 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
120 DROP DATABASE d10;
121 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
122 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
123 ALTER DATABASE d10 DEFAULT COLLATE utf8_turkish_ci;
124 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
125 DROP DATABASE d10;
126 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
127 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
128 ALTER DATABASE d10 COLLATE utf8_czech_ci;
129 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
130 DROP DATABASE d10;
131 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
132 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
133 ALTER DATABASE d10 DEFAULT COLLATE utf8_czech_ci;
134 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
135 DROP DATABASE d10;
136 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
137 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
138 ALTER DATABASE d10 COLLATE utf8_danish_ci;
139 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
140 DROP DATABASE d10;
141 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
142 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
143 ALTER DATABASE d10 DEFAULT COLLATE utf8_danish_ci;
144 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
145 DROP DATABASE d10;
146 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
147 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
148 ALTER DATABASE d10 COLLATE utf8_lithuanian_ci;
149 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
150 DROP DATABASE d10;
151 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
152 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
153 ALTER DATABASE d10 DEFAULT COLLATE utf8_lithuanian_ci;
154 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
155 DROP DATABASE d10;
156 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
157 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
158 ALTER DATABASE d10 COLLATE utf8_slovak_ci;
159 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
160 DROP DATABASE d10;
161 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
162 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
163 ALTER DATABASE d10 DEFAULT COLLATE utf8_slovak_ci;
164 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
165 DROP DATABASE d10;
166 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
167 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
168 ALTER DATABASE d10 COLLATE utf8_spanish2_ci;
169 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
170 DROP DATABASE d10;
171 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
172 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
173 ALTER DATABASE d10 DEFAULT COLLATE utf8_spanish2_ci;
174 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
175 DROP DATABASE d10;
176 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
177 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
178 ALTER DATABASE d10 COLLATE utf8_roman_ci;
179 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
180 DROP DATABASE d10;
181 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
182 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
183 ALTER DATABASE d10 DEFAULT COLLATE utf8_roman_ci;
184 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
185 DROP DATABASE d10;
186 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
187 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
188 ALTER DATABASE d10 COLLATE utf8_persian_ci;
189 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
190 DROP DATABASE d10;
191 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
192 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
193 ALTER DATABASE d10 DEFAULT COLLATE utf8_persian_ci;
194 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
195 DROP DATABASE d10;
196 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
197 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
198 ALTER DATABASE d10 COLLATE utf8_esperanto_ci;
199 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
200 DROP DATABASE d10;
201 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
202 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
203 ALTER DATABASE d10 DEFAULT COLLATE utf8_esperanto_ci;
204 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
205 DROP DATABASE d10;
206 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
207 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
208 ALTER DATABASE d10 COLLATE utf8_hungarian_ci;
209 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
210 DROP DATABASE d10;
211 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
212 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
213 ALTER DATABASE d10 DEFAULT COLLATE utf8_hungarian_ci;
214 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
215 DROP DATABASE d10;
216 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
217 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
218 ALTER SCHEMA d10 COLLATE utf8_general_ci;
219 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
220 DROP DATABASE d10;
221 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
222 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
223 ALTER SCHEMA d10 DEFAULT COLLATE utf8_general_ci;
224 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
225 DROP DATABASE d10;
226 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
227 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
228 ALTER SCHEMA d10 COLLATE utf8_bin;
229 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
230 DROP DATABASE d10;
231 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
232 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
233 ALTER SCHEMA d10 DEFAULT COLLATE utf8_bin;
234 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
235 DROP DATABASE d10;
236 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
237 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
238 ALTER SCHEMA d10 COLLATE utf8_unicode_ci;
239 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
240 DROP DATABASE d10;
241 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
242 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
243 ALTER SCHEMA d10 DEFAULT COLLATE utf8_unicode_ci;
244 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
245 DROP DATABASE d10;
246 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
247 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
248 ALTER SCHEMA d10 COLLATE utf8_icelandic_ci;
249 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
250 DROP DATABASE d10;
251 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
252 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
253 ALTER SCHEMA d10 DEFAULT COLLATE utf8_icelandic_ci;
254 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
255 DROP DATABASE d10;
256 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
257 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
258 ALTER SCHEMA d10 COLLATE utf8_latvian_ci;
259 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
260 DROP DATABASE d10;
261 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
262 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
263 ALTER SCHEMA d10 DEFAULT COLLATE utf8_latvian_ci;
264 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
265 DROP DATABASE d10;
266 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
267 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
268 ALTER SCHEMA d10 COLLATE utf8_romanian_ci;
269 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
270 DROP DATABASE d10;
271 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
272 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
273 ALTER SCHEMA d10 DEFAULT COLLATE utf8_romanian_ci;
274 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
275 DROP DATABASE d10;
276 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
277 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
278 ALTER SCHEMA d10 COLLATE utf8_slovenian_ci;
279 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
280 DROP DATABASE d10;
281 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
282 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
283 ALTER SCHEMA d10 DEFAULT COLLATE utf8_slovenian_ci;
284 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
285 DROP DATABASE d10;
286 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
287 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
288 ALTER SCHEMA d10 COLLATE utf8_polish_ci;
289 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
290 DROP DATABASE d10;
291 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
292 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
293 ALTER SCHEMA d10 DEFAULT COLLATE utf8_polish_ci;
294 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
295 DROP DATABASE d10;
296 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
297 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
298 ALTER SCHEMA d10 COLLATE utf8_estonian_ci;
299 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
300 DROP DATABASE d10;
301 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
302 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
303 ALTER SCHEMA d10 DEFAULT COLLATE utf8_estonian_ci;
304 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
305 DROP DATABASE d10;
306 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
307 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
308 ALTER SCHEMA d10 COLLATE utf8_spanish_ci;
309 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
310 DROP DATABASE d10;
311 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
312 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
313 ALTER SCHEMA d10 DEFAULT COLLATE utf8_spanish_ci;
314 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
315 DROP DATABASE d10;
316 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
317 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
318 ALTER SCHEMA d10 COLLATE utf8_swedish_ci;
319 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
320 DROP DATABASE d10;
321 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
322 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
323 ALTER SCHEMA d10 DEFAULT COLLATE utf8_swedish_ci;
324 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
325 DROP DATABASE d10;
326 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
327 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
328 ALTER SCHEMA d10 COLLATE utf8_turkish_ci;
329 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
330 DROP DATABASE d10;
331 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
332 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
333 ALTER SCHEMA d10 DEFAULT COLLATE utf8_turkish_ci;
334 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
335 DROP DATABASE d10;
336 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
337 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
338 ALTER SCHEMA d10 COLLATE utf8_czech_ci;
339 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
340 DROP DATABASE d10;
341 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
342 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
343 ALTER SCHEMA d10 DEFAULT COLLATE utf8_czech_ci;
344 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
345 DROP DATABASE d10;
346 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
347 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
348 ALTER SCHEMA d10 COLLATE utf8_danish_ci;
349 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
350 DROP DATABASE d10;
351 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
352 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
353 ALTER SCHEMA d10 DEFAULT COLLATE utf8_danish_ci;
354 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
355 DROP DATABASE d10;
356 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
357 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
358 ALTER SCHEMA d10 COLLATE utf8_lithuanian_ci;
359 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
360 DROP DATABASE d10;
361 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
362 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
363 ALTER SCHEMA d10 DEFAULT COLLATE utf8_lithuanian_ci;
364 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
365 DROP DATABASE d10;
366 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
367 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
368 ALTER SCHEMA d10 COLLATE utf8_slovak_ci;
369 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
370 DROP DATABASE d10;
371 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
372 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
373 ALTER SCHEMA d10 DEFAULT COLLATE utf8_slovak_ci;
374 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
375 DROP DATABASE d10;
376 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
377 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
378 ALTER SCHEMA d10 COLLATE utf8_spanish2_ci;
379 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
380 DROP DATABASE d10;
381 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
382 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
383 ALTER SCHEMA d10 DEFAULT COLLATE utf8_spanish2_ci;
384 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
385 DROP DATABASE d10;
386 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
387 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
388 ALTER SCHEMA d10 COLLATE utf8_roman_ci;
389 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
390 DROP DATABASE d10;
391 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
392 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
393 ALTER SCHEMA d10 DEFAULT COLLATE utf8_roman_ci;
394 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
395 DROP DATABASE d10;
396 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
397 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
398 ALTER SCHEMA d10 COLLATE utf8_persian_ci;
399 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
400 DROP DATABASE d10;
401 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
402 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
403 ALTER SCHEMA d10 DEFAULT COLLATE utf8_persian_ci;
404 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
405 DROP DATABASE d10;
406 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
407 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
408 ALTER SCHEMA d10 COLLATE utf8_esperanto_ci;
409 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
410 DROP DATABASE d10;
411 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
412 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
413 ALTER SCHEMA d10 DEFAULT COLLATE utf8_esperanto_ci;
414 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
415 DROP DATABASE d10;
416 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
417 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
418 ALTER SCHEMA d10 COLLATE utf8_hungarian_ci;
419 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
420 DROP DATABASE d10;
421 CREATE DATABASE d10 DEFAULT CHARACTER SET utf8;
422 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
423 ALTER SCHEMA d10 DEFAULT COLLATE utf8_hungarian_ci;
424 SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ORDER BY SCHEMA_NAME;
425 DROP DATABASE d10;
426