Debian Codegraph @

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

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