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