Debian Codegraph @

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

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