Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.collation_database;
2 SELECT @global_start_value;
3 @global_start_value
4 utf8mb4_0900_ai_ci
5 SET @session_start_value = @@collation_database;
6 SELECT @session_start_value;
7 @session_start_value
8 utf8mb4_0900_ai_ci
9 SET @session_start_value = @@local.collation_database;
10 SELECT @session_start_value;
11 @session_start_value
12 utf8mb4_0900_ai_ci
13 SET @session_start_value = @@session.collation_database;
14 SELECT @session_start_value;
15 @session_start_value
16 utf8mb4_0900_ai_ci
17 '#--------------------FN_DYNVARS_016_01------------------#'
18 SELECT collation_database;
19 ERROR 42S22: Unknown column 'collation_database' in 'field list'
20 SET collation_database=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 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
24 SELECT @@session.collation_database;
25 @@session.collation_database
26 utf8mb3_unicode_ci
27 SET global.collation_database=utf8_unicode_ci;
28 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_database=utf8_unicode_ci' at line 1
29 SET session collation_database=utf8_unicode_ci;
30 Warnings:
31 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
32 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
33 SELECT session collation_database;
34 ERROR 42S22: Unknown column 'session' in 'field list'
35 SET global collation_database=utf8_unicode_ci;
36 Warnings:
37 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
38 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
39 SELECT global collation_database;
40 ERROR 42S22: Unknown column 'global' in 'field list'
41 '#--------------------FN_DYNVARS_016_02-------------------------#'
42 SET @@collation_database = latin1_bin;
43 Warnings:
44 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
45 SET @@collation_database = DEFAULT;
46 Warnings:
47 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
48 SELECT DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME=DATABASE();
49 DEFAULT_COLLATION_NAME
50 utf8mb4_0900_ai_ci
51 SELECT @@collation_database AS DEFAULT_VALUE;
52 DEFAULT_VALUE
53 utf8mb4_0900_ai_ci
54 SET @@global.collation_database = latin1_bin;
55 Warnings:
56 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
57 SET @@global.collation_database = DEFAULT;
58 Warnings:
59 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
60 SELECT @@global.collation_database;
61 @@global.collation_database
62 utf8mb4_0900_ai_ci
63 '#--------------------FN_DYNVARS_016_03-------------------------#'
64 SET @@session.collation_database = utf8_polish_ci;
65 Warnings:
66 Warning 3778 'utf8mb3_polish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
67 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
68 SELECT @@session.collation_database;
69 @@session.collation_database
70 utf8mb3_polish_ci
71 SET @@global.collation_database = latin7_general_ci;
72 Warnings:
73 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
74 SELECT @@global.collation_database;
75 @@global.collation_database
76 latin7_general_ci
77 SELECT @@session.collation_database AS res_is_utf8_polish_ci;
78 res_is_utf8_polish_ci
79 utf8mb3_polish_ci
80 SET @@session.collation_database = latin7_bin;
81 Warnings:
82 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
83 SELECT @@session.collation_database;
84 @@session.collation_database
85 latin7_bin
86 SELECT @@global.collation_database AS res_is_latin7_general_ci;
87 res_is_latin7_general_ci
88 latin7_general_ci
89 SELECT @@global.collation_database=@@session.collation_database AS res_is_false;
90 res_is_false
91 0
92 '#--------------------FN_DYNVARS_016_04-------------------------#'
93 SELECT @@collation_database = @@session.collation_database AS res;
94 res
95 1
96 SELECT @@collation_database = @@local.collation_database AS res;
97 res
98 1
99 '#--------------------FN_DYNVARS_016_05-------------------------#'
100 SET @@collation_database = latin7_general_ci + latin7_general_cs;
101 ERROR 42S22: Unknown column 'latin7_general_ci' in 'field list'
102 '#--------------------FN_DYNVARS_016_06-------------------------#'
103 SET @@session.collation_database = big5_chinese_ci;
104 Warnings:
105 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
106 SELECT @@session.collation_database;
107 @@session.collation_database
108 big5_chinese_ci
109 SET @@session.collation_database = big5_bin;
110 Warnings:
111 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
112 SELECT @@session.collation_database;
113 @@session.collation_database
114 big5_bin
115 SET @@session.collation_database = dec8_swedish_ci;
116 Warnings:
117 Warning 4079 'dec8_swedish_ci' is a collation of the deprecated character set dec8. Please consider using utf8mb4 with an appropriate collation instead.
118 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
119 SELECT @@session.collation_database;
120 @@session.collation_database
121 dec8_swedish_ci
122 SET @@session.collation_database = dec8_bin;
123 Warnings:
124 Warning 4079 'dec8_bin' is a collation of the deprecated character set dec8. Please consider using utf8mb4 with an appropriate collation instead.
125 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
126 SELECT @@session.collation_database;
127 @@session.collation_database
128 dec8_bin
129 SET @@session.collation_database = cp850_general_ci;
130 Warnings:
131 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
132 SELECT @@session.collation_database;
133 @@session.collation_database
134 cp850_general_ci
135 SET @@session.collation_database = cp850_bin;
136 Warnings:
137 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
138 SELECT @@session.collation_database;
139 @@session.collation_database
140 cp850_bin
141 SET @@session.collation_database = hp8_english_ci;
142 Warnings:
143 Warning 4079 'hp8_english_ci' is a collation of the deprecated character set hp8. Please consider using utf8mb4 with an appropriate collation instead.
144 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
145 SELECT @@session.collation_database;
146 @@session.collation_database
147 hp8_english_ci
148 SET @@session.collation_database = hp8_bin;
149 Warnings:
150 Warning 4079 'hp8_bin' is a collation of the deprecated character set hp8. Please consider using utf8mb4 with an appropriate collation instead.
151 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
152 SELECT @@session.collation_database;
153 @@session.collation_database
154 hp8_bin
155 SET @@session.collation_database = koi8r_general_ci;
156 Warnings:
157 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
158 SELECT @@session.collation_database;
159 @@session.collation_database
160 koi8r_general_ci
161 SET @@session.collation_database = koi8r_bin;
162 Warnings:
163 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
164 SELECT @@session.collation_database;
165 @@session.collation_database
166 koi8r_bin
167 SET @@session.collation_database = latin1_german1_ci;
168 Warnings:
169 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
170 SELECT @@session.collation_database;
171 @@session.collation_database
172 latin1_german1_ci
173 SET @@session.collation_database = latin1_swedish_ci;
174 Warnings:
175 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
176 SELECT @@session.collation_database;
177 @@session.collation_database
178 latin1_swedish_ci
179 SET @@session.collation_database = latin1_danish_ci;
180 Warnings:
181 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
182 SELECT @@session.collation_database;
183 @@session.collation_database
184 latin1_danish_ci
185 SET @@session.collation_database = latin1_german2_ci;
186 Warnings:
187 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
188 SELECT @@session.collation_database;
189 @@session.collation_database
190 latin1_german2_ci
191 SET @@session.collation_database = latin1_bin;
192 Warnings:
193 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
194 SELECT @@session.collation_database;
195 @@session.collation_database
196 latin1_bin
197 SET @@session.collation_database = latin1_general_ci;
198 Warnings:
199 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
200 SELECT @@session.collation_database;
201 @@session.collation_database
202 latin1_general_ci
203 SET @@session.collation_database = latin1_general_cs;
204 Warnings:
205 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
206 SELECT @@session.collation_database;
207 @@session.collation_database
208 latin1_general_cs
209 SET @@session.collation_database = latin1_spanish_ci;
210 Warnings:
211 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
212 SELECT @@session.collation_database;
213 @@session.collation_database
214 latin1_spanish_ci
215 SET @@session.collation_database = latin2_czech_cs;
216 Warnings:
217 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
218 SELECT @@session.collation_database;
219 @@session.collation_database
220 latin2_czech_cs
221 SET @@session.collation_database = latin2_general_ci;
222 Warnings:
223 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
224 SELECT @@session.collation_database;
225 @@session.collation_database
226 latin2_general_ci
227 SET @@session.collation_database = latin2_hungarian_ci;
228 Warnings:
229 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
230 SELECT @@session.collation_database;
231 @@session.collation_database
232 latin2_hungarian_ci
233 SET @@session.collation_database = latin2_croatian_ci;
234 Warnings:
235 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
236 SELECT @@session.collation_database;
237 @@session.collation_database
238 latin2_croatian_ci
239 SET @@session.collation_database = latin2_bin;
240 Warnings:
241 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
242 SELECT @@session.collation_database;
243 @@session.collation_database
244 latin2_bin
245 SET @@session.collation_database = swe7_swedish_ci;
246 Warnings:
247 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
248 SELECT @@session.collation_database;
249 @@session.collation_database
250 swe7_swedish_ci
251 SET @@session.collation_database = swe7_bin;
252 Warnings:
253 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
254 SELECT @@session.collation_database;
255 @@session.collation_database
256 swe7_bin
257 SET @@session.collation_database = ascii_general_ci;
258 Warnings:
259 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
260 SELECT @@session.collation_database;
261 @@session.collation_database
262 ascii_general_ci
263 SET @@session.collation_database = ascii_bin;
264 Warnings:
265 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
266 SELECT @@session.collation_database;
267 @@session.collation_database
268 ascii_bin
269 SET @@session.collation_database = ujis_japanese_ci;
270 Warnings:
271 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
272 SELECT @@session.collation_database;
273 @@session.collation_database
274 ujis_japanese_ci
275 SET @@session.collation_database = ujis_bin;
276 Warnings:
277 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
278 SELECT @@session.collation_database;
279 @@session.collation_database
280 ujis_bin
281 SET @@session.collation_database = sjis_japanese_ci;
282 Warnings:
283 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
284 SELECT @@session.collation_database;
285 @@session.collation_database
286 sjis_japanese_ci
287 SET @@session.collation_database = sjis_bin;
288 Warnings:
289 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
290 SELECT @@session.collation_database;
291 @@session.collation_database
292 sjis_bin
293 SET @@session.collation_database = hebrew_general_ci;
294 Warnings:
295 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
296 SELECT @@session.collation_database;
297 @@session.collation_database
298 hebrew_general_ci
299 SET @@session.collation_database = hebrew_bin;
300 Warnings:
301 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
302 SELECT @@session.collation_database;
303 @@session.collation_database
304 hebrew_bin
305 SET @@session.collation_database = tis620_thai_ci;
306 Warnings:
307 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
308 SELECT @@session.collation_database;
309 @@session.collation_database
310 tis620_thai_ci
311 SET @@session.collation_database = tis620_bin;
312 Warnings:
313 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
314 SELECT @@session.collation_database;
315 @@session.collation_database
316 tis620_bin
317 SET @@session.collation_database = euckr_korean_ci;
318 Warnings:
319 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
320 SELECT @@session.collation_database;
321 @@session.collation_database
322 euckr_korean_ci
323 SET @@session.collation_database = euckr_bin;
324 Warnings:
325 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
326 SELECT @@session.collation_database;
327 @@session.collation_database
328 euckr_bin
329 SET @@session.collation_database = koi8u_general_ci;
330 Warnings:
331 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
332 SELECT @@session.collation_database;
333 @@session.collation_database
334 koi8u_general_ci
335 SET @@session.collation_database = koi8u_bin;
336 Warnings:
337 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
338 SELECT @@session.collation_database;
339 @@session.collation_database
340 koi8u_bin
341 SET @@session.collation_database = gb2312_chinese_ci;
342 Warnings:
343 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
344 SELECT @@session.collation_database;
345 @@session.collation_database
346 gb2312_chinese_ci
347 SET @@session.collation_database = gb2312_bin;
348 Warnings:
349 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
350 SELECT @@session.collation_database;
351 @@session.collation_database
352 gb2312_bin
353 SET @@session.collation_database = greek_general_ci;
354 Warnings:
355 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
356 SELECT @@session.collation_database;
357 @@session.collation_database
358 greek_general_ci
359 SET @@session.collation_database = greek_bin;
360 Warnings:
361 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
362 SELECT @@session.collation_database;
363 @@session.collation_database
364 greek_bin
365 SET @@session.collation_database = cp1250_general_ci;
366 Warnings:
367 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
368 SELECT @@session.collation_database;
369 @@session.collation_database
370 cp1250_general_ci
371 SET @@session.collation_database = cp1250_czech_cs;
372 Warnings:
373 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
374 SELECT @@session.collation_database;
375 @@session.collation_database
376 cp1250_czech_cs
377 SET @@session.collation_database = cp1250_croatian_ci;
378 Warnings:
379 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
380 SELECT @@session.collation_database;
381 @@session.collation_database
382 cp1250_croatian_ci
383 SET @@session.collation_database = cp1250_bin;
384 Warnings:
385 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
386 SELECT @@session.collation_database;
387 @@session.collation_database
388 cp1250_bin
389 SET @@session.collation_database = cp1250_polish_ci;
390 Warnings:
391 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
392 SELECT @@session.collation_database;
393 @@session.collation_database
394 cp1250_polish_ci
395 SET @@session.collation_database = gbk_chinese_ci;
396 Warnings:
397 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
398 SELECT @@session.collation_database;
399 @@session.collation_database
400 gbk_chinese_ci
401 SET @@session.collation_database = gbk_bin;
402 Warnings:
403 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
404 SELECT @@session.collation_database;
405 @@session.collation_database
406 gbk_bin
407 SET @@session.collation_database = gb18030_chinese_ci;
408 Warnings:
409 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
410 SELECT @@session.collation_database;
411 @@session.collation_database
412 gb18030_chinese_ci
413 SET @@session.collation_database = gb18030_bin;
414 Warnings:
415 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
416 SELECT @@session.collation_database;
417 @@session.collation_database
418 gb18030_bin
419 SET @@session.collation_database = latin5_turkish_ci;
420 Warnings:
421 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
422 SELECT @@session.collation_database;
423 @@session.collation_database
424 latin5_turkish_ci
425 SET @@session.collation_database = latin5_bin;
426 Warnings:
427 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
428 SELECT @@session.collation_database;
429 @@session.collation_database
430 latin5_bin
431 SET @@session.collation_database = armscii8_general_ci;
432 Warnings:
433 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
434 SELECT @@session.collation_database;
435 @@session.collation_database
436 armscii8_general_ci
437 SET @@session.collation_database = armscii8_bin;
438 Warnings:
439 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
440 SELECT @@session.collation_database;
441 @@session.collation_database
442 armscii8_bin
443 SET @@session.collation_database = utf8_general_ci;
444 Warnings:
445 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
446 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
447 SELECT @@session.collation_database;
448 @@session.collation_database
449 utf8mb3_general_ci
450 SET @@session.collation_database = utf8_bin;
451 Warnings:
452 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
453 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
454 SELECT @@session.collation_database;
455 @@session.collation_database
456 utf8mb3_bin
457 SET @@session.collation_database = utf8_unicode_ci;
458 Warnings:
459 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
460 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
461 SELECT @@session.collation_database;
462 @@session.collation_database
463 utf8mb3_unicode_ci
464 SET @@session.collation_database = utf8_icelandic_ci;
465 Warnings:
466 Warning 3778 'utf8mb3_icelandic_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
467 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
468 SELECT @@session.collation_database;
469 @@session.collation_database
470 utf8mb3_icelandic_ci
471 SET @@session.collation_database = utf8_latvian_ci;
472 Warnings:
473 Warning 3778 'utf8mb3_latvian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
474 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
475 SELECT @@session.collation_database;
476 @@session.collation_database
477 utf8mb3_latvian_ci
478 SET @@session.collation_database = utf8_romanian_ci;
479 Warnings:
480 Warning 3778 'utf8mb3_romanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
481 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
482 SELECT @@session.collation_database;
483 @@session.collation_database
484 utf8mb3_romanian_ci
485 SET @@session.collation_database = utf8_slovenian_ci;
486 Warnings:
487 Warning 3778 'utf8mb3_slovenian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
488 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
489 SELECT @@session.collation_database;
490 @@session.collation_database
491 utf8mb3_slovenian_ci
492 SET @@session.collation_database = utf8_polish_ci;
493 Warnings:
494 Warning 3778 'utf8mb3_polish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
495 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
496 SELECT @@session.collation_database;
497 @@session.collation_database
498 utf8mb3_polish_ci
499 SET @@session.collation_database = utf8_estonian_ci;
500 Warnings:
501 Warning 3778 'utf8mb3_estonian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
502 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
503 SELECT @@session.collation_database;
504 @@session.collation_database
505 utf8mb3_estonian_ci
506 SET @@session.collation_database = utf8_spanish_ci;
507 Warnings:
508 Warning 3778 'utf8mb3_spanish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
509 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
510 SELECT @@session.collation_database;
511 @@session.collation_database
512 utf8mb3_spanish_ci
513 SET @@session.collation_database = utf8_swedish_ci;
514 Warnings:
515 Warning 3778 'utf8mb3_swedish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
516 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
517 SELECT @@session.collation_database;
518 @@session.collation_database
519 utf8mb3_swedish_ci
520 SET @@session.collation_database = utf8_turkish_ci;
521 Warnings:
522 Warning 3778 'utf8mb3_turkish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
523 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
524 SELECT @@session.collation_database;
525 @@session.collation_database
526 utf8mb3_turkish_ci
527 SET @@session.collation_database = utf8_czech_ci;
528 Warnings:
529 Warning 3778 'utf8mb3_czech_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
530 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
531 SELECT @@session.collation_database;
532 @@session.collation_database
533 utf8mb3_czech_ci
534 SET @@session.collation_database = utf8_danish_ci;
535 Warnings:
536 Warning 3778 'utf8mb3_danish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
537 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
538 SELECT @@session.collation_database;
539 @@session.collation_database
540 utf8mb3_danish_ci
541 SET @@session.collation_database = utf8_lithuanian_ci;
542 Warnings:
543 Warning 3778 'utf8mb3_lithuanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
544 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
545 SELECT @@session.collation_database;
546 @@session.collation_database
547 utf8mb3_lithuanian_ci
548 SET @@session.collation_database = utf8_slovak_ci;
549 Warnings:
550 Warning 3778 'utf8mb3_slovak_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
551 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
552 SELECT @@session.collation_database;
553 @@session.collation_database
554 utf8mb3_slovak_ci
555 SET @@session.collation_database = utf8_spanish2_ci;
556 Warnings:
557 Warning 3778 'utf8mb3_spanish2_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
558 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
559 SELECT @@session.collation_database;
560 @@session.collation_database
561 utf8mb3_spanish2_ci
562 SET @@session.collation_database = utf8_roman_ci;
563 Warnings:
564 Warning 3778 'utf8mb3_roman_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
565 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
566 SELECT @@session.collation_database;
567 @@session.collation_database
568 utf8mb3_roman_ci
569 SET @@session.collation_database = utf8_persian_ci;
570 Warnings:
571 Warning 3778 'utf8mb3_persian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
572 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
573 SELECT @@session.collation_database;
574 @@session.collation_database
575 utf8mb3_persian_ci
576 SET @@session.collation_database = utf8_esperanto_ci;
577 Warnings:
578 Warning 3778 'utf8mb3_esperanto_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
579 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
580 SELECT @@session.collation_database;
581 @@session.collation_database
582 utf8mb3_esperanto_ci
583 SET @@session.collation_database = utf8_hungarian_ci;
584 Warnings:
585 Warning 3778 'utf8mb3_hungarian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
586 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
587 SELECT @@session.collation_database;
588 @@session.collation_database
589 utf8mb3_hungarian_ci
590 SET @@session.collation_database = utf8_unicode_520_ci;
591 Warnings:
592 Warning 3778 'utf8mb3_unicode_520_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
593 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
594 SELECT @@session.collation_database;
595 @@session.collation_database
596 utf8mb3_unicode_520_ci
597 SET @@session.collation_database = ucs2_general_ci;
598 Warnings:
599 Warning 4079 'ucs2_general_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
600 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
601 SELECT @@session.collation_database;
602 @@session.collation_database
603 ucs2_general_ci
604 SET @@session.collation_database = ucs2_bin;
605 Warnings:
606 Warning 4079 'ucs2_bin' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
607 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
608 SELECT @@session.collation_database;
609 @@session.collation_database
610 ucs2_bin
611 SET @@session.collation_database = ucs2_unicode_ci;
612 Warnings:
613 Warning 4079 'ucs2_unicode_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
614 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
615 SELECT @@session.collation_database;
616 @@session.collation_database
617 ucs2_unicode_ci
618 SET @@session.collation_database = ucs2_icelandic_ci;
619 Warnings:
620 Warning 4079 'ucs2_icelandic_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
621 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
622 SELECT @@session.collation_database;
623 @@session.collation_database
624 ucs2_icelandic_ci
625 SET @@session.collation_database = ucs2_latvian_ci;
626 Warnings:
627 Warning 4079 'ucs2_latvian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
628 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
629 SELECT @@session.collation_database;
630 @@session.collation_database
631 ucs2_latvian_ci
632 SET @@session.collation_database = ucs2_romanian_ci;
633 Warnings:
634 Warning 4079 'ucs2_romanian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
635 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
636 SELECT @@session.collation_database;
637 @@session.collation_database
638 ucs2_romanian_ci
639 SET @@session.collation_database = ucs2_slovenian_ci;
640 Warnings:
641 Warning 4079 'ucs2_slovenian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
642 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
643 SELECT @@session.collation_database;
644 @@session.collation_database
645 ucs2_slovenian_ci
646 SET @@session.collation_database = ucs2_polish_ci;
647 Warnings:
648 Warning 4079 'ucs2_polish_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
649 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
650 SELECT @@session.collation_database;
651 @@session.collation_database
652 ucs2_polish_ci
653 SET @@session.collation_database = ucs2_estonian_ci;
654 Warnings:
655 Warning 4079 'ucs2_estonian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
656 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
657 SELECT @@session.collation_database;
658 @@session.collation_database
659 ucs2_estonian_ci
660 SET @@session.collation_database = ucs2_spanish_ci;
661 Warnings:
662 Warning 4079 'ucs2_spanish_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
663 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
664 SELECT @@session.collation_database;
665 @@session.collation_database
666 ucs2_spanish_ci
667 SET @@session.collation_database = ucs2_swedish_ci;
668 Warnings:
669 Warning 4079 'ucs2_swedish_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
670 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
671 SELECT @@session.collation_database;
672 @@session.collation_database
673 ucs2_swedish_ci
674 SET @@session.collation_database = ucs2_turkish_ci;
675 Warnings:
676 Warning 4079 'ucs2_turkish_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
677 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
678 SELECT @@session.collation_database;
679 @@session.collation_database
680 ucs2_turkish_ci
681 SET @@session.collation_database = ucs2_czech_ci;
682 Warnings:
683 Warning 4079 'ucs2_czech_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
684 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
685 SELECT @@session.collation_database;
686 @@session.collation_database
687 ucs2_czech_ci
688 SET @@session.collation_database = ucs2_danish_ci;
689 Warnings:
690 Warning 4079 'ucs2_danish_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
691 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
692 SELECT @@session.collation_database;
693 @@session.collation_database
694 ucs2_danish_ci
695 SET @@session.collation_database = ucs2_lithuanian_ci;
696 Warnings:
697 Warning 4079 'ucs2_lithuanian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
698 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
699 SELECT @@session.collation_database;
700 @@session.collation_database
701 ucs2_lithuanian_ci
702 SET @@session.collation_database = ucs2_slovak_ci;
703 Warnings:
704 Warning 4079 'ucs2_slovak_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
705 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
706 SELECT @@session.collation_database;
707 @@session.collation_database
708 ucs2_slovak_ci
709 SET @@session.collation_database = ucs2_spanish2_ci;
710 Warnings:
711 Warning 4079 'ucs2_spanish2_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
712 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
713 SELECT @@session.collation_database;
714 @@session.collation_database
715 ucs2_spanish2_ci
716 SET @@session.collation_database = ucs2_roman_ci;
717 Warnings:
718 Warning 4079 'ucs2_roman_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
719 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
720 SELECT @@session.collation_database;
721 @@session.collation_database
722 ucs2_roman_ci
723 SET @@session.collation_database = ucs2_persian_ci;
724 Warnings:
725 Warning 4079 'ucs2_persian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
726 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
727 SELECT @@session.collation_database;
728 @@session.collation_database
729 ucs2_persian_ci
730 SET @@session.collation_database = ucs2_esperanto_ci;
731 Warnings:
732 Warning 4079 'ucs2_esperanto_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
733 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
734 SELECT @@session.collation_database;
735 @@session.collation_database
736 ucs2_esperanto_ci
737 SET @@session.collation_database = ucs2_hungarian_ci;
738 Warnings:
739 Warning 4079 'ucs2_hungarian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
740 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
741 SELECT @@session.collation_database;
742 @@session.collation_database
743 ucs2_hungarian_ci
744 SET @@session.collation_database = ucs2_unicode_520_ci;
745 Warnings:
746 Warning 4079 'ucs2_unicode_520_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
747 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
748 SELECT @@session.collation_database;
749 @@session.collation_database
750 ucs2_unicode_520_ci
751 SET @@session.collation_database = cp866_general_ci;
752 Warnings:
753 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
754 SELECT @@session.collation_database;
755 @@session.collation_database
756 cp866_general_ci
757 SET @@session.collation_database = cp866_bin;
758 Warnings:
759 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
760 SELECT @@session.collation_database;
761 @@session.collation_database
762 cp866_bin
763 SET @@session.collation_database = keybcs2_general_ci;
764 Warnings:
765 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
766 SELECT @@session.collation_database;
767 @@session.collation_database
768 keybcs2_general_ci
769 SET @@session.collation_database = keybcs2_bin;
770 Warnings:
771 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
772 SELECT @@session.collation_database;
773 @@session.collation_database
774 keybcs2_bin
775 SET @@session.collation_database = macce_general_ci;
776 Warnings:
777 Warning 4079 'macce_general_ci' is a collation of the deprecated character set macce. Please consider using utf8mb4 with an appropriate collation instead.
778 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
779 SELECT @@session.collation_database;
780 @@session.collation_database
781 macce_general_ci
782 SET @@session.collation_database = macce_bin;
783 Warnings:
784 Warning 4079 'macce_bin' is a collation of the deprecated character set macce. Please consider using utf8mb4 with an appropriate collation instead.
785 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
786 SELECT @@session.collation_database;
787 @@session.collation_database
788 macce_bin
789 SET @@session.collation_database = macroman_general_ci;
790 Warnings:
791 Warning 4079 'macroman_general_ci' is a collation of the deprecated character set macroman. Please consider using utf8mb4 with an appropriate collation instead.
792 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
793 SELECT @@session.collation_database;
794 @@session.collation_database
795 macroman_general_ci
796 SET @@session.collation_database = macroman_bin;
797 Warnings:
798 Warning 4079 'macroman_bin' is a collation of the deprecated character set macroman. Please consider using utf8mb4 with an appropriate collation instead.
799 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
800 SELECT @@session.collation_database;
801 @@session.collation_database
802 macroman_bin
803 SET @@session.collation_database = cp852_general_ci;
804 Warnings:
805 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
806 SELECT @@session.collation_database;
807 @@session.collation_database
808 cp852_general_ci
809 SET @@session.collation_database = cp852_bin;
810 Warnings:
811 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
812 SELECT @@session.collation_database;
813 @@session.collation_database
814 cp852_bin
815 SET @@session.collation_database = latin7_estonian_cs;
816 Warnings:
817 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
818 SELECT @@session.collation_database;
819 @@session.collation_database
820 latin7_estonian_cs
821 SET @@session.collation_database = latin7_general_ci;
822 Warnings:
823 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
824 SELECT @@session.collation_database;
825 @@session.collation_database
826 latin7_general_ci
827 SET @@session.collation_database = latin7_general_cs;
828 Warnings:
829 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
830 SELECT @@session.collation_database;
831 @@session.collation_database
832 latin7_general_cs
833 SET @@session.collation_database = latin7_bin;
834 Warnings:
835 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
836 SELECT @@session.collation_database;
837 @@session.collation_database
838 latin7_bin
839 SET @@session.collation_database = cp1251_bulgarian_ci;
840 Warnings:
841 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
842 SELECT @@session.collation_database;
843 @@session.collation_database
844 cp1251_bulgarian_ci
845 SET @@session.collation_database = cp1251_ukrainian_ci;
846 Warnings:
847 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
848 SELECT @@session.collation_database;
849 @@session.collation_database
850 cp1251_ukrainian_ci
851 SET @@session.collation_database = cp1251_bin;
852 Warnings:
853 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
854 SELECT @@session.collation_database;
855 @@session.collation_database
856 cp1251_bin
857 SET @@session.collation_database = cp1251_general_ci;
858 Warnings:
859 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
860 SELECT @@session.collation_database;
861 @@session.collation_database
862 cp1251_general_ci
863 SET @@session.collation_database = cp1251_general_cs;
864 Warnings:
865 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
866 SELECT @@session.collation_database;
867 @@session.collation_database
868 cp1251_general_cs
869 SET @@session.collation_database = cp1256_general_ci;
870 Warnings:
871 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
872 SELECT @@session.collation_database;
873 @@session.collation_database
874 cp1256_general_ci
875 SET @@session.collation_database = cp1256_bin;
876 Warnings:
877 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
878 SELECT @@session.collation_database;
879 @@session.collation_database
880 cp1256_bin
881 SET @@session.collation_database = cp1257_lithuanian_ci;
882 Warnings:
883 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
884 SELECT @@session.collation_database;
885 @@session.collation_database
886 cp1257_lithuanian_ci
887 SET @@session.collation_database = cp1257_bin;
888 Warnings:
889 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
890 SELECT @@session.collation_database;
891 @@session.collation_database
892 cp1257_bin
893 SET @@session.collation_database = cp1257_general_ci;
894 Warnings:
895 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
896 SELECT @@session.collation_database;
897 @@session.collation_database
898 cp1257_general_ci
899 SET @@session.collation_database = binary;
900 Warnings:
901 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
902 SELECT @@session.collation_database;
903 @@session.collation_database
904 binary
905 SET @@session.collation_database = geostd8_general_ci;
906 Warnings:
907 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
908 SELECT @@session.collation_database;
909 @@session.collation_database
910 geostd8_general_ci
911 SET @@session.collation_database = geostd8_bin;
912 Warnings:
913 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
914 SELECT @@session.collation_database;
915 @@session.collation_database
916 geostd8_bin
917 SET @@session.collation_database = cp932_japanese_ci;
918 Warnings:
919 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
920 SELECT @@session.collation_database;
921 @@session.collation_database
922 cp932_japanese_ci
923 SET @@session.collation_database = cp932_bin;
924 Warnings:
925 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
926 SELECT @@session.collation_database;
927 @@session.collation_database
928 cp932_bin
929 SET @@session.collation_database = eucjpms_japanese_ci;
930 Warnings:
931 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
932 SELECT @@session.collation_database;
933 @@session.collation_database
934 eucjpms_japanese_ci
935 SET @@session.collation_database = eucjpms_bin;
936 Warnings:
937 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
938 SELECT @@session.collation_database;
939 @@session.collation_database
940 eucjpms_bin
941 SET @@session.collation_database = utf8mb4_0900_ai_ci;
942 Warnings:
943 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
944 SELECT @@session.collation_database;
945 @@session.collation_database
946 utf8mb4_0900_ai_ci
947 '#--------------------FN_DYNVARS_016_07-------------------------#'
948 SET @@global.collation_database = big5_chinese_ci;
949 Warnings:
950 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
951 SELECT @@global.collation_database;
952 @@global.collation_database
953 big5_chinese_ci
954 SET @@global.collation_database = big5_bin;
955 Warnings:
956 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
957 SELECT @@global.collation_database;
958 @@global.collation_database
959 big5_bin
960 SET @@global.collation_database = dec8_swedish_ci;
961 Warnings:
962 Warning 4079 'dec8_swedish_ci' is a collation of the deprecated character set dec8. Please consider using utf8mb4 with an appropriate collation instead.
963 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
964 SELECT @@global.collation_database;
965 @@global.collation_database
966 dec8_swedish_ci
967 SET @@global.collation_database = dec8_bin;
968 Warnings:
969 Warning 4079 'dec8_bin' is a collation of the deprecated character set dec8. Please consider using utf8mb4 with an appropriate collation instead.
970 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
971 SELECT @@global.collation_database;
972 @@global.collation_database
973 dec8_bin
974 SET @@global.collation_database = cp850_general_ci;
975 Warnings:
976 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
977 SELECT @@global.collation_database;
978 @@global.collation_database
979 cp850_general_ci
980 SET @@global.collation_database = cp850_bin;
981 Warnings:
982 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
983 SELECT @@global.collation_database;
984 @@global.collation_database
985 cp850_bin
986 SET @@global.collation_database = hp8_english_ci;
987 Warnings:
988 Warning 4079 'hp8_english_ci' is a collation of the deprecated character set hp8. Please consider using utf8mb4 with an appropriate collation instead.
989 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
990 SELECT @@global.collation_database;
991 @@global.collation_database
992 hp8_english_ci
993 SET @@global.collation_database = hp8_bin;
994 Warnings:
995 Warning 4079 'hp8_bin' is a collation of the deprecated character set hp8. Please consider using utf8mb4 with an appropriate collation instead.
996 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
997 SELECT @@global.collation_database;
998 @@global.collation_database
999 hp8_bin
1000 SET @@global.collation_database = koi8r_general_ci;
1001 Warnings:
1002 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1003 SELECT @@global.collation_database;
1004 @@global.collation_database
1005 koi8r_general_ci
1006 SET @@global.collation_database = koi8r_bin;
1007 Warnings:
1008 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1009 SELECT @@global.collation_database;
1010 @@global.collation_database
1011 koi8r_bin
1012 SET @@global.collation_database = latin1_german1_ci;
1013 Warnings:
1014 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1015 SELECT @@global.collation_database;
1016 @@global.collation_database
1017 latin1_german1_ci
1018 SET @@global.collation_database = latin1_swedish_ci;
1019 Warnings:
1020 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1021 SELECT @@global.collation_database;
1022 @@global.collation_database
1023 latin1_swedish_ci
1024 SET @@global.collation_database = latin1_danish_ci;
1025 Warnings:
1026 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1027 SELECT @@global.collation_database;
1028 @@global.collation_database
1029 latin1_danish_ci
1030 SET @@global.collation_database = latin1_german2_ci;
1031 Warnings:
1032 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1033 SELECT @@global.collation_database;
1034 @@global.collation_database
1035 latin1_german2_ci
1036 SET @@global.collation_database = latin1_bin;
1037 Warnings:
1038 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1039 SELECT @@global.collation_database;
1040 @@global.collation_database
1041 latin1_bin
1042 SET @@global.collation_database = latin1_general_ci;
1043 Warnings:
1044 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1045 SELECT @@global.collation_database;
1046 @@global.collation_database
1047 latin1_general_ci
1048 SET @@global.collation_database = latin1_general_cs;
1049 Warnings:
1050 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1051 SELECT @@global.collation_database;
1052 @@global.collation_database
1053 latin1_general_cs
1054 SET @@global.collation_database = latin1_spanish_ci;
1055 Warnings:
1056 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1057 SELECT @@global.collation_database;
1058 @@global.collation_database
1059 latin1_spanish_ci
1060 SET @@global.collation_database = latin2_czech_cs;
1061 Warnings:
1062 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1063 SELECT @@global.collation_database;
1064 @@global.collation_database
1065 latin2_czech_cs
1066 SET @@global.collation_database = latin2_general_ci;
1067 Warnings:
1068 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1069 SELECT @@global.collation_database;
1070 @@global.collation_database
1071 latin2_general_ci
1072 SET @@global.collation_database = latin2_hungarian_ci;
1073 Warnings:
1074 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1075 SELECT @@global.collation_database;
1076 @@global.collation_database
1077 latin2_hungarian_ci
1078 SET @@global.collation_database = latin2_croatian_ci;
1079 Warnings:
1080 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1081 SELECT @@global.collation_database;
1082 @@global.collation_database
1083 latin2_croatian_ci
1084 SET @@global.collation_database = latin2_bin;
1085 Warnings:
1086 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1087 SELECT @@global.collation_database;
1088 @@global.collation_database
1089 latin2_bin
1090 SET @@global.collation_database = swe7_swedish_ci;
1091 Warnings:
1092 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1093 SELECT @@global.collation_database;
1094 @@global.collation_database
1095 swe7_swedish_ci
1096 SET @@global.collation_database = swe7_bin;
1097 Warnings:
1098 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1099 SELECT @@global.collation_database;
1100 @@global.collation_database
1101 swe7_bin
1102 SET @@global.collation_database = ascii_general_ci;
1103 Warnings:
1104 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1105 SELECT @@global.collation_database;
1106 @@global.collation_database
1107 ascii_general_ci
1108 SET @@global.collation_database = ascii_bin;
1109 Warnings:
1110 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1111 SELECT @@global.collation_database;
1112 @@global.collation_database
1113 ascii_bin
1114 SET @@global.collation_database = ujis_japanese_ci;
1115 Warnings:
1116 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1117 SELECT @@global.collation_database;
1118 @@global.collation_database
1119 ujis_japanese_ci
1120 SET @@global.collation_database = ujis_bin;
1121 Warnings:
1122 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1123 SELECT @@global.collation_database;
1124 @@global.collation_database
1125 ujis_bin
1126 SET @@global.collation_database = sjis_japanese_ci;
1127 Warnings:
1128 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1129 SELECT @@global.collation_database;
1130 @@global.collation_database
1131 sjis_japanese_ci
1132 SET @@global.collation_database = sjis_bin;
1133 Warnings:
1134 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1135 SELECT @@global.collation_database;
1136 @@global.collation_database
1137 sjis_bin
1138 SET @@global.collation_database = hebrew_general_ci;
1139 Warnings:
1140 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1141 SELECT @@global.collation_database;
1142 @@global.collation_database
1143 hebrew_general_ci
1144 SET @@global.collation_database = hebrew_bin;
1145 Warnings:
1146 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1147 SELECT @@global.collation_database;
1148 @@global.collation_database
1149 hebrew_bin
1150 SET @@global.collation_database = tis620_thai_ci;
1151 Warnings:
1152 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1153 SELECT @@global.collation_database;
1154 @@global.collation_database
1155 tis620_thai_ci
1156 SET @@global.collation_database = tis620_bin;
1157 Warnings:
1158 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1159 SELECT @@global.collation_database;
1160 @@global.collation_database
1161 tis620_bin
1162 SET @@global.collation_database = euckr_korean_ci;
1163 Warnings:
1164 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1165 SELECT @@global.collation_database;
1166 @@global.collation_database
1167 euckr_korean_ci
1168 SET @@global.collation_database = euckr_bin;
1169 Warnings:
1170 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1171 SELECT @@global.collation_database;
1172 @@global.collation_database
1173 euckr_bin
1174 SET @@global.collation_database = koi8u_general_ci;
1175 Warnings:
1176 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1177 SELECT @@global.collation_database;
1178 @@global.collation_database
1179 koi8u_general_ci
1180 SET @@global.collation_database = koi8u_bin;
1181 Warnings:
1182 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1183 SELECT @@global.collation_database;
1184 @@global.collation_database
1185 koi8u_bin
1186 SET @@global.collation_database = gb2312_chinese_ci;
1187 Warnings:
1188 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1189 SELECT @@global.collation_database;
1190 @@global.collation_database
1191 gb2312_chinese_ci
1192 SET @@global.collation_database = gb2312_bin;
1193 Warnings:
1194 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1195 SELECT @@global.collation_database;
1196 @@global.collation_database
1197 gb2312_bin
1198 SET @@global.collation_database = greek_general_ci;
1199 Warnings:
1200 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1201 SELECT @@global.collation_database;
1202 @@global.collation_database
1203 greek_general_ci
1204 SET @@global.collation_database = greek_bin;
1205 Warnings:
1206 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1207 SELECT @@global.collation_database;
1208 @@global.collation_database
1209 greek_bin
1210 SET @@global.collation_database = cp1250_general_ci;
1211 Warnings:
1212 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1213 SELECT @@global.collation_database;
1214 @@global.collation_database
1215 cp1250_general_ci
1216 SET @@global.collation_database = cp1250_czech_cs;
1217 Warnings:
1218 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1219 SELECT @@global.collation_database;
1220 @@global.collation_database
1221 cp1250_czech_cs
1222 SET @@global.collation_database = cp1250_croatian_ci;
1223 Warnings:
1224 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1225 SELECT @@global.collation_database;
1226 @@global.collation_database
1227 cp1250_croatian_ci
1228 SET @@global.collation_database = cp1250_bin;
1229 Warnings:
1230 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1231 SELECT @@global.collation_database;
1232 @@global.collation_database
1233 cp1250_bin
1234 SET @@global.collation_database = cp1250_polish_ci;
1235 Warnings:
1236 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1237 SELECT @@global.collation_database;
1238 @@global.collation_database
1239 cp1250_polish_ci
1240 SET @@global.collation_database = gbk_chinese_ci;
1241 Warnings:
1242 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1243 SELECT @@global.collation_database;
1244 @@global.collation_database
1245 gbk_chinese_ci
1246 SET @@global.collation_database = gbk_bin;
1247 Warnings:
1248 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1249 SELECT @@global.collation_database;
1250 @@global.collation_database
1251 gbk_bin
1252 SET @@global.collation_database = gb18030_chinese_ci;
1253 Warnings:
1254 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1255 SELECT @@global.collation_database;
1256 @@global.collation_database
1257 gb18030_chinese_ci
1258 SET @@global.collation_database = gb18030_bin;
1259 Warnings:
1260 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1261 SELECT @@global.collation_database;
1262 @@global.collation_database
1263 gb18030_bin
1264 SET @@global.collation_database = latin5_turkish_ci;
1265 Warnings:
1266 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1267 SELECT @@global.collation_database;
1268 @@global.collation_database
1269 latin5_turkish_ci
1270 SET @@global.collation_database = latin5_bin;
1271 Warnings:
1272 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1273 SELECT @@global.collation_database;
1274 @@global.collation_database
1275 latin5_bin
1276 SET @@global.collation_database = armscii8_general_ci;
1277 Warnings:
1278 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1279 SELECT @@global.collation_database;
1280 @@global.collation_database
1281 armscii8_general_ci
1282 SET @@global.collation_database = armscii8_bin;
1283 Warnings:
1284 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1285 SELECT @@global.collation_database;
1286 @@global.collation_database
1287 armscii8_bin
1288 SET @@global.collation_database = utf8_general_ci;
1289 Warnings:
1290 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1291 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1292 SELECT @@global.collation_database;
1293 @@global.collation_database
1294 utf8mb3_general_ci
1295 SET @@global.collation_database = utf8_bin;
1296 Warnings:
1297 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1298 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1299 SELECT @@global.collation_database;
1300 @@global.collation_database
1301 utf8mb3_bin
1302 SET @@global.collation_database = utf8_unicode_ci;
1303 Warnings:
1304 Warning 3778 'utf8mb3_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1305 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1306 SELECT @@global.collation_database;
1307 @@global.collation_database
1308 utf8mb3_unicode_ci
1309 SET @@global.collation_database = utf8_icelandic_ci;
1310 Warnings:
1311 Warning 3778 'utf8mb3_icelandic_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1312 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1313 SELECT @@global.collation_database;
1314 @@global.collation_database
1315 utf8mb3_icelandic_ci
1316 SET @@global.collation_database = utf8_latvian_ci;
1317 Warnings:
1318 Warning 3778 'utf8mb3_latvian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1319 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1320 SELECT @@global.collation_database;
1321 @@global.collation_database
1322 utf8mb3_latvian_ci
1323 SET @@global.collation_database = utf8_romanian_ci;
1324 Warnings:
1325 Warning 3778 'utf8mb3_romanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1326 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1327 SELECT @@global.collation_database;
1328 @@global.collation_database
1329 utf8mb3_romanian_ci
1330 SET @@global.collation_database = utf8_slovenian_ci;
1331 Warnings:
1332 Warning 3778 'utf8mb3_slovenian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1333 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1334 SELECT @@global.collation_database;
1335 @@global.collation_database
1336 utf8mb3_slovenian_ci
1337 SET @@global.collation_database = utf8_polish_ci;
1338 Warnings:
1339 Warning 3778 'utf8mb3_polish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1340 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1341 SELECT @@global.collation_database;
1342 @@global.collation_database
1343 utf8mb3_polish_ci
1344 SET @@global.collation_database = utf8_estonian_ci;
1345 Warnings:
1346 Warning 3778 'utf8mb3_estonian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1347 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1348 SELECT @@global.collation_database;
1349 @@global.collation_database
1350 utf8mb3_estonian_ci
1351 SET @@global.collation_database = utf8_spanish_ci;
1352 Warnings:
1353 Warning 3778 'utf8mb3_spanish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1354 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1355 SELECT @@global.collation_database;
1356 @@global.collation_database
1357 utf8mb3_spanish_ci
1358 SET @@global.collation_database = utf8_swedish_ci;
1359 Warnings:
1360 Warning 3778 'utf8mb3_swedish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1361 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1362 SELECT @@global.collation_database;
1363 @@global.collation_database
1364 utf8mb3_swedish_ci
1365 SET @@global.collation_database = utf8_turkish_ci;
1366 Warnings:
1367 Warning 3778 'utf8mb3_turkish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1368 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1369 SELECT @@global.collation_database;
1370 @@global.collation_database
1371 utf8mb3_turkish_ci
1372 SET @@global.collation_database = utf8_czech_ci;
1373 Warnings:
1374 Warning 3778 'utf8mb3_czech_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1375 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1376 SELECT @@global.collation_database;
1377 @@global.collation_database
1378 utf8mb3_czech_ci
1379 SET @@global.collation_database = utf8_danish_ci;
1380 Warnings:
1381 Warning 3778 'utf8mb3_danish_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1382 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1383 SELECT @@global.collation_database;
1384 @@global.collation_database
1385 utf8mb3_danish_ci
1386 SET @@global.collation_database = utf8_lithuanian_ci;
1387 Warnings:
1388 Warning 3778 'utf8mb3_lithuanian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1389 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1390 SELECT @@global.collation_database;
1391 @@global.collation_database
1392 utf8mb3_lithuanian_ci
1393 SET @@global.collation_database = utf8_slovak_ci;
1394 Warnings:
1395 Warning 3778 'utf8mb3_slovak_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1396 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1397 SELECT @@global.collation_database;
1398 @@global.collation_database
1399 utf8mb3_slovak_ci
1400 SET @@global.collation_database = utf8_spanish2_ci;
1401 Warnings:
1402 Warning 3778 'utf8mb3_spanish2_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1403 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1404 SELECT @@global.collation_database;
1405 @@global.collation_database
1406 utf8mb3_spanish2_ci
1407 SET @@global.collation_database = utf8_roman_ci;
1408 Warnings:
1409 Warning 3778 'utf8mb3_roman_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1410 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1411 SELECT @@global.collation_database;
1412 @@global.collation_database
1413 utf8mb3_roman_ci
1414 SET @@global.collation_database = utf8_persian_ci;
1415 Warnings:
1416 Warning 3778 'utf8mb3_persian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1417 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1418 SELECT @@global.collation_database;
1419 @@global.collation_database
1420 utf8mb3_persian_ci
1421 SET @@global.collation_database = utf8_esperanto_ci;
1422 Warnings:
1423 Warning 3778 'utf8mb3_esperanto_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1424 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1425 SELECT @@global.collation_database;
1426 @@global.collation_database
1427 utf8mb3_esperanto_ci
1428 SET @@global.collation_database = utf8_hungarian_ci;
1429 Warnings:
1430 Warning 3778 'utf8mb3_hungarian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1431 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1432 SELECT @@global.collation_database;
1433 @@global.collation_database
1434 utf8mb3_hungarian_ci
1435 SET @@global.collation_database = utf8_unicode_520_ci;
1436 Warnings:
1437 Warning 3778 'utf8mb3_unicode_520_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
1438 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1439 SELECT @@global.collation_database;
1440 @@global.collation_database
1441 utf8mb3_unicode_520_ci
1442 SET @@global.collation_database = ucs2_general_ci;
1443 Warnings:
1444 Warning 4079 'ucs2_general_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1445 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1446 SELECT @@global.collation_database;
1447 @@global.collation_database
1448 ucs2_general_ci
1449 SET @@global.collation_database = ucs2_bin;
1450 Warnings:
1451 Warning 4079 'ucs2_bin' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1452 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1453 SELECT @@global.collation_database;
1454 @@global.collation_database
1455 ucs2_bin
1456 SET @@global.collation_database = ucs2_unicode_ci;
1457 Warnings:
1458 Warning 4079 'ucs2_unicode_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1459 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1460 SELECT @@global.collation_database;
1461 @@global.collation_database
1462 ucs2_unicode_ci
1463 SET @@global.collation_database = ucs2_icelandic_ci;
1464 Warnings:
1465 Warning 4079 'ucs2_icelandic_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1466 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1467 SELECT @@global.collation_database;
1468 @@global.collation_database
1469 ucs2_icelandic_ci
1470 SET @@global.collation_database = ucs2_latvian_ci;
1471 Warnings:
1472 Warning 4079 'ucs2_latvian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1473 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1474 SELECT @@global.collation_database;
1475 @@global.collation_database
1476 ucs2_latvian_ci
1477 SET @@global.collation_database = ucs2_romanian_ci;
1478 Warnings:
1479 Warning 4079 'ucs2_romanian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1480 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1481 SELECT @@global.collation_database;
1482 @@global.collation_database
1483 ucs2_romanian_ci
1484 SET @@global.collation_database = ucs2_slovenian_ci;
1485 Warnings:
1486 Warning 4079 'ucs2_slovenian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1487 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1488 SELECT @@global.collation_database;
1489 @@global.collation_database
1490 ucs2_slovenian_ci
1491 SET @@global.collation_database = ucs2_polish_ci;
1492 Warnings:
1493 Warning 4079 'ucs2_polish_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1494 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1495 SELECT @@global.collation_database;
1496 @@global.collation_database
1497 ucs2_polish_ci
1498 SET @@global.collation_database = ucs2_estonian_ci;
1499 Warnings:
1500 Warning 4079 'ucs2_estonian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1501 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1502 SELECT @@global.collation_database;
1503 @@global.collation_database
1504 ucs2_estonian_ci
1505 SET @@global.collation_database = ucs2_spanish_ci;
1506 Warnings:
1507 Warning 4079 'ucs2_spanish_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1508 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1509 SELECT @@global.collation_database;
1510 @@global.collation_database
1511 ucs2_spanish_ci
1512 SET @@global.collation_database = ucs2_swedish_ci;
1513 Warnings:
1514 Warning 4079 'ucs2_swedish_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1515 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1516 SELECT @@global.collation_database;
1517 @@global.collation_database
1518 ucs2_swedish_ci
1519 SET @@global.collation_database = ucs2_turkish_ci;
1520 Warnings:
1521 Warning 4079 'ucs2_turkish_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1522 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1523 SELECT @@global.collation_database;
1524 @@global.collation_database
1525 ucs2_turkish_ci
1526 SET @@global.collation_database = ucs2_czech_ci;
1527 Warnings:
1528 Warning 4079 'ucs2_czech_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1529 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1530 SELECT @@global.collation_database;
1531 @@global.collation_database
1532 ucs2_czech_ci
1533 SET @@global.collation_database = ucs2_danish_ci;
1534 Warnings:
1535 Warning 4079 'ucs2_danish_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1536 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1537 SELECT @@global.collation_database;
1538 @@global.collation_database
1539 ucs2_danish_ci
1540 SET @@global.collation_database = ucs2_lithuanian_ci;
1541 Warnings:
1542 Warning 4079 'ucs2_lithuanian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1543 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1544 SELECT @@global.collation_database;
1545 @@global.collation_database
1546 ucs2_lithuanian_ci
1547 SET @@global.collation_database = ucs2_slovak_ci;
1548 Warnings:
1549 Warning 4079 'ucs2_slovak_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1550 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1551 SELECT @@global.collation_database;
1552 @@global.collation_database
1553 ucs2_slovak_ci
1554 SET @@global.collation_database = ucs2_spanish2_ci;
1555 Warnings:
1556 Warning 4079 'ucs2_spanish2_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1557 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1558 SELECT @@global.collation_database;
1559 @@global.collation_database
1560 ucs2_spanish2_ci
1561 SET @@global.collation_database = ucs2_roman_ci;
1562 Warnings:
1563 Warning 4079 'ucs2_roman_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1564 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1565 SELECT @@global.collation_database;
1566 @@global.collation_database
1567 ucs2_roman_ci
1568 SET @@global.collation_database = ucs2_persian_ci;
1569 Warnings:
1570 Warning 4079 'ucs2_persian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1571 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1572 SELECT @@global.collation_database;
1573 @@global.collation_database
1574 ucs2_persian_ci
1575 SET @@global.collation_database = ucs2_esperanto_ci;
1576 Warnings:
1577 Warning 4079 'ucs2_esperanto_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1578 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1579 SELECT @@global.collation_database;
1580 @@global.collation_database
1581 ucs2_esperanto_ci
1582 SET @@global.collation_database = ucs2_hungarian_ci;
1583 Warnings:
1584 Warning 4079 'ucs2_hungarian_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1585 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1586 SELECT @@global.collation_database;
1587 @@global.collation_database
1588 ucs2_hungarian_ci
1589 SET @@global.collation_database = ucs2_unicode_520_ci;
1590 Warnings:
1591 Warning 4079 'ucs2_unicode_520_ci' is a collation of the deprecated character set ucs2. Please consider using utf8mb4 with an appropriate collation instead.
1592 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1593 SELECT @@global.collation_database;
1594 @@global.collation_database
1595 ucs2_unicode_520_ci
1596 SET @@global.collation_database = cp866_general_ci;
1597 Warnings:
1598 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1599 SELECT @@global.collation_database;
1600 @@global.collation_database
1601 cp866_general_ci
1602 SET @@global.collation_database = cp866_bin;
1603 Warnings:
1604 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1605 SELECT @@global.collation_database;
1606 @@global.collation_database
1607 cp866_bin
1608 SET @@global.collation_database = keybcs2_general_ci;
1609 Warnings:
1610 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1611 SELECT @@global.collation_database;
1612 @@global.collation_database
1613 keybcs2_general_ci
1614 SET @@global.collation_database = keybcs2_bin;
1615 Warnings:
1616 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1617 SELECT @@global.collation_database;
1618 @@global.collation_database
1619 keybcs2_bin
1620 SET @@global.collation_database = macce_general_ci;
1621 Warnings:
1622 Warning 4079 'macce_general_ci' is a collation of the deprecated character set macce. Please consider using utf8mb4 with an appropriate collation instead.
1623 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1624 SELECT @@global.collation_database;
1625 @@global.collation_database
1626 macce_general_ci
1627 SET @@global.collation_database = macce_bin;
1628 Warnings:
1629 Warning 4079 'macce_bin' is a collation of the deprecated character set macce. Please consider using utf8mb4 with an appropriate collation instead.
1630 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1631 SELECT @@global.collation_database;
1632 @@global.collation_database
1633 macce_bin
1634 SET @@global.collation_database = macroman_general_ci;
1635 Warnings:
1636 Warning 4079 'macroman_general_ci' is a collation of the deprecated character set macroman. Please consider using utf8mb4 with an appropriate collation instead.
1637 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1638 SELECT @@global.collation_database;
1639 @@global.collation_database
1640 macroman_general_ci
1641 SET @@global.collation_database = macroman_bin;
1642 Warnings:
1643 Warning 4079 'macroman_bin' is a collation of the deprecated character set macroman. Please consider using utf8mb4 with an appropriate collation instead.
1644 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1645 SELECT @@global.collation_database;
1646 @@global.collation_database
1647 macroman_bin
1648 SET @@global.collation_database = cp852_general_ci;
1649 Warnings:
1650 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1651 SELECT @@global.collation_database;
1652 @@global.collation_database
1653 cp852_general_ci
1654 SET @@global.collation_database = cp852_bin;
1655 Warnings:
1656 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1657 SELECT @@global.collation_database;
1658 @@global.collation_database
1659 cp852_bin
1660 SET @@global.collation_database = latin7_estonian_cs;
1661 Warnings:
1662 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1663 SELECT @@global.collation_database;
1664 @@global.collation_database
1665 latin7_estonian_cs
1666 SET @@global.collation_database = latin7_general_ci;
1667 Warnings:
1668 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1669 SELECT @@global.collation_database;
1670 @@global.collation_database
1671 latin7_general_ci
1672 SET @@global.collation_database = latin7_general_cs;
1673 Warnings:
1674 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1675 SELECT @@global.collation_database;
1676 @@global.collation_database
1677 latin7_general_cs
1678 SET @@global.collation_database = latin7_bin;
1679 Warnings:
1680 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1681 SELECT @@global.collation_database;
1682 @@global.collation_database
1683 latin7_bin
1684 SET @@global.collation_database = cp1251_bulgarian_ci;
1685 Warnings:
1686 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1687 SELECT @@global.collation_database;
1688 @@global.collation_database
1689 cp1251_bulgarian_ci
1690 SET @@global.collation_database = cp1251_ukrainian_ci;
1691 Warnings:
1692 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1693 SELECT @@global.collation_database;
1694 @@global.collation_database
1695 cp1251_ukrainian_ci
1696 SET @@global.collation_database = cp1251_bin;
1697 Warnings:
1698 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1699 SELECT @@global.collation_database;
1700 @@global.collation_database
1701 cp1251_bin
1702 SET @@global.collation_database = cp1251_general_ci;
1703 Warnings:
1704 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1705 SELECT @@global.collation_database;
1706 @@global.collation_database
1707 cp1251_general_ci
1708 SET @@global.collation_database = cp1251_general_cs;
1709 Warnings:
1710 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1711 SELECT @@global.collation_database;
1712 @@global.collation_database
1713 cp1251_general_cs
1714 SET @@global.collation_database = cp1256_general_ci;
1715 Warnings:
1716 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1717 SELECT @@global.collation_database;
1718 @@global.collation_database
1719 cp1256_general_ci
1720 SET @@global.collation_database = cp1256_bin;
1721 Warnings:
1722 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1723 SELECT @@global.collation_database;
1724 @@global.collation_database
1725 cp1256_bin
1726 SET @@global.collation_database = cp1257_lithuanian_ci;
1727 Warnings:
1728 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1729 SELECT @@global.collation_database;
1730 @@global.collation_database
1731 cp1257_lithuanian_ci
1732 SET @@global.collation_database = cp1257_bin;
1733 Warnings:
1734 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1735 SELECT @@global.collation_database;
1736 @@global.collation_database
1737 cp1257_bin
1738 SET @@global.collation_database = cp1257_general_ci;
1739 Warnings:
1740 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1741 SELECT @@global.collation_database;
1742 @@global.collation_database
1743 cp1257_general_ci
1744 SET @@global.collation_database = binary;
1745 Warnings:
1746 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1747 SELECT @@global.collation_database;
1748 @@global.collation_database
1749 binary
1750 SET @@global.collation_database = geostd8_general_ci;
1751 Warnings:
1752 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1753 SELECT @@global.collation_database;
1754 @@global.collation_database
1755 geostd8_general_ci
1756 SET @@global.collation_database = geostd8_bin;
1757 Warnings:
1758 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1759 SELECT @@global.collation_database;
1760 @@global.collation_database
1761 geostd8_bin
1762 SET @@global.collation_database = cp932_japanese_ci;
1763 Warnings:
1764 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1765 SELECT @@global.collation_database;
1766 @@global.collation_database
1767 cp932_japanese_ci
1768 SET @@global.collation_database = cp932_bin;
1769 Warnings:
1770 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1771 SELECT @@global.collation_database;
1772 @@global.collation_database
1773 cp932_bin
1774 SET @@global.collation_database = eucjpms_japanese_ci;
1775 Warnings:
1776 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1777 SELECT @@global.collation_database;
1778 @@global.collation_database
1779 eucjpms_japanese_ci
1780 SET @@global.collation_database = eucjpms_bin;
1781 Warnings:
1782 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1783 SELECT @@global.collation_database;
1784 @@global.collation_database
1785 eucjpms_bin
1786 SET @@global.collation_database = utf8mb4_0900_ai_ci;
1787 Warnings:
1788 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1789 SELECT @@global.collation_database;
1790 @@global.collation_database
1791 utf8mb4_0900_ai_ci
1792 '#--------------------FN_DYNVARS_016_08-------------------------#'
1793 SET @@collation_database = LATIN7_GENERAL_CS;
1794 Warnings:
1795 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1796 SELECT @@collation_database;
1797 @@collation_database
1798 latin7_general_cs
1799 SET @@collation_database = latin7_general_cs;
1800 Warnings:
1801 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1802 SELECT @@collation_database;
1803 @@collation_database
1804 latin7_general_cs
1805 SET @@global.collation_database = Latin7_GeneRal_cS;
1806 Warnings:
1807 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1808 SELECT @@global.collation_database;
1809 @@global.collation_database
1810 latin7_general_cs
1811 '#--------------------FN_DYNVARS_016_09-------------------------#'
1812 SET @@collation_database = 1;
1813 Warnings:
1814 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1815 SELECT @@collation_database;
1816 @@collation_database
1817 big5_chinese_ci
1818 SET @@collation_database = 2;
1819 Warnings:
1820 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1821 SELECT @@collation_database;
1822 @@collation_database
1823 latin2_czech_cs
1824 SET @@collation_database = 3;
1825 Warnings:
1826 Warning 4079 'dec8_swedish_ci' is a collation of the deprecated character set dec8. Please consider using utf8mb4 with an appropriate collation instead.
1827 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1828 SELECT @@collation_database;
1829 @@collation_database
1830 dec8_swedish_ci
1831 SET @@collation_database = 99;
1832 Warnings:
1833 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1834 SELECT @@collation_database;
1835 @@collation_database
1836 cp1250_polish_ci
1837 SET @@collation_database = 100;
1838 ERROR HY000: Unknown collation: '100'
1839 SET @@global.collation_database = 1;
1840 Warnings:
1841 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1842 SELECT @@global.collation_database;
1843 @@global.collation_database
1844 big5_chinese_ci
1845 SET @@global.collation_database = 2;
1846 Warnings:
1847 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1848 SELECT @@global.collation_database;
1849 @@global.collation_database
1850 latin2_czech_cs
1851 SET @@global.collation_database = 3;
1852 Warnings:
1853 Warning 4079 'dec8_swedish_ci' is a collation of the deprecated character set dec8. Please consider using utf8mb4 with an appropriate collation instead.
1854 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1855 SELECT @@global.collation_database;
1856 @@global.collation_database
1857 dec8_swedish_ci
1858 SET @@global.collation_database = 99;
1859 Warnings:
1860 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1861 SELECT @@global.collation_database;
1862 @@global.collation_database
1863 cp1250_polish_ci
1864 SET @@global.collation_database = 100;
1865 ERROR HY000: Unknown collation: '100'
1866 SET @total_collations = (SELECT count(*) FROM INFORMATION_SCHEMA.COLLATIONS);
1867 SELECT @total_collations > 120;
1868 @total_collations > 120
1869 1
1870 '#--------------------FN_DYNVARS_016_10-------------------------#'
1871 SET @@collation_database = latin7_binary;
1872 ERROR HY000: Unknown collation: 'latin7_binary'
1873 SET @@collation_database = 'eucjpms_japanese_cs';
1874 ERROR HY000: Unknown collation: 'eucjpms_japanese_cs'
1875 SET @@collation_database = 0;
1876 ERROR HY000: Unknown collation: '0'
1877 SET @@collation_database = 1.01;
1878 ERROR 42000: Incorrect argument type to variable 'collation_database'
1879 SET @@collation_database = -1;
1880 ERROR HY000: Unknown collation: '-1'
1881 SET @@collation_database = '';
1882 ERROR HY000: Unknown collation: ''
1883 SET @@collation_database = ' eucjpms_bin';
1884 ERROR HY000: Unknown collation: ' eucjpms_bin'
1885 SET @@collation_database = true;
1886 Warnings:
1887 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1888 SELECT @@collation_database AS res_with_true;
1889 res_with_true
1890 big5_chinese_ci
1891 SET @@collation_database = ON;
1892 ERROR HY000: Unknown collation: 'ON'
1893 SET @@collation_database = repeat('e', 256);
1894 ERROR HY000: Unknown collation: 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'
1895 SET @@collation_database = repeat('e', 1024);
1896 ERROR HY000: Unknown collation: 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'
1897 '#--------------------FN_DYNVARS_016_11-------------------------#'
1898 SET @@global.collation_database = latin7_binary;
1899 ERROR HY000: Unknown collation: 'latin7_binary'
1900 SET @@global.collation_database = 'eucjpms_japanese_cs';
1901 ERROR HY000: Unknown collation: 'eucjpms_japanese_cs'
1902 SET @@global.collation_database = 0;
1903 ERROR HY000: Unknown collation: '0'
1904 SET @@global.collation_database = 1.1;
1905 ERROR 42000: Incorrect argument type to variable 'collation_database'
1906 SET @@global.collation_database = -1;
1907 ERROR HY000: Unknown collation: '-1'
1908 SET @@global.collation_database = "";
1909 ERROR HY000: Unknown collation: ''
1910 SET @@global.collation_database = ' eucjpms_bin';
1911 ERROR HY000: Unknown collation: ' eucjpms_bin'
1912 SET @@global.collation_database = true;
1913 Warnings:
1914 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1915 SET @@global.collation_database = ON;
1916 ERROR HY000: Unknown collation: 'ON'
1917 SET @@global.collation_database = repeat('e', 256);
1918 ERROR HY000: Unknown collation: 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'
1919 SET @@global.collation_database = repeat('e', 1024);
1920 ERROR HY000: Unknown collation: 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'
1921 '#--------------------FN_DYNVARS_016_12-------------------------#'
1922 SELECT @@global.collation_database =
1923 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
1924 WHERE VARIABLE_NAME='collation_database') AS res;
1925 res
1926 1
1927 SET @@global.collation_database = 1;
1928 Warnings:
1929 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1930 SELECT @@global.collation_database;
1931 @@global.collation_database
1932 big5_chinese_ci
1933 SELECT @@global.collation_database =
1934 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
1935 WHERE VARIABLE_NAME='collation_database') AS res;
1936 res
1937 1
1938 '#--------------------FN_DYNVARS_016_13-------------------------#'
1939 SELECT @@collation_database =
1940 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
1941 WHERE VARIABLE_NAME='collation_database') AS res;
1942 res
1943 1
1944 SELECT @@local.collation_database =
1945 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
1946 WHERE VARIABLE_NAME='collation_database') AS res;
1947 res
1948 1
1949 SELECT @@session.collation_database =
1950 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
1951 WHERE VARIABLE_NAME='collation_database') AS res;
1952 res
1953 1
1954 SET @@global.collation_database = @global_start_value;
1955 Warnings:
1956 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1957 SELECT @@global.collation_database;
1958 @@global.collation_database
1959 utf8mb4_0900_ai_ci
1960 SET @@session.collation_database = @session_start_value;
1961 Warnings:
1962 Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release.
1963 SELECT @@session.collation_database;
1964 @@session.collation_database
1965 utf8mb4_0900_ai_ci