Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.character_set_database;
2 SELECT @global_start_value;
3 @global_start_value
4 utf8mb4
5 SET @session_start_value = @@character_set_database;
6 SELECT @session_start_value;
7 @session_start_value
8 utf8mb4
9 SET @session_start_value = @@local.character_set_database;
10 SELECT @session_start_value;
11 @session_start_value
12 utf8mb4
13 SET @session_start_value = @@session.character_set_database;
14 SELECT @session_start_value;
15 @session_start_value
16 utf8mb4
17 '#--------------------FN_DYNVARS_012_01------------------#'
18 SELECT character_set_database;
19 ERROR 42S22: Unknown column 'character_set_database' in 'field list'
20 SET character_set_database=utf8;
21 Warnings:
22 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
23 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
24 SELECT @@session.character_set_database;
25 @@session.character_set_database
26 utf8mb3
27 SET global.character_set_database=utf8;
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.character_set_database=utf8' at line 1
29 SET session character_set_database=utf8;
30 Warnings:
31 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
32 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
33 SELECT session character_set_database;
34 ERROR 42S22: Unknown column 'session' in 'field list'
35 SET global character_set_database=utf8;
36 Warnings:
37 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
38 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
39 SELECT global character_set_database;
40 ERROR 42S22: Unknown column 'global' in 'field list'
41 '#--------------------FN_DYNVARS_012_02-------------------------#'
42 SET @@character_set_database = latin5;
43 Warnings:
44 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
45 SET @@character_set_database = DEFAULT;
46 Warnings:
47 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
48 SELECT @@character_set_database AS DEFAULT_VALUE;
49 DEFAULT_VALUE
50 utf8mb4
51 SET @@global.character_set_database = latin5;
52 Warnings:
53 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
54 SET @@global.character_set_database = DEFAULT;
55 Warnings:
56 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
57 SELECT @@global.character_set_database;
58 @@global.character_set_database
59 utf8mb4
60 '#--------------------FN_DYNVARS_012_03-------------------------#'
61 SET @@session.character_set_database = utf8;
62 Warnings:
63 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
64 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
65 SELECT @@session.character_set_database;
66 @@session.character_set_database
67 utf8mb3
68 SET @@global.character_set_database = latin2;
69 Warnings:
70 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
71 SELECT @@global.character_set_database;
72 @@global.character_set_database
73 latin2
74 SELECT @@session.character_set_database AS res_is_utf8;
75 res_is_utf8
76 utf8mb3
77 SET @@session.character_set_database = latin5;
78 Warnings:
79 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
80 SELECT @@session.character_set_database;
81 @@session.character_set_database
82 latin5
83 SELECT @@global.character_set_database AS res_is_latin2;
84 res_is_latin2
85 latin2
86 SELECT @@global.character_set_database=@@session.character_set_database
87 AS res_is_false;
88 res_is_false
89 0
90 '#--------------------FN_DYNVARS_012_04-------------------------#'
91 SELECT @@character_set_database = @@session.character_set_database AS res;
92 res
93 1
94 SELECT @@character_set_database = @@local.character_set_database AS res;
95 res
96 1
97 '#--------------------FN_DYNVARS_012_05-------------------------#'
98 SET @@character_set_database = utf8 + latin2;
99 ERROR 42S22: Unknown column 'utf8' in 'field list'
100 '#--------------------FN_DYNVARS_012_06-------------------------#'
101 SET @@session.character_set_database = big5;
102 Warnings:
103 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
104 SELECT @@session.character_set_database;
105 @@session.character_set_database
106 big5
107 SET @@session.character_set_database = dec8;
108 Warnings:
109 Warning 1287 'dec8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
110 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
111 SELECT @@session.character_set_database;
112 @@session.character_set_database
113 dec8
114 SET @@session.character_set_database = cp850;
115 Warnings:
116 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
117 SELECT @@session.character_set_database;
118 @@session.character_set_database
119 cp850
120 SET @@session.character_set_database = hp8;
121 Warnings:
122 Warning 1287 'hp8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
123 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
124 SELECT @@session.character_set_database;
125 @@session.character_set_database
126 hp8
127 SET @@session.character_set_database = koi8r;
128 Warnings:
129 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
130 SELECT @@session.character_set_database;
131 @@session.character_set_database
132 koi8r
133 SET @@session.character_set_database = latin1;
134 Warnings:
135 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
136 SELECT @@session.character_set_database;
137 @@session.character_set_database
138 latin1
139 SET @@session.character_set_database = latin2;
140 Warnings:
141 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
142 SELECT @@session.character_set_database;
143 @@session.character_set_database
144 latin2
145 SET @@session.character_set_database = swe7;
146 Warnings:
147 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
148 SELECT @@session.character_set_database;
149 @@session.character_set_database
150 swe7
151 SET @@session.character_set_database = ascii;
152 Warnings:
153 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
154 SELECT @@session.character_set_database;
155 @@session.character_set_database
156 ascii
157 SET @@session.character_set_database = ujis;
158 Warnings:
159 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
160 SELECT @@session.character_set_database;
161 @@session.character_set_database
162 ujis
163 SET @@session.character_set_database = sjis;
164 Warnings:
165 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
166 SELECT @@session.character_set_database;
167 @@session.character_set_database
168 sjis
169 SET @@session.character_set_database = hebrew;
170 Warnings:
171 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
172 SELECT @@session.character_set_database;
173 @@session.character_set_database
174 hebrew
175 SET @@session.character_set_database = tis620;
176 Warnings:
177 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
178 SELECT @@session.character_set_database;
179 @@session.character_set_database
180 tis620
181 SET @@session.character_set_database = euckr;
182 Warnings:
183 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
184 SELECT @@session.character_set_database;
185 @@session.character_set_database
186 euckr
187 SET @@session.character_set_database = koi8u;
188 Warnings:
189 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
190 SELECT @@session.character_set_database;
191 @@session.character_set_database
192 koi8u
193 SET @@session.character_set_database = gb2312;
194 Warnings:
195 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
196 SELECT @@session.character_set_database;
197 @@session.character_set_database
198 gb2312
199 SET @@session.character_set_database = greek;
200 Warnings:
201 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
202 SELECT @@session.character_set_database;
203 @@session.character_set_database
204 greek
205 SET @@session.character_set_database = cp1250;
206 Warnings:
207 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
208 SELECT @@session.character_set_database;
209 @@session.character_set_database
210 cp1250
211 SET @@session.character_set_database = gbk;
212 Warnings:
213 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
214 SELECT @@session.character_set_database;
215 @@session.character_set_database
216 gbk
217 SET @@session.character_set_database = gb18030;
218 Warnings:
219 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
220 SELECT @@session.character_set_database;
221 @@session.character_set_database
222 gb18030
223 SET @@session.character_set_database = latin5;
224 Warnings:
225 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
226 SELECT @@session.character_set_database;
227 @@session.character_set_database
228 latin5
229 SET @@session.character_set_database = armscii8;
230 Warnings:
231 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
232 SELECT @@session.character_set_database;
233 @@session.character_set_database
234 armscii8
235 SET @@session.character_set_database = utf8;
236 Warnings:
237 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
238 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
239 SELECT @@session.character_set_database;
240 @@session.character_set_database
241 utf8mb3
242 SET @@session.character_set_database = utf8mb4;
243 Warnings:
244 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
245 SELECT @@session.character_set_database;
246 @@session.character_set_database
247 utf8mb4
248 SET @@session.character_set_database = ucs2;
249 Warnings:
250 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
251 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
252 SELECT @@session.character_set_database;
253 @@session.character_set_database
254 ucs2
255 SET @@session.character_set_database = cp866;
256 Warnings:
257 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
258 SELECT @@session.character_set_database;
259 @@session.character_set_database
260 cp866
261 SET @@session.character_set_database = keybcs2;
262 Warnings:
263 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
264 SELECT @@session.character_set_database;
265 @@session.character_set_database
266 keybcs2
267 SET @@session.character_set_database = macce;
268 Warnings:
269 Warning 1287 'macce' is deprecated and will be removed in a future release. Please use utf8mb4 instead
270 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
271 SELECT @@session.character_set_database;
272 @@session.character_set_database
273 macce
274 SET @@session.character_set_database = macroman;
275 Warnings:
276 Warning 1287 'macroman' is deprecated and will be removed in a future release. Please use utf8mb4 instead
277 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
278 SELECT @@session.character_set_database;
279 @@session.character_set_database
280 macroman
281 SET @@session.character_set_database = cp852;
282 Warnings:
283 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
284 SELECT @@session.character_set_database;
285 @@session.character_set_database
286 cp852
287 SET @@session.character_set_database = latin7;
288 Warnings:
289 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
290 SELECT @@session.character_set_database;
291 @@session.character_set_database
292 latin7
293 SET @@session.character_set_database = cp1251;
294 Warnings:
295 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
296 SELECT @@session.character_set_database;
297 @@session.character_set_database
298 cp1251
299 SET @@session.character_set_database = cp1256;
300 Warnings:
301 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
302 SELECT @@session.character_set_database;
303 @@session.character_set_database
304 cp1256
305 SET @@session.character_set_database = cp1257;
306 Warnings:
307 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
308 SELECT @@session.character_set_database;
309 @@session.character_set_database
310 cp1257
311 SET @@session.character_set_database = binary;
312 Warnings:
313 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
314 SELECT @@session.character_set_database;
315 @@session.character_set_database
316 binary
317 SET @@session.character_set_database = geostd8;
318 Warnings:
319 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
320 SELECT @@session.character_set_database;
321 @@session.character_set_database
322 geostd8
323 SET @@session.character_set_database = cp932;
324 Warnings:
325 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
326 SELECT @@session.character_set_database;
327 @@session.character_set_database
328 cp932
329 SET @@session.character_set_database = eucjpms;
330 Warnings:
331 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
332 SELECT @@session.character_set_database;
333 @@session.character_set_database
334 eucjpms
335 '#--------------------FN_DYNVARS_012_07-------------------------#'
336 SET @@global.character_set_database = big5;
337 Warnings:
338 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
339 SELECT @@global.character_set_database;
340 @@global.character_set_database
341 big5
342 SET @@global.character_set_database = dec8;
343 Warnings:
344 Warning 1287 'dec8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
345 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
346 SELECT @@global.character_set_database;
347 @@global.character_set_database
348 dec8
349 SET @@global.character_set_database = cp850;
350 Warnings:
351 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
352 SELECT @@global.character_set_database;
353 @@global.character_set_database
354 cp850
355 SET @@global.character_set_database = hp8;
356 Warnings:
357 Warning 1287 'hp8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
358 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
359 SELECT @@global.character_set_database;
360 @@global.character_set_database
361 hp8
362 SET @@global.character_set_database = koi8r;
363 Warnings:
364 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
365 SELECT @@global.character_set_database;
366 @@global.character_set_database
367 koi8r
368 SET @@global.character_set_database = latin1;
369 Warnings:
370 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
371 SELECT @@global.character_set_database;
372 @@global.character_set_database
373 latin1
374 SET @@global.character_set_database = latin2;
375 Warnings:
376 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
377 SELECT @@global.character_set_database;
378 @@global.character_set_database
379 latin2
380 SET @@global.character_set_database = swe7;
381 Warnings:
382 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
383 SELECT @@global.character_set_database;
384 @@global.character_set_database
385 swe7
386 SET @@global.character_set_database = ascii;
387 Warnings:
388 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
389 SELECT @@global.character_set_database;
390 @@global.character_set_database
391 ascii
392 SET @@global.character_set_database = ujis;
393 Warnings:
394 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
395 SELECT @@global.character_set_database;
396 @@global.character_set_database
397 ujis
398 SET @@global.character_set_database = sjis;
399 Warnings:
400 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
401 SELECT @@global.character_set_database;
402 @@global.character_set_database
403 sjis
404 SET @@global.character_set_database = hebrew;
405 Warnings:
406 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
407 SELECT @@global.character_set_database;
408 @@global.character_set_database
409 hebrew
410 SET @@global.character_set_database = tis620;
411 Warnings:
412 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
413 SELECT @@global.character_set_database;
414 @@global.character_set_database
415 tis620
416 SET @@global.character_set_database = euckr;
417 Warnings:
418 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
419 SELECT @@global.character_set_database;
420 @@global.character_set_database
421 euckr
422 SET @@global.character_set_database = koi8u;
423 Warnings:
424 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
425 SELECT @@global.character_set_database;
426 @@global.character_set_database
427 koi8u
428 SET @@global.character_set_database = gb2312;
429 Warnings:
430 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
431 SELECT @@global.character_set_database;
432 @@global.character_set_database
433 gb2312
434 SET @@global.character_set_database = greek;
435 Warnings:
436 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
437 SELECT @@global.character_set_database;
438 @@global.character_set_database
439 greek
440 SET @@global.character_set_database = cp1250;
441 Warnings:
442 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
443 SELECT @@global.character_set_database;
444 @@global.character_set_database
445 cp1250
446 SET @@global.character_set_database = gbk;
447 Warnings:
448 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
449 SELECT @@global.character_set_database;
450 @@global.character_set_database
451 gbk
452 SET @@global.character_set_database = gb18030;
453 Warnings:
454 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
455 SELECT @@global.character_set_database;
456 @@global.character_set_database
457 gb18030
458 SET @@global.character_set_database = latin5;
459 Warnings:
460 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
461 SELECT @@global.character_set_database;
462 @@global.character_set_database
463 latin5
464 SET @@global.character_set_database = armscii8;
465 Warnings:
466 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
467 SELECT @@global.character_set_database;
468 @@global.character_set_database
469 armscii8
470 SET @@global.character_set_database = utf8;
471 Warnings:
472 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
473 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
474 SELECT @@global.character_set_database;
475 @@global.character_set_database
476 utf8mb3
477 SET @@global.character_set_database = utf8mb4;
478 Warnings:
479 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
480 SELECT @@global.character_set_database;
481 @@global.character_set_database
482 utf8mb4
483 SET @@global.character_set_database = ucs2;
484 Warnings:
485 Warning 1287 'ucs2' is deprecated and will be removed in a future release. Please use utf8mb4 instead
486 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
487 SELECT @@global.character_set_database;
488 @@global.character_set_database
489 ucs2
490 SET @@global.character_set_database = cp866;
491 Warnings:
492 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
493 SELECT @@global.character_set_database;
494 @@global.character_set_database
495 cp866
496 SET @@global.character_set_database = keybcs2;
497 Warnings:
498 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
499 SELECT @@global.character_set_database;
500 @@global.character_set_database
501 keybcs2
502 SET @@global.character_set_database = macce;
503 Warnings:
504 Warning 1287 'macce' is deprecated and will be removed in a future release. Please use utf8mb4 instead
505 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
506 SELECT @@global.character_set_database;
507 @@global.character_set_database
508 macce
509 SET @@global.character_set_database = macroman;
510 Warnings:
511 Warning 1287 'macroman' is deprecated and will be removed in a future release. Please use utf8mb4 instead
512 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
513 SELECT @@global.character_set_database;
514 @@global.character_set_database
515 macroman
516 SET @@global.character_set_database = cp852;
517 Warnings:
518 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
519 SELECT @@global.character_set_database;
520 @@global.character_set_database
521 cp852
522 SET @@global.character_set_database = latin7;
523 Warnings:
524 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
525 SELECT @@global.character_set_database;
526 @@global.character_set_database
527 latin7
528 SET @@global.character_set_database = cp1251;
529 Warnings:
530 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
531 SELECT @@global.character_set_database;
532 @@global.character_set_database
533 cp1251
534 SET @@global.character_set_database = cp1256;
535 Warnings:
536 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
537 SELECT @@global.character_set_database;
538 @@global.character_set_database
539 cp1256
540 SET @@global.character_set_database = cp1257;
541 Warnings:
542 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
543 SELECT @@global.character_set_database;
544 @@global.character_set_database
545 cp1257
546 SET @@global.character_set_database = binary;
547 Warnings:
548 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
549 SELECT @@global.character_set_database;
550 @@global.character_set_database
551 binary
552 SET @@global.character_set_database = geostd8;
553 Warnings:
554 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
555 SELECT @@global.character_set_database;
556 @@global.character_set_database
557 geostd8
558 SET @@global.character_set_database = cp932;
559 Warnings:
560 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
561 SELECT @@global.character_set_database;
562 @@global.character_set_database
563 cp932
564 SET @@global.character_set_database = eucjpms;
565 Warnings:
566 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
567 SELECT @@global.character_set_database;
568 @@global.character_set_database
569 eucjpms
570 '#--------------------FN_DYNVARS_012_08-------------------------#'
571 SET @@character_set_database = UTF8;
572 Warnings:
573 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
574 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
575 SELECT @@character_set_database;
576 @@character_set_database
577 utf8mb3
578 SET @@character_set_database = utf8;
579 Warnings:
580 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
581 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
582 SELECT @@character_set_database;
583 @@character_set_database
584 utf8mb3
585 SET @@global.character_set_database = uTf8;
586 Warnings:
587 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
588 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
589 SELECT @@global.character_set_database;
590 @@global.character_set_database
591 utf8mb3
592 '#--------------------FN_DYNVARS_012_09-------------------------#'
593 SET @@character_set_database = 1;
594 Warnings:
595 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
596 SELECT @@character_set_database;
597 @@character_set_database
598 big5
599 SET @@character_set_database = 2;
600 Warnings:
601 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
602 SELECT @@character_set_database;
603 @@character_set_database
604 latin2
605 SET @@character_set_database = 3;
606 Warnings:
607 Warning 1287 'dec8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
608 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
609 SELECT @@character_set_database;
610 @@character_set_database
611 dec8
612 SET @@character_set_database = 36;
613 Warnings:
614 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
615 SELECT @@character_set_database;
616 @@character_set_database
617 cp866
618 SET @@character_set_database = 99;
619 Warnings:
620 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
621 SELECT @@character_set_database;
622 @@character_set_database
623 cp1250
624 SET @@character_set_database = 100;
625 ERROR 42000: Unknown character set: '100'
626 SET @@global.character_set_database = 1;
627 Warnings:
628 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
629 SELECT @@global.character_set_database;
630 @@global.character_set_database
631 big5
632 SET @@global.character_set_database = 2;
633 Warnings:
634 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
635 SELECT @@global.character_set_database;
636 @@global.character_set_database
637 latin2
638 SET @@global.character_set_database = 3;
639 Warnings:
640 Warning 1287 'dec8' is deprecated and will be removed in a future release. Please use utf8mb4 instead
641 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
642 SELECT @@global.character_set_database;
643 @@global.character_set_database
644 dec8
645 SET @@global.character_set_database = 36;
646 Warnings:
647 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
648 SELECT @@global.character_set_database;
649 @@global.character_set_database
650 cp866
651 SET @@global.character_set_database = 99;
652 Warnings:
653 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
654 SELECT @@global.character_set_database;
655 @@global.character_set_database
656 cp1250
657 SET @@global.character_set_database = 100;
658 ERROR 42000: Unknown character set: '100'
659 SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
660 SELECT @total_charset;
661 @total_charset
662 41
663 '#--------------------FN_DYNVARS_012_10-------------------------#'
664 SET @@character_set_database = "grek";
665 ERROR 42000: Unknown character set: 'grek'
666 SET @@character_set_database = utf 8;
667 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 '8' at line 1
668 SET @@character_set_database = 0;
669 ERROR 42000: Unknown character set: '0'
670 SET @@character_set_database = 1.1;
671 ERROR 42000: Incorrect argument type to variable 'character_set_database'
672 SET @@character_set_database = -1;
673 ERROR 42000: Unknown character set: '-1'
674 SET @@character_set_database = '';
675 ERROR 42000: Unknown character set: ''
676 SET @@character_set_database = 'latin 2';
677 ERROR 42000: Unknown character set: 'latin 2'
678 SET @@character_set_database = true;
679 Warnings:
680 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
681 SELECT @@character_set_database AS res_with_true;
682 res_with_true
683 big5
684 SET @@character_set_database = ON;
685 ERROR 42000: Unknown character set: 'ON'
686 SET @@character_set_database = repeat('e', 256);
687 ERROR 42000: Unknown character set: 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'
688 SET @@character_set_database = repeat('e', 1024);
689 ERROR 42000: Unknown character set: 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'
690 '#--------------------FN_DYNVARS_012_11-------------------------#'
691 SET @@global.character_set_database = abc;
692 ERROR 42000: Unknown character set: 'abc'
693 SET @@global.character_set_database = 1utf8;
694 ERROR 42000: Unknown character set: '1utf8'
695 SET @@global.character_set_database = 0;
696 ERROR 42000: Unknown character set: '0'
697 SET @@global.character_set_database = 1.1;
698 ERROR 42000: Incorrect argument type to variable 'character_set_database'
699 SET @@global.character_set_database = -1;
700 ERROR 42000: Unknown character set: '-1'
701 SET @@global.character_set_database = '';
702 ERROR 42000: Unknown character set: ''
703 SET @@global.character_set_database = 'utf';
704 ERROR 42000: Unknown character set: 'utf'
705 SET @@global.character_set_database = true;
706 Warnings:
707 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
708 SET @@global.character_set_database = ON;
709 ERROR 42000: Unknown character set: 'ON'
710 SET @@global.character_set_database = repeat('e', 256);
711 ERROR 42000: Unknown character set: 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'
712 SET @@global.character_set_database = repeat('e', 1024);
713 ERROR 42000: Unknown character set: 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee'
714 '#--------------------FN_DYNVARS_012_12-------------------------#'
715 SELECT @@global.character_set_database =
716 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
717 WHERE VARIABLE_NAME='character_set_database') AS res;
718 res
719 1
720 SET @@global.character_set_database = 1;
721 Warnings:
722 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
723 SELECT @@global.character_set_database;
724 @@global.character_set_database
725 big5
726 SELECT @@global.character_set_database =
727 (SELECT VARIABLE_VALUE FROM performance_schema.global_variables
728 WHERE VARIABLE_NAME='character_set_database') AS res;
729 res
730 1
731 '#--------------------FN_DYNVARS_012_13-------------------------#'
732 SELECT @@character_set_database =
733 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
734 WHERE VARIABLE_NAME='character_set_database') AS res;
735 res
736 1
737 SELECT @@local.character_set_database =
738 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
739 WHERE VARIABLE_NAME='character_set_database') AS res;
740 res
741 1
742 SELECT @@session.character_set_database =
743 (SELECT VARIABLE_VALUE FROM performance_schema.session_variables
744 WHERE VARIABLE_NAME='character_set_database') AS res;
745 res
746 1
747 SET @@global.character_set_database = @global_start_value;
748 Warnings:
749 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
750 SELECT @@global.character_set_database;
751 @@global.character_set_database
752 utf8mb4
753 SET @@session.character_set_database = @session_start_value;
754 Warnings:
755 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
756 SELECT @@session.character_set_database;
757 @@session.character_set_database
758 utf8mb4