← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/collation_server_basic.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

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