Debian Codegraph @

mysql-test/suite/sys_vars/r/collation_database_basic.result

raw
1 SET @global_start_value = @@global.collation_database;
2 SET @@global.collation_database=@@collation_server;
3 SELECT @@global.collation_database;
4 @@global.collation_database
5 utf8mb4_uca1400_ai_ci
6 SET @session_start_value = @@collation_database;
7 SELECT @session_start_value;
8 @session_start_value
9 utf8mb4_uca1400_ai_ci
10 SET @session_start_value = @@local.collation_database;
11 SELECT @session_start_value;
12 @session_start_value
13 utf8mb4_uca1400_ai_ci
14 SET @session_start_value = @@session.collation_database;
15 SELECT @session_start_value;
16 @session_start_value
17 utf8mb4_uca1400_ai_ci
18 '#--------------------FN_DYNVARS_016_01------------------#'
19 SELECT collation_database;
20 ERROR 42S22: Unknown column 'collation_database' in 'SELECT'
21 SET collation_database=utf8_unicode_ci;
22 SELECT @@session.collation_database;
23 @@session.collation_database
24 utf8mb3_unicode_ci
25 SET session collation_database=utf8_unicode_ci;
26 SELECT session collation_database;
27 ERROR 42S22: Unknown column 'session' in 'SELECT'
28 SET global collation_database=utf8_unicode_ci;
29 set global collation_database=@@collation_server;
30 SELECT global collation_database;
31 ERROR 42S22: Unknown column 'global' in 'SELECT'
32 '#--------------------FN_DYNVARS_016_02-------------------------#'
33 SET @@collation_database = latin1_bin;
34 SET @@collation_database = DEFAULT;
35 SELECT DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME=DATABASE();
36 DEFAULT_COLLATION_NAME
37 utf8mb4_uca1400_ai_ci
38 SELECT @@collation_database = @@global.collation_database;
39 @@collation_database = @@global.collation_database
40 1
41 SET @@global.collation_database = latin1_bin;
42 SET @@global.collation_database = DEFAULT;
43 SELECT length(@@global.collation_database) > 0;
44 length(@@global.collation_database) > 0
45 1
46 '#--------------------FN_DYNVARS_016_03-------------------------#'
47 SET @@session.collation_database = utf8_polish_ci;
48 SELECT @@session.collation_database;
49 @@session.collation_database
50 utf8mb3_polish_ci
51 SET @@global.collation_database = latin7_general_ci;
52 SELECT @@global.collation_database;
53 @@global.collation_database
54 latin7_general_ci
55 SELECT @@session.collation_database AS res_is_utf8_polish_ci;
56 res_is_utf8_polish_ci
57 utf8mb3_polish_ci
58 SET @@session.collation_database = latin7_bin;
59 SELECT @@session.collation_database;
60 @@session.collation_database
61 latin7_bin
62 SELECT @@global.collation_database AS res_is_latin7_general_ci;
63 res_is_latin7_general_ci
64 latin7_general_ci
65 SELECT @@global.collation_database=@@session.collation_database AS res_is_false;
66 res_is_false
67 0
68 '#--------------------FN_DYNVARS_016_04-------------------------#'
69 SELECT @@collation_database = @@session.collation_database AS res;
70 res
71 1
72 SELECT @@collation_database = @@local.collation_database AS res;
73 res
74 1
75 '#--------------------FN_DYNVARS_016_05-------------------------#'
76 SET @@collation_database = latin7_general_ci + latin7_general_cs;
77 ERROR 42S22: Unknown column 'latin7_general_ci' in 'SET'
78 '#--------------------FN_DYNVARS_016_06-------------------------#'
79 SET @@session.collation_database = big5_chinese_ci;
80 SELECT @@session.collation_database;
81 @@session.collation_database
82 big5_chinese_ci
83 SET @@session.collation_database = big5_bin;
84 SELECT @@session.collation_database;
85 @@session.collation_database
86 big5_bin
87 SET @@session.collation_database = dec8_swedish_ci;
88 SELECT @@session.collation_database;
89 @@session.collation_database
90 dec8_swedish_ci
91 SET @@session.collation_database = dec8_bin;
92 SELECT @@session.collation_database;
93 @@session.collation_database
94 dec8_bin
95 SET @@session.collation_database = cp850_general_ci;
96 SELECT @@session.collation_database;
97 @@session.collation_database
98 cp850_general_ci
99 SET @@session.collation_database = cp850_bin;
100 SELECT @@session.collation_database;
101 @@session.collation_database
102 cp850_bin
103 SET @@session.collation_database = hp8_english_ci;
104 SELECT @@session.collation_database;
105 @@session.collation_database
106 hp8_english_ci
107 SET @@session.collation_database = hp8_bin;
108 SELECT @@session.collation_database;
109 @@session.collation_database
110 hp8_bin
111 SET @@session.collation_database = koi8r_general_ci;
112 SELECT @@session.collation_database;
113 @@session.collation_database
114 koi8r_general_ci
115 SET @@session.collation_database = koi8r_bin;
116 SELECT @@session.collation_database;
117 @@session.collation_database
118 koi8r_bin
119 SET @@session.collation_database = latin1_german1_ci;
120 SELECT @@session.collation_database;
121 @@session.collation_database
122 latin1_german1_ci
123 SET @@session.collation_database = latin1_swedish_ci;
124 SELECT @@session.collation_database;
125 @@session.collation_database
126 latin1_swedish_ci
127 SET @@session.collation_database = latin1_danish_ci;
128 SELECT @@session.collation_database;
129 @@session.collation_database
130 latin1_danish_ci
131 SET @@session.collation_database = latin1_german2_ci;
132 SELECT @@session.collation_database;
133 @@session.collation_database
134 latin1_german2_ci
135 SET @@session.collation_database = latin1_bin;
136 SELECT @@session.collation_database;
137 @@session.collation_database
138 latin1_bin
139 SET @@session.collation_database = latin1_general_ci;
140 SELECT @@session.collation_database;
141 @@session.collation_database
142 latin1_general_ci
143 SET @@session.collation_database = latin1_general_cs;
144 SELECT @@session.collation_database;
145 @@session.collation_database
146 latin1_general_cs
147 SET @@session.collation_database = latin1_spanish_ci;
148 SELECT @@session.collation_database;
149 @@session.collation_database
150 latin1_spanish_ci
151 SET @@session.collation_database = latin2_czech_cs;
152 SELECT @@session.collation_database;
153 @@session.collation_database
154 latin2_czech_cs
155 SET @@session.collation_database = latin2_general_ci;
156 SELECT @@session.collation_database;
157 @@session.collation_database
158 latin2_general_ci
159 SET @@session.collation_database = latin2_hungarian_ci;
160 SELECT @@session.collation_database;
161 @@session.collation_database
162 latin2_hungarian_ci
163 SET @@session.collation_database = latin2_croatian_ci;
164 SELECT @@session.collation_database;
165 @@session.collation_database
166 latin2_croatian_ci
167 SET @@session.collation_database = latin2_bin;
168 SELECT @@session.collation_database;
169 @@session.collation_database
170 latin2_bin
171 SET @@session.collation_database = swe7_swedish_ci;
172 SELECT @@session.collation_database;
173 @@session.collation_database
174 swe7_swedish_ci
175 SET @@session.collation_database = swe7_bin;
176 SELECT @@session.collation_database;
177 @@session.collation_database
178 swe7_bin
179 SET @@session.collation_database = ascii_general_ci;
180 SELECT @@session.collation_database;
181 @@session.collation_database
182 ascii_general_ci
183 SET @@session.collation_database = ascii_bin;
184 SELECT @@session.collation_database;
185 @@session.collation_database
186 ascii_bin
187 SET @@session.collation_database = ujis_japanese_ci;
188 SELECT @@session.collation_database;
189 @@session.collation_database
190 ujis_japanese_ci
191 SET @@session.collation_database = ujis_bin;
192 SELECT @@session.collation_database;
193 @@session.collation_database
194 ujis_bin
195 SET @@session.collation_database = sjis_japanese_ci;
196 SELECT @@session.collation_database;
197 @@session.collation_database
198 sjis_japanese_ci
199 SET @@session.collation_database = sjis_bin;
200 SELECT @@session.collation_database;
201 @@session.collation_database
202 sjis_bin
203 SET @@session.collation_database = hebrew_general_ci;
204 SELECT @@session.collation_database;
205 @@session.collation_database
206 hebrew_general_ci
207 SET @@session.collation_database = hebrew_bin;
208 SELECT @@session.collation_database;
209 @@session.collation_database
210 hebrew_bin
211 SET @@session.collation_database = tis620_thai_ci;
212 SELECT @@session.collation_database;
213 @@session.collation_database
214 tis620_thai_ci
215 SET @@session.collation_database = tis620_bin;
216 SELECT @@session.collation_database;
217 @@session.collation_database
218 tis620_bin
219 SET @@session.collation_database = euckr_korean_ci;
220 SELECT @@session.collation_database;
221 @@session.collation_database
222 euckr_korean_ci
223 SET @@session.collation_database = euckr_bin;
224 SELECT @@session.collation_database;
225 @@session.collation_database
226 euckr_bin
227 SET @@session.collation_database = koi8u_general_ci;
228 SELECT @@session.collation_database;
229 @@session.collation_database
230 koi8u_general_ci
231 SET @@session.collation_database = koi8u_bin;
232 SELECT @@session.collation_database;
233 @@session.collation_database
234 koi8u_bin
235 SET @@session.collation_database = gb2312_chinese_ci;
236 SELECT @@session.collation_database;
237 @@session.collation_database
238 gb2312_chinese_ci
239 SET @@session.collation_database = gb2312_bin;
240 SELECT @@session.collation_database;
241 @@session.collation_database
242 gb2312_bin
243 SET @@session.collation_database = greek_general_ci;
244 SELECT @@session.collation_database;
245 @@session.collation_database
246 greek_general_ci
247 SET @@session.collation_database = greek_bin;
248 SELECT @@session.collation_database;
249 @@session.collation_database
250 greek_bin
251 SET @@session.collation_database = cp1250_general_ci;
252 SELECT @@session.collation_database;
253 @@session.collation_database
254 cp1250_general_ci
255 SET @@session.collation_database = cp1250_czech_cs;
256 SELECT @@session.collation_database;
257 @@session.collation_database
258 cp1250_czech_cs
259 SET @@session.collation_database = cp1250_croatian_ci;
260 SELECT @@session.collation_database;
261 @@session.collation_database
262 cp1250_croatian_ci
263 SET @@session.collation_database = cp1250_bin;
264 SELECT @@session.collation_database;
265 @@session.collation_database
266 cp1250_bin
267 SET @@session.collation_database = cp1250_polish_ci;
268 SELECT @@session.collation_database;
269 @@session.collation_database
270 cp1250_polish_ci
271 SET @@session.collation_database = gbk_chinese_ci;
272 SELECT @@session.collation_database;
273 @@session.collation_database
274 gbk_chinese_ci
275 SET @@session.collation_database = gbk_bin;
276 SELECT @@session.collation_database;
277 @@session.collation_database
278 gbk_bin
279 SET @@session.collation_database = latin5_turkish_ci;
280 SELECT @@session.collation_database;
281 @@session.collation_database
282 latin5_turkish_ci
283 SET @@session.collation_database = latin5_bin;
284 SELECT @@session.collation_database;
285 @@session.collation_database
286 latin5_bin
287 SET @@session.collation_database = armscii8_general_ci;
288 SELECT @@session.collation_database;
289 @@session.collation_database
290 armscii8_general_ci
291 SET @@session.collation_database = armscii8_bin;
292 SELECT @@session.collation_database;
293 @@session.collation_database
294 armscii8_bin
295 SET @@session.collation_database = utf8_general_ci;
296 SELECT @@session.collation_database;
297 @@session.collation_database
298 utf8mb3_general_ci
299 SET @@session.collation_database = utf8_bin;
300 SELECT @@session.collation_database;
301 @@session.collation_database
302 utf8mb3_bin
303 SET @@session.collation_database = utf8_unicode_ci;
304 SELECT @@session.collation_database;
305 @@session.collation_database
306 utf8mb3_unicode_ci
307 SET @@session.collation_database = utf8_icelandic_ci;
308 SELECT @@session.collation_database;
309 @@session.collation_database
310 utf8mb3_icelandic_ci
311 SET @@session.collation_database = utf8_latvian_ci;
312 SELECT @@session.collation_database;
313 @@session.collation_database
314 utf8mb3_latvian_ci
315 SET @@session.collation_database = utf8_romanian_ci;
316 SELECT @@session.collation_database;
317 @@session.collation_database
318 utf8mb3_romanian_ci
319 SET @@session.collation_database = utf8_slovenian_ci;
320 SELECT @@session.collation_database;
321 @@session.collation_database
322 utf8mb3_slovenian_ci
323 SET @@session.collation_database = utf8_polish_ci;
324 SELECT @@session.collation_database;
325 @@session.collation_database
326 utf8mb3_polish_ci
327 SET @@session.collation_database = utf8_estonian_ci;
328 SELECT @@session.collation_database;
329 @@session.collation_database
330 utf8mb3_estonian_ci
331 SET @@session.collation_database = utf8_spanish_ci;
332 SELECT @@session.collation_database;
333 @@session.collation_database
334 utf8mb3_spanish_ci
335 SET @@session.collation_database = utf8_swedish_ci;
336 SELECT @@session.collation_database;
337 @@session.collation_database
338 utf8mb3_swedish_ci
339 SET @@session.collation_database = utf8_turkish_ci;
340 SELECT @@session.collation_database;
341 @@session.collation_database
342 utf8mb3_turkish_ci
343 SET @@session.collation_database = utf8_czech_ci;
344 SELECT @@session.collation_database;
345 @@session.collation_database
346 utf8mb3_czech_ci
347 SET @@session.collation_database = utf8_danish_ci;
348 SELECT @@session.collation_database;
349 @@session.collation_database
350 utf8mb3_danish_ci
351 SET @@session.collation_database = utf8_lithuanian_ci;
352 SELECT @@session.collation_database;
353 @@session.collation_database
354 utf8mb3_lithuanian_ci
355 SET @@session.collation_database = utf8_slovak_ci;
356 SELECT @@session.collation_database;
357 @@session.collation_database
358 utf8mb3_slovak_ci
359 SET @@session.collation_database = utf8_spanish2_ci;
360 SELECT @@session.collation_database;
361 @@session.collation_database
362 utf8mb3_spanish2_ci
363 SET @@session.collation_database = utf8_roman_ci;
364 SELECT @@session.collation_database;
365 @@session.collation_database
366 utf8mb3_roman_ci
367 SET @@session.collation_database = utf8_persian_ci;
368 SELECT @@session.collation_database;
369 @@session.collation_database
370 utf8mb3_persian_ci
371 SET @@session.collation_database = utf8_esperanto_ci;
372 SELECT @@session.collation_database;
373 @@session.collation_database
374 utf8mb3_esperanto_ci
375 SET @@session.collation_database = utf8_hungarian_ci;
376 SELECT @@session.collation_database;
377 @@session.collation_database
378 utf8mb3_hungarian_ci
379 SET @@session.collation_database = utf8_thai_520_w2;
380 SELECT @@session.collation_database;
381 @@session.collation_database
382 utf8mb3_thai_520_w2
383 SET @@session.collation_database = ucs2_general_ci;
384 SELECT @@session.collation_database;
385 @@session.collation_database
386 ucs2_general_ci
387 SET @@session.collation_database = ucs2_bin;
388 SELECT @@session.collation_database;
389 @@session.collation_database
390 ucs2_bin
391 SET @@session.collation_database = ucs2_unicode_ci;
392 SELECT @@session.collation_database;
393 @@session.collation_database
394 ucs2_unicode_ci
395 SET @@session.collation_database = ucs2_icelandic_ci;
396 SELECT @@session.collation_database;
397 @@session.collation_database
398 ucs2_icelandic_ci
399 SET @@session.collation_database = ucs2_latvian_ci;
400 SELECT @@session.collation_database;
401 @@session.collation_database
402 ucs2_latvian_ci
403 SET @@session.collation_database = ucs2_romanian_ci;
404 SELECT @@session.collation_database;
405 @@session.collation_database
406 ucs2_romanian_ci
407 SET @@session.collation_database = ucs2_slovenian_ci;
408 SELECT @@session.collation_database;
409 @@session.collation_database
410 ucs2_slovenian_ci
411 SET @@session.collation_database = ucs2_polish_ci;
412 SELECT @@session.collation_database;
413 @@session.collation_database
414 ucs2_polish_ci
415 SET @@session.collation_database = ucs2_estonian_ci;
416 SELECT @@session.collation_database;
417 @@session.collation_database
418 ucs2_estonian_ci
419 SET @@session.collation_database = ucs2_spanish_ci;
420 SELECT @@session.collation_database;
421 @@session.collation_database
422 ucs2_spanish_ci
423 SET @@session.collation_database = ucs2_swedish_ci;
424 SELECT @@session.collation_database;
425 @@session.collation_database
426 ucs2_swedish_ci
427 SET @@session.collation_database = ucs2_turkish_ci;
428 SELECT @@session.collation_database;
429 @@session.collation_database
430 ucs2_turkish_ci
431 SET @@session.collation_database = ucs2_czech_ci;
432 SELECT @@session.collation_database;
433 @@session.collation_database
434 ucs2_czech_ci
435 SET @@session.collation_database = ucs2_danish_ci;
436 SELECT @@session.collation_database;
437 @@session.collation_database
438 ucs2_danish_ci
439 SET @@session.collation_database = ucs2_lithuanian_ci;
440 SELECT @@session.collation_database;
441 @@session.collation_database
442 ucs2_lithuanian_ci
443 SET @@session.collation_database = ucs2_slovak_ci;
444 SELECT @@session.collation_database;
445 @@session.collation_database
446 ucs2_slovak_ci
447 SET @@session.collation_database = ucs2_spanish2_ci;
448 SELECT @@session.collation_database;
449 @@session.collation_database
450 ucs2_spanish2_ci
451 SET @@session.collation_database = ucs2_roman_ci;
452 SELECT @@session.collation_database;
453 @@session.collation_database
454 ucs2_roman_ci
455 SET @@session.collation_database = ucs2_persian_ci;
456 SELECT @@session.collation_database;
457 @@session.collation_database
458 ucs2_persian_ci
459 SET @@session.collation_database = ucs2_esperanto_ci;
460 SELECT @@session.collation_database;
461 @@session.collation_database
462 ucs2_esperanto_ci
463 SET @@session.collation_database = ucs2_hungarian_ci;
464 SELECT @@session.collation_database;
465 @@session.collation_database
466 ucs2_hungarian_ci
467 SET @@session.collation_database = cp866_general_ci;
468 SELECT @@session.collation_database;
469 @@session.collation_database
470 cp866_general_ci
471 SET @@session.collation_database = cp866_bin;
472 SELECT @@session.collation_database;
473 @@session.collation_database
474 cp866_bin
475 SET @@session.collation_database = keybcs2_general_ci;
476 SELECT @@session.collation_database;
477 @@session.collation_database
478 keybcs2_general_ci
479 SET @@session.collation_database = keybcs2_bin;
480 SELECT @@session.collation_database;
481 @@session.collation_database
482 keybcs2_bin
483 SET @@session.collation_database = macce_general_ci;
484 SELECT @@session.collation_database;
485 @@session.collation_database
486 macce_general_ci
487 SET @@session.collation_database = macce_bin;
488 SELECT @@session.collation_database;
489 @@session.collation_database
490 macce_bin
491 SET @@session.collation_database = macroman_general_ci;
492 SELECT @@session.collation_database;
493 @@session.collation_database
494 macroman_general_ci
495 SET @@session.collation_database = macroman_bin;
496 SELECT @@session.collation_database;
497 @@session.collation_database
498 macroman_bin
499 SET @@session.collation_database = cp852_general_ci;
500 SELECT @@session.collation_database;
501 @@session.collation_database
502 cp852_general_ci
503 SET @@session.collation_database = cp852_bin;
504 SELECT @@session.collation_database;
505 @@session.collation_database
506 cp852_bin
507 SET @@session.collation_database = latin7_estonian_cs;
508 SELECT @@session.collation_database;
509 @@session.collation_database
510 latin7_estonian_cs
511 SET @@session.collation_database = latin7_general_ci;
512 SELECT @@session.collation_database;
513 @@session.collation_database
514 latin7_general_ci
515 SET @@session.collation_database = latin7_general_cs;
516 SELECT @@session.collation_database;
517 @@session.collation_database
518 latin7_general_cs
519 SET @@session.collation_database = latin7_bin;
520 SELECT @@session.collation_database;
521 @@session.collation_database
522 latin7_bin
523 SET @@session.collation_database = cp1251_bulgarian_ci;
524 SELECT @@session.collation_database;
525 @@session.collation_database
526 cp1251_bulgarian_ci
527 SET @@session.collation_database = cp1251_ukrainian_ci;
528 SELECT @@session.collation_database;
529 @@session.collation_database
530 cp1251_ukrainian_ci
531 SET @@session.collation_database = cp1251_bin;
532 SELECT @@session.collation_database;
533 @@session.collation_database
534 cp1251_bin
535 SET @@session.collation_database = cp1251_general_ci;
536 SELECT @@session.collation_database;
537 @@session.collation_database
538 cp1251_general_ci
539 SET @@session.collation_database = cp1251_general_cs;
540 SELECT @@session.collation_database;
541 @@session.collation_database
542 cp1251_general_cs
543 SET @@session.collation_database = cp1256_general_ci;
544 SELECT @@session.collation_database;
545 @@session.collation_database
546 cp1256_general_ci
547 SET @@session.collation_database = cp1256_bin;
548 SELECT @@session.collation_database;
549 @@session.collation_database
550 cp1256_bin
551 SET @@session.collation_database = cp1257_lithuanian_ci;
552 SELECT @@session.collation_database;
553 @@session.collation_database
554 cp1257_lithuanian_ci
555 SET @@session.collation_database = cp1257_bin;
556 SELECT @@session.collation_database;
557 @@session.collation_database
558 cp1257_bin
559 SET @@session.collation_database = cp1257_general_ci;
560 SELECT @@session.collation_database;
561 @@session.collation_database
562 cp1257_general_ci
563 SET @@session.collation_database = binary;
564 SELECT @@session.collation_database;
565 @@session.collation_database
566 binary
567 SET @@session.collation_database = geostd8_general_ci;
568 SELECT @@session.collation_database;
569 @@session.collation_database
570 geostd8_general_ci
571 SET @@session.collation_database = geostd8_bin;
572 SELECT @@session.collation_database;
573 @@session.collation_database
574 geostd8_bin
575 SET @@session.collation_database = cp932_japanese_ci;
576 SELECT @@session.collation_database;
577 @@session.collation_database
578 cp932_japanese_ci
579 SET @@session.collation_database = cp932_bin;
580 SELECT @@session.collation_database;
581 @@session.collation_database
582 cp932_bin
583 SET @@session.collation_database = eucjpms_japanese_ci;
584 SELECT @@session.collation_database;
585 @@session.collation_database
586 eucjpms_japanese_ci
587 SET @@session.collation_database = eucjpms_bin;
588 SELECT @@session.collation_database;
589 @@session.collation_database
590 eucjpms_bin
591 '#--------------------FN_DYNVARS_016_07-------------------------#'
592 SET @@global.collation_database = big5_chinese_ci;
593 SELECT @@global.collation_database;
594 @@global.collation_database
595 big5_chinese_ci
596 SET @@global.collation_database = big5_bin;
597 SELECT @@global.collation_database;
598 @@global.collation_database
599 big5_bin
600 SET @@global.collation_database = dec8_swedish_ci;
601 SELECT @@global.collation_database;
602 @@global.collation_database
603 dec8_swedish_ci
604 SET @@global.collation_database = dec8_bin;
605 SELECT @@global.collation_database;
606 @@global.collation_database
607 dec8_bin
608 SET @@global.collation_database = cp850_general_ci;
609 SELECT @@global.collation_database;
610 @@global.collation_database
611 cp850_general_ci
612 SET @@global.collation_database = cp850_bin;
613 SELECT @@global.collation_database;
614 @@global.collation_database
615 cp850_bin
616 SET @@global.collation_database = hp8_english_ci;
617 SELECT @@global.collation_database;
618 @@global.collation_database
619 hp8_english_ci
620 SET @@global.collation_database = hp8_bin;
621 SELECT @@global.collation_database;
622 @@global.collation_database
623 hp8_bin
624 SET @@global.collation_database = koi8r_general_ci;
625 SELECT @@global.collation_database;
626 @@global.collation_database
627 koi8r_general_ci
628 SET @@global.collation_database = koi8r_bin;
629 SELECT @@global.collation_database;
630 @@global.collation_database
631 koi8r_bin
632 SET @@global.collation_database = latin1_german1_ci;
633 SELECT @@global.collation_database;
634 @@global.collation_database
635 latin1_german1_ci
636 SET @@global.collation_database = latin1_swedish_ci;
637 SELECT @@global.collation_database;
638 @@global.collation_database
639 latin1_swedish_ci
640 SET @@global.collation_database = latin1_danish_ci;
641 SELECT @@global.collation_database;
642 @@global.collation_database
643 latin1_danish_ci
644 SET @@global.collation_database = latin1_german2_ci;
645 SELECT @@global.collation_database;
646 @@global.collation_database
647 latin1_german2_ci
648 SET @@global.collation_database = latin1_bin;
649 SELECT @@global.collation_database;
650 @@global.collation_database
651 latin1_bin
652 SET @@global.collation_database = latin1_general_ci;
653 SELECT @@global.collation_database;
654 @@global.collation_database
655 latin1_general_ci
656 SET @@global.collation_database = latin1_general_cs;
657 SELECT @@global.collation_database;
658 @@global.collation_database
659 latin1_general_cs
660 SET @@global.collation_database = latin1_spanish_ci;
661 SELECT @@global.collation_database;
662 @@global.collation_database
663 latin1_spanish_ci
664 SET @@global.collation_database = latin2_czech_cs;
665 SELECT @@global.collation_database;
666 @@global.collation_database
667 latin2_czech_cs
668 SET @@global.collation_database = latin2_general_ci;
669 SELECT @@global.collation_database;
670 @@global.collation_database
671 latin2_general_ci
672 SET @@global.collation_database = latin2_hungarian_ci;
673 SELECT @@global.collation_database;
674 @@global.collation_database
675 latin2_hungarian_ci
676 SET @@global.collation_database = latin2_croatian_ci;
677 SELECT @@global.collation_database;
678 @@global.collation_database
679 latin2_croatian_ci
680 SET @@global.collation_database = latin2_bin;
681 SELECT @@global.collation_database;
682 @@global.collation_database
683 latin2_bin
684 SET @@global.collation_database = swe7_swedish_ci;
685 SELECT @@global.collation_database;
686 @@global.collation_database
687 swe7_swedish_ci
688 SET @@global.collation_database = swe7_bin;
689 SELECT @@global.collation_database;
690 @@global.collation_database
691 swe7_bin
692 SET @@global.collation_database = ascii_general_ci;
693 SELECT @@global.collation_database;
694 @@global.collation_database
695 ascii_general_ci
696 SET @@global.collation_database = ascii_bin;
697 SELECT @@global.collation_database;
698 @@global.collation_database
699 ascii_bin
700 SET @@global.collation_database = ujis_japanese_ci;
701 SELECT @@global.collation_database;
702 @@global.collation_database
703 ujis_japanese_ci
704 SET @@global.collation_database = ujis_bin;
705 SELECT @@global.collation_database;
706 @@global.collation_database
707 ujis_bin
708 SET @@global.collation_database = sjis_japanese_ci;
709 SELECT @@global.collation_database;
710 @@global.collation_database
711 sjis_japanese_ci
712 SET @@global.collation_database = sjis_bin;
713 SELECT @@global.collation_database;
714 @@global.collation_database
715 sjis_bin
716 SET @@global.collation_database = hebrew_general_ci;
717 SELECT @@global.collation_database;
718 @@global.collation_database
719 hebrew_general_ci
720 SET @@global.collation_database = hebrew_bin;
721 SELECT @@global.collation_database;
722 @@global.collation_database
723 hebrew_bin
724 SET @@global.collation_database = tis620_thai_ci;
725 SELECT @@global.collation_database;
726 @@global.collation_database
727 tis620_thai_ci
728 SET @@global.collation_database = tis620_bin;
729 SELECT @@global.collation_database;
730 @@global.collation_database
731 tis620_bin
732 SET @@global.collation_database = euckr_korean_ci;
733 SELECT @@global.collation_database;
734 @@global.collation_database
735 euckr_korean_ci
736 SET @@global.collation_database = euckr_bin;
737 SELECT @@global.collation_database;
738 @@global.collation_database
739 euckr_bin
740 SET @@global.collation_database = koi8u_general_ci;
741 SELECT @@global.collation_database;
742 @@global.collation_database
743 koi8u_general_ci
744 SET @@global.collation_database = koi8u_bin;
745 SELECT @@global.collation_database;
746 @@global.collation_database
747 koi8u_bin
748 SET @@global.collation_database = gb2312_chinese_ci;
749 SELECT @@global.collation_database;
750 @@global.collation_database
751 gb2312_chinese_ci
752 SET @@global.collation_database = gb2312_bin;
753 SELECT @@global.collation_database;
754 @@global.collation_database
755 gb2312_bin
756 SET @@global.collation_database = greek_general_ci;
757 SELECT @@global.collation_database;
758 @@global.collation_database
759 greek_general_ci
760 SET @@global.collation_database = greek_bin;
761 SELECT @@global.collation_database;
762 @@global.collation_database
763 greek_bin
764 SET @@global.collation_database = cp1250_general_ci;
765 SELECT @@global.collation_database;
766 @@global.collation_database
767 cp1250_general_ci
768 SET @@global.collation_database = cp1250_czech_cs;
769 SELECT @@global.collation_database;
770 @@global.collation_database
771 cp1250_czech_cs
772 SET @@global.collation_database = cp1250_croatian_ci;
773 SELECT @@global.collation_database;
774 @@global.collation_database
775 cp1250_croatian_ci
776 SET @@global.collation_database = cp1250_bin;
777 SELECT @@global.collation_database;
778 @@global.collation_database
779 cp1250_bin
780 SET @@global.collation_database = cp1250_polish_ci;
781 SELECT @@global.collation_database;
782 @@global.collation_database
783 cp1250_polish_ci
784 SET @@global.collation_database = gbk_chinese_ci;
785 SELECT @@global.collation_database;
786 @@global.collation_database
787 gbk_chinese_ci
788 SET @@global.collation_database = gbk_bin;
789 SELECT @@global.collation_database;
790 @@global.collation_database
791 gbk_bin
792 SET @@global.collation_database = latin5_turkish_ci;
793 SELECT @@global.collation_database;
794 @@global.collation_database
795 latin5_turkish_ci
796 SET @@global.collation_database = latin5_bin;
797 SELECT @@global.collation_database;
798 @@global.collation_database
799 latin5_bin
800 SET @@global.collation_database = armscii8_general_ci;
801 SELECT @@global.collation_database;
802 @@global.collation_database
803 armscii8_general_ci
804 SET @@global.collation_database = armscii8_bin;
805 SELECT @@global.collation_database;
806 @@global.collation_database
807 armscii8_bin
808 SET @@global.collation_database = utf8_general_ci;
809 SELECT @@global.collation_database;
810 @@global.collation_database
811 utf8mb3_general_ci
812 SET @@global.collation_database = utf8_bin;
813 SELECT @@global.collation_database;
814 @@global.collation_database
815 utf8mb3_bin
816 SET @@global.collation_database = utf8_unicode_ci;
817 SELECT @@global.collation_database;
818 @@global.collation_database
819 utf8mb3_unicode_ci
820 SET @@global.collation_database = utf8_icelandic_ci;
821 SELECT @@global.collation_database;
822 @@global.collation_database
823 utf8mb3_icelandic_ci
824 SET @@global.collation_database = utf8_latvian_ci;
825 SELECT @@global.collation_database;
826 @@global.collation_database
827 utf8mb3_latvian_ci
828 SET @@global.collation_database = utf8_romanian_ci;
829 SELECT @@global.collation_database;
830 @@global.collation_database
831 utf8mb3_romanian_ci
832 SET @@global.collation_database = utf8_slovenian_ci;
833 SELECT @@global.collation_database;
834 @@global.collation_database
835 utf8mb3_slovenian_ci
836 SET @@global.collation_database = utf8_polish_ci;
837 SELECT @@global.collation_database;
838 @@global.collation_database
839 utf8mb3_polish_ci
840 SET @@global.collation_database = utf8_estonian_ci;
841 SELECT @@global.collation_database;
842 @@global.collation_database
843 utf8mb3_estonian_ci
844 SET @@global.collation_database = utf8_spanish_ci;
845 SELECT @@global.collation_database;
846 @@global.collation_database
847 utf8mb3_spanish_ci
848 SET @@global.collation_database = utf8_swedish_ci;
849 SELECT @@global.collation_database;
850 @@global.collation_database
851 utf8mb3_swedish_ci
852 SET @@global.collation_database = utf8_turkish_ci;
853 SELECT @@global.collation_database;
854 @@global.collation_database
855 utf8mb3_turkish_ci
856 SET @@global.collation_database = utf8_czech_ci;
857 SELECT @@global.collation_database;
858 @@global.collation_database
859 utf8mb3_czech_ci
860 SET @@global.collation_database = utf8_danish_ci;
861 SELECT @@global.collation_database;
862 @@global.collation_database
863 utf8mb3_danish_ci
864 SET @@global.collation_database = utf8_lithuanian_ci;
865 SELECT @@global.collation_database;
866 @@global.collation_database
867 utf8mb3_lithuanian_ci
868 SET @@global.collation_database = utf8_slovak_ci;
869 SELECT @@global.collation_database;
870 @@global.collation_database
871 utf8mb3_slovak_ci
872 SET @@global.collation_database = utf8_spanish2_ci;
873 SELECT @@global.collation_database;
874 @@global.collation_database
875 utf8mb3_spanish2_ci
876 SET @@global.collation_database = utf8_roman_ci;
877 SELECT @@global.collation_database;
878 @@global.collation_database
879 utf8mb3_roman_ci
880 SET @@global.collation_database = utf8_persian_ci;
881 SELECT @@global.collation_database;
882 @@global.collation_database
883 utf8mb3_persian_ci
884 SET @@global.collation_database = utf8_esperanto_ci;
885 SELECT @@global.collation_database;
886 @@global.collation_database
887 utf8mb3_esperanto_ci
888 SET @@global.collation_database = utf8_hungarian_ci;
889 SELECT @@global.collation_database;
890 @@global.collation_database
891 utf8mb3_hungarian_ci
892 SET @@global.collation_database = utf8_thai_520_w2;
893 SELECT @@global.collation_database;
894 @@global.collation_database
895 utf8mb3_thai_520_w2
896 SET @@global.collation_database = ucs2_general_ci;
897 SELECT @@global.collation_database;
898 @@global.collation_database
899 ucs2_general_ci
900 SET @@global.collation_database = ucs2_bin;
901 SELECT @@global.collation_database;
902 @@global.collation_database
903 ucs2_bin
904 SET @@global.collation_database = ucs2_unicode_ci;
905 SELECT @@global.collation_database;
906 @@global.collation_database
907 ucs2_unicode_ci
908 SET @@global.collation_database = ucs2_icelandic_ci;
909 SELECT @@global.collation_database;
910 @@global.collation_database
911 ucs2_icelandic_ci
912 SET @@global.collation_database = ucs2_latvian_ci;
913 SELECT @@global.collation_database;
914 @@global.collation_database
915 ucs2_latvian_ci
916 SET @@global.collation_database = ucs2_romanian_ci;
917 SELECT @@global.collation_database;
918 @@global.collation_database
919 ucs2_romanian_ci
920 SET @@global.collation_database = ucs2_slovenian_ci;
921 SELECT @@global.collation_database;
922 @@global.collation_database
923 ucs2_slovenian_ci
924 SET @@global.collation_database = ucs2_polish_ci;
925 SELECT @@global.collation_database;
926 @@global.collation_database
927 ucs2_polish_ci
928 SET @@global.collation_database = ucs2_estonian_ci;
929 SELECT @@global.collation_database;
930 @@global.collation_database
931 ucs2_estonian_ci
932 SET @@global.collation_database = ucs2_spanish_ci;
933 SELECT @@global.collation_database;
934 @@global.collation_database
935 ucs2_spanish_ci
936 SET @@global.collation_database = ucs2_swedish_ci;
937 SELECT @@global.collation_database;
938 @@global.collation_database
939 ucs2_swedish_ci
940 SET @@global.collation_database = ucs2_turkish_ci;
941 SELECT @@global.collation_database;
942 @@global.collation_database
943 ucs2_turkish_ci
944 SET @@global.collation_database = ucs2_czech_ci;
945 SELECT @@global.collation_database;
946 @@global.collation_database
947 ucs2_czech_ci
948 SET @@global.collation_database = ucs2_danish_ci;
949 SELECT @@global.collation_database;
950 @@global.collation_database
951 ucs2_danish_ci
952 SET @@global.collation_database = ucs2_lithuanian_ci;
953 SELECT @@global.collation_database;
954 @@global.collation_database
955 ucs2_lithuanian_ci
956 SET @@global.collation_database = ucs2_slovak_ci;
957 SELECT @@global.collation_database;
958 @@global.collation_database
959 ucs2_slovak_ci
960 SET @@global.collation_database = ucs2_spanish2_ci;
961 SELECT @@global.collation_database;
962 @@global.collation_database
963 ucs2_spanish2_ci
964 SET @@global.collation_database = ucs2_roman_ci;
965 SELECT @@global.collation_database;
966 @@global.collation_database
967 ucs2_roman_ci
968 SET @@global.collation_database = ucs2_persian_ci;
969 SELECT @@global.collation_database;
970 @@global.collation_database
971 ucs2_persian_ci
972 SET @@global.collation_database = ucs2_esperanto_ci;
973 SELECT @@global.collation_database;
974 @@global.collation_database
975 ucs2_esperanto_ci
976 SET @@global.collation_database = ucs2_hungarian_ci;
977 SELECT @@global.collation_database;
978 @@global.collation_database
979 ucs2_hungarian_ci
980 SET @@global.collation_database = cp866_general_ci;
981 SELECT @@global.collation_database;
982 @@global.collation_database
983 cp866_general_ci
984 SET @@global.collation_database = cp866_bin;
985 SELECT @@global.collation_database;
986 @@global.collation_database
987 cp866_bin
988 SET @@global.collation_database = keybcs2_general_ci;
989 SELECT @@global.collation_database;
990 @@global.collation_database
991 keybcs2_general_ci
992 SET @@global.collation_database = keybcs2_bin;
993 SELECT @@global.collation_database;
994 @@global.collation_database
995 keybcs2_bin
996 SET @@global.collation_database = macce_general_ci;
997 SELECT @@global.collation_database;
998 @@global.collation_database
999 macce_general_ci
1000 SET @@global.collation_database = macce_bin;
1001 SELECT @@global.collation_database;
1002 @@global.collation_database
1003 macce_bin
1004 SET @@global.collation_database = macroman_general_ci;
1005 SELECT @@global.collation_database;
1006 @@global.collation_database
1007 macroman_general_ci
1008 SET @@global.collation_database = macroman_bin;
1009 SELECT @@global.collation_database;
1010 @@global.collation_database
1011 macroman_bin
1012 SET @@global.collation_database = cp852_general_ci;
1013 SELECT @@global.collation_database;
1014 @@global.collation_database
1015 cp852_general_ci
1016 SET @@global.collation_database = cp852_bin;
1017 SELECT @@global.collation_database;
1018 @@global.collation_database
1019 cp852_bin
1020 SET @@global.collation_database = latin7_estonian_cs;
1021 SELECT @@global.collation_database;
1022 @@global.collation_database
1023 latin7_estonian_cs
1024 SET @@global.collation_database = latin7_general_ci;
1025 SELECT @@global.collation_database;
1026 @@global.collation_database
1027 latin7_general_ci
1028 SET @@global.collation_database = latin7_general_cs;
1029 SELECT @@global.collation_database;
1030 @@global.collation_database
1031 latin7_general_cs
1032 SET @@global.collation_database = latin7_bin;
1033 SELECT @@global.collation_database;
1034 @@global.collation_database
1035 latin7_bin
1036 SET @@global.collation_database = cp1251_bulgarian_ci;
1037 SELECT @@global.collation_database;
1038 @@global.collation_database
1039 cp1251_bulgarian_ci
1040 SET @@global.collation_database = cp1251_ukrainian_ci;
1041 SELECT @@global.collation_database;
1042 @@global.collation_database
1043 cp1251_ukrainian_ci
1044 SET @@global.collation_database = cp1251_bin;
1045 SELECT @@global.collation_database;
1046 @@global.collation_database
1047 cp1251_bin
1048 SET @@global.collation_database = cp1251_general_ci;
1049 SELECT @@global.collation_database;
1050 @@global.collation_database
1051 cp1251_general_ci
1052 SET @@global.collation_database = cp1251_general_cs;
1053 SELECT @@global.collation_database;
1054 @@global.collation_database
1055 cp1251_general_cs
1056 SET @@global.collation_database = cp1256_general_ci;
1057 SELECT @@global.collation_database;
1058 @@global.collation_database
1059 cp1256_general_ci
1060 SET @@global.collation_database = cp1256_bin;
1061 SELECT @@global.collation_database;
1062 @@global.collation_database
1063 cp1256_bin
1064 SET @@global.collation_database = cp1257_lithuanian_ci;
1065 SELECT @@global.collation_database;
1066 @@global.collation_database
1067 cp1257_lithuanian_ci
1068 SET @@global.collation_database = cp1257_bin;
1069 SELECT @@global.collation_database;
1070 @@global.collation_database
1071 cp1257_bin
1072 SET @@global.collation_database = cp1257_general_ci;
1073 SELECT @@global.collation_database;
1074 @@global.collation_database
1075 cp1257_general_ci
1076 SET @@global.collation_database = binary;
1077 SELECT @@global.collation_database;
1078 @@global.collation_database
1079 binary
1080 SET @@global.collation_database = geostd8_general_ci;
1081 SELECT @@global.collation_database;
1082 @@global.collation_database
1083 geostd8_general_ci
1084 SET @@global.collation_database = geostd8_bin;
1085 SELECT @@global.collation_database;
1086 @@global.collation_database
1087 geostd8_bin
1088 SET @@global.collation_database = cp932_japanese_ci;
1089 SELECT @@global.collation_database;
1090 @@global.collation_database
1091 cp932_japanese_ci
1092 SET @@global.collation_database = cp932_bin;
1093 SELECT @@global.collation_database;
1094 @@global.collation_database
1095 cp932_bin
1096 SET @@global.collation_database = eucjpms_japanese_ci;
1097 SELECT @@global.collation_database;
1098 @@global.collation_database
1099 eucjpms_japanese_ci
1100 SET @@global.collation_database = eucjpms_bin;
1101 SELECT @@global.collation_database;
1102 @@global.collation_database
1103 eucjpms_bin
1104 '#--------------------FN_DYNVARS_016_08-------------------------#'
1105 SET @@collation_database = LATIN7_GENERAL_CS;
1106 SELECT @@collation_database;
1107 @@collation_database
1108 latin7_general_cs
1109 SET @@collation_database = latin7_general_cs;
1110 SELECT @@collation_database;
1111 @@collation_database
1112 latin7_general_cs
1113 SET @@global.collation_database = Latin7_GeneRal_cS;
1114 SELECT @@global.collation_database;
1115 @@global.collation_database
1116 latin7_general_cs
1117 '#--------------------FN_DYNVARS_016_09-------------------------#'
1118 SET @@collation_database = 1;
1119 SELECT @@collation_database;
1120 @@collation_database
1121 big5_chinese_ci
1122 SET @@collation_database = 2;
1123 SELECT @@collation_database;
1124 @@collation_database
1125 latin2_czech_cs
1126 SET @@collation_database = 3;
1127 SELECT @@collation_database;
1128 @@collation_database
1129 dec8_swedish_ci
1130 SET @@collation_database = 99;
1131 SELECT @@collation_database;
1132 @@collation_database
1133 cp1250_polish_ci
1134 SET @@collation_database = 100;
1135 ERROR HY000: Unknown collation: '100'
1136 SET @@global.collation_database = 1;
1137 SELECT @@global.collation_database;
1138 @@global.collation_database
1139 big5_chinese_ci
1140 SET @@global.collation_database = 2;
1141 SELECT @@global.collation_database;
1142 @@global.collation_database
1143 latin2_czech_cs
1144 SET @@global.collation_database = 3;
1145 SELECT @@global.collation_database;
1146 @@global.collation_database
1147 dec8_swedish_ci
1148 SET @@global.collation_database = 99;
1149 SELECT @@global.collation_database;
1150 @@global.collation_database
1151 cp1250_polish_ci
1152 SET @@global.collation_database = 100;
1153 ERROR HY000: Unknown collation: '100'
1154 SET @total_collations = (SELECT count(*) FROM INFORMATION_SCHEMA.COLLATIONS);
1155 SELECT @total_collations > 120;
1156 @total_collations > 120
1157 1
1158 '#--------------------FN_DYNVARS_016_10-------------------------#'
1159 SET @@collation_database = latin7_binary;
1160 ERROR HY000: Unknown collation: 'latin7_binary'
1161 SET @@collation_database = 'eucjpms_japanese_cs';
1162 ERROR HY000: Unknown collation: 'eucjpms_japanese_cs'
1163 SET @@collation_database = 0;
1164 ERROR HY000: Unknown collation: '0'
1165 SET @@collation_database = 1.01;
1166 ERROR 42000: Incorrect argument type to variable 'collation_database'
1167 SET @@collation_database = -1;
1168 ERROR HY000: Unknown collation: '-1'
1169 SET @@collation_database = '';
1170 ERROR HY000: Unknown collation: ''
1171 SET @@collation_database = ' eucjpms_bin';
1172 ERROR HY000: Unknown collation: ' eucjpms_bin'
1173 SET @@collation_database = true;
1174 SELECT @@collation_database AS res_with_true;
1175 res_with_true
1176 big5_chinese_ci
1177 SET @@collation_database = ON;
1178 ERROR HY000: Unknown collation: 'ON'
1179 '#--------------------FN_DYNVARS_016_11-------------------------#'
1180 SET @@global.collation_database = latin7_binary;
1181 ERROR HY000: Unknown collation: 'latin7_binary'
1182 SET @@global.collation_database = 'eucjpms_japanese_cs';
1183 ERROR HY000: Unknown collation: 'eucjpms_japanese_cs'
1184 SET @@global.collation_database = 0;
1185 ERROR HY000: Unknown collation: '0'
1186 SET @@global.collation_database = 1.1;
1187 ERROR 42000: Incorrect argument type to variable 'collation_database'
1188 SET @@global.collation_database = -1;
1189 ERROR HY000: Unknown collation: '-1'
1190 SET @@global.collation_database = "";
1191 ERROR HY000: Unknown collation: ''
1192 SET @@global.collation_database = ' eucjpms_bin';
1193 ERROR HY000: Unknown collation: ' eucjpms_bin'
1194 SET @@global.collation_database = true;
1195 SET @@global.collation_database = ON;
1196 ERROR HY000: Unknown collation: 'ON'
1197 '#--------------------FN_DYNVARS_016_12-------------------------#'
1198 SELECT @@global.collation_database =
1199 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
1200 WHERE VARIABLE_NAME='collation_database') AS res;
1201 res
1202 1
1203 SET @@global.collation_database = 1;
1204 SELECT @@global.collation_database;
1205 @@global.collation_database
1206 big5_chinese_ci
1207 SELECT @@global.collation_database =
1208 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
1209 WHERE VARIABLE_NAME='collation_database') AS res;
1210 res
1211 1
1212 '#--------------------FN_DYNVARS_016_13-------------------------#'
1213 SELECT @@collation_database =
1214 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1215 WHERE VARIABLE_NAME='collation_database') AS res;
1216 res
1217 1
1218 SELECT @@local.collation_database =
1219 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1220 WHERE VARIABLE_NAME='collation_database') AS res;
1221 res
1222 1
1223 SELECT @@session.collation_database =
1224 (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1225 WHERE VARIABLE_NAME='collation_database') AS res;
1226 res
1227 1
1228 SET @@global.collation_database = @global_start_value;
1229 SET @@session.collation_database = @session_start_value;