Debian Codegraph @

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

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