1
SET @global_start_value = @@global.character_set_client;
2
SELECT @global_start_value;
5
SET @session_start_value = @@character_set_client;
6
SELECT @session_start_value;
9
SET @session_start_value = @@local.character_set_client;
10
SELECT @session_start_value;
13
SET @session_start_value = @@session.character_set_client;
14
SELECT @session_start_value;
17
'#--------------------FN_DYNVARS_010_01------------------#'
18
SELECT character_set_client;
19
ERROR 42S22: Unknown column 'character_set_client' in 'field list'
20
SET character_set_client=utf8;
21
SELECT @@session.character_set_client;
22
@@session.character_set_client
24
SET global.character_set_client=utf8;
25
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'character_set_client=utf8' at line 1
26
SET session character_set_client=utf8;
27
SELECT session character_set_client;
28
ERROR 42S22: Unknown column 'session' in 'field list'
29
SET global character_set_client=utf8;
30
SELECT global character_set_client;
31
ERROR 42S22: Unknown column 'global' in 'field list'
32
'#--------------------FN_DYNVARS_010_02-------------------------#'
33
SET @@character_set_client = latin5;
34
SET @@character_set_client = DEFAULT;
35
SELECT @@character_set_client AS DEFAULT_VALUE;
38
SET @@global.character_set_client = latin5;
39
SET @@global.character_set_client = DEFAULT;
40
SELECT @@global.character_set_client;
41
@@global.character_set_client
43
'#--------------------FN_DYNVARS_010_03-------------------------#'
44
SET @@session.character_set_client = utf8;
45
SELECT @@session.character_set_client;
46
@@session.character_set_client
48
SET @@global.character_set_client = latin2;
49
SELECT @@global.character_set_client;
50
@@global.character_set_client
52
SELECT @@session.character_set_client AS res_is_utf8;
55
SET @@session.character_set_client = latin5;
56
SELECT @@session.character_set_client;
57
@@session.character_set_client
59
SELECT @@global.character_set_client AS res_is_latin2;
62
SELECT @@global.character_set_client=@@session.character_set_client
66
'#--------------------FN_DYNVARS_010_04-------------------------#'
67
SELECT @@character_set_client = @@session.character_set_client AS res;
70
SELECT @@character_set_client = @@local.character_set_client AS res;
73
'#--------------------FN_DYNVARS_010_05-------------------------#'
74
SET @@character_set_client = utf8 + latin2;
75
ERROR 42S22: Unknown column 'utf8' in 'field list'
76
'#--------------------FN_DYNVARS_010_06-------------------------#'
77
SET @@character_set_client = big5;
78
SELECT @@character_set_client;
79
@@character_set_client
81
SET @@character_set_client = dec8;
82
SELECT @@character_set_client;
83
@@character_set_client
85
SET @@character_set_client = cp850;
86
SELECT @@character_set_client;
87
@@character_set_client
89
SET @@character_set_client = hp8;
90
SELECT @@character_set_client;
91
@@character_set_client
93
SET @@character_set_client = koi8r;
94
SELECT @@character_set_client;
95
@@character_set_client
97
SET @@character_set_client = latin1;
98
SELECT @@character_set_client;
99
@@character_set_client
101
SET @@character_set_client = latin2;
102
SELECT @@character_set_client;
103
@@character_set_client
105
SET @@character_set_client = swe7;
106
SELECT @@character_set_client;
107
��character_set_client
109
SET @@character_set_client = ascii;
110
SELECT @@character_set_client;
111
@@character_set_client
113
SET @@character_set_client = ujis;
114
SELECT @@character_set_client;
115
@@character_set_client
117
SET @@character_set_client = sjis;
118
SELECT @@character_set_client;
119
@@character_set_client
121
SET @@character_set_client = hebrew;
122
SELECT @@character_set_client;
123
@@character_set_client
125
SET @@character_set_client = tis620;
126
SELECT @@character_set_client;
127
@@character_set_client
129
SET @@character_set_client = euckr;
130
SELECT @@character_set_client;
131
@@character_set_client
133
SET @@character_set_client = koi8u;
134
SELECT @@character_set_client;
135
@@character_set_client
137
SET @@character_set_client = gb2312;
138
SELECT @@character_set_client;
139
@@character_set_client
141
SET @@character_set_client = greek;
142
SELECT @@character_set_client;
143
@@character_set_client
145
SET @@character_set_client = cp1250;
146
SELECT @@character_set_client;
147
@@character_set_client
149
SET @@character_set_client = gbk;
150
SELECT @@character_set_client;
151
@@character_set_client
153
SET @@character_set_client = latin5;
154
SELECT @@character_set_client;
155
@@character_set_client
157
SET @@character_set_client = armscii8;
158
SELECT @@character_set_client;
159
@@character_set_client
161
SET @@character_set_client = utf8;
162
SELECT @@character_set_client;
163
@@character_set_client
165
'Bug: Assignment of ucs2 to session character-set does not raise error';
166
'but selecting variable after setting it does.';
167
'Even catching this does not allow any further character-set to be set.';
168
'Offending querry seems to be:';
169
'SET @@character_set_client = ucs2;'
170
SET @@character_set_client = cp866;
171
SELECT @@character_set_client;
172
@@character_set_client
174
SET @@character_set_client = keybcs2;
175
SELECT @@character_set_client;
176
@@character_set_client
178
SET @@character_set_client = macce;
179
SELECT @@character_set_client;
180
@@character_set_client
182
SET @@character_set_client = macroman;
183
SELECT @@character_set_client;
184
@@character_set_client
186
SET @@character_set_client = cp852;
187
SELECT @@character_set_client;
188
@@character_set_client
190
SET @@character_set_client = latin7;
191
SELECT @@character_set_client;
192
@@character_set_client
194
SET @@character_set_client = cp1251;
195
SELECT @@character_set_client;
196
@@character_set_client
198
SET @@character_set_client = cp1256;
199
SELECT @@character_set_client;
200
@@character_set_client
202
SET @@character_set_client = cp1257;
203
SELECT @@character_set_client;
204
@@character_set_client
206
SET @@character_set_client = binary;
207
SELECT @@character_set_client;
208
@@character_set_client
210
SET @@character_set_client = geostd8;
211
SELECT @@character_set_client;
212
@@character_set_client
214
SET @@character_set_client = cp932;
215
SELECT @@character_set_client;
216
@@character_set_client
218
SET @@character_set_client = eucjpms;
219
SELECT @@character_set_client;
220
@@character_set_client
222
'#--------------------FN_DYNVARS_010_07-------------------------#'
223
SET @@global.character_set_client = big5;
224
SELECT @@global.character_set_client;
225
@@global.character_set_client
227
SET @@global.character_set_client = dec8;
228
SELECT @@global.character_set_client;
229
@@global.character_set_client
231
SET @@global.character_set_client = cp850;
232
SELECT @@global.character_set_client;
233
@@global.character_set_client
235
SET @@global.character_set_client = hp8;
236
SELECT @@global.character_set_client;
237
@@global.character_set_client
239
SET @@global.character_set_client = koi8r;
240
SELECT @@global.character_set_client;
241
@@global.character_set_client
243
SET @@global.character_set_client = latin1;
244
SELECT @@global.character_set_client;
245
@@global.character_set_client
247
SET @@global.character_set_client = latin2;
248
SELECT @@global.character_set_client;
249
@@global.character_set_client
251
SET @@global.character_set_client = swe7;
252
SELECT @@global.character_set_client;
253
@@global.character_set_client
255
SET @@global.character_set_client = ascii;
256
SELECT @@global.character_set_client;
257
@@global.character_set_client
259
SET @@global.character_set_client = ujis;
260
SELECT @@global.character_set_client;
261
@@global.character_set_client
263
SET @@global.character_set_client = sjis;
264
SELECT @@global.character_set_client;
265
@@global.character_set_client
267
SET @@global.character_set_client = hebrew;
268
SELECT @@global.character_set_client;
269
@@global.character_set_client
271
SET @@global.character_set_client = tis620;
272
SELECT @@global.character_set_client;
273
@@global.character_set_client
275
SET @@global.character_set_client = euckr;
276
SELECT @@global.character_set_client;
277
@@global.character_set_client
279
SET @@global.character_set_client = koi8u;
280
SELECT @@global.character_set_client;
281
@@global.character_set_client
283
SET @@global.character_set_client = gb2312;
284
SELECT @@global.character_set_client;
285
@@global.character_set_client
287
SET @@global.character_set_client = greek;
288
SELECT @@global.character_set_client;
289
@@global.character_set_client
291
SET @@global.character_set_client = cp1250;
292
SELECT @@global.character_set_client;
293
@@global.character_set_client
295
SET @@global.character_set_client = gbk;
296
SELECT @@global.character_set_client;
297
@@global.character_set_client
299
SET @@global.character_set_client = latin5;
300
SELECT @@global.character_set_client;
301
@@global.character_set_client
303
SET @@global.character_set_client = armscii8;
304
SELECT @@global.character_set_client;
305
@@global.character_set_client
307
SET @@global.character_set_client = utf8;
308
SELECT @@global.character_set_client;
309
@@global.character_set_client
311
SET @@global.character_set_client = ucs2;
312
SELECT @@global.character_set_client;
313
@@global.character_set_client
315
SET @@global.character_set_client = cp866;
316
SELECT @@global.character_set_client;
317
@@global.character_set_client
319
SET @@global.character_set_client = keybcs2;
320
SELECT @@global.character_set_client;
321
@@global.character_set_client
323
SET @@global.character_set_client = macce;
324
SELECT @@global.character_set_client;
325
@@global.character_set_client
327
SET @@global.character_set_client = macroman;
328
SELECT @@global.character_set_client;
329
@@global.character_set_client
331
SET @@global.character_set_client = cp852;
332
SELECT @@global.character_set_client;
333
@@global.character_set_client
335
SET @@global.character_set_client = latin7;
336
SELECT @@global.character_set_client;
337
@@global.character_set_client
339
SET @@global.character_set_client = cp1251;
340
SELECT @@global.character_set_client;
341
@@global.character_set_client
343
SET @@global.character_set_client = cp1256;
344
SELECT @@global.character_set_client;
345
@@global.character_set_client
347
SET @@global.character_set_client = cp1257;
348
SELECT @@global.character_set_client;
349
@@global.character_set_client
351
SET @@global.character_set_client = binary;
352
SELECT @@global.character_set_client;
353
@@global.character_set_client
355
SET @@global.character_set_client = geostd8;
356
SELECT @@global.character_set_client;
357
@@global.character_set_client
359
SET @@global.character_set_client = cp932;
360
SELECT @@global.character_set_client;
361
@@global.character_set_client
363
SET @@global.character_set_client = eucjpms;
364
SELECT @@global.character_set_client;
365
@@global.character_set_client
367
'#--------------------FN_DYNVARS_010_08-------------------------#'
368
SET @@character_set_client = UTF8;
369
SELECT @@character_set_client;
370
@@character_set_client
372
SET @@character_set_client = utf8;
373
SELECT @@character_set_client;
374
@@character_set_client
376
SET @@global.character_set_client = uTf8;
377
SELECT @@global.character_set_client;
378
@@global.character_set_client
380
'#--------------------FN_DYNVARS_010_09-------------------------#'
381
SET @@character_set_client = 1;
382
SELECT @@character_set_client;
383
@@character_set_client
385
SET @@character_set_client = 2;
386
SELECT @@character_set_client;
387
@@character_set_client
389
SET @@character_set_client = 3;
390
SELECT @@character_set_client;
391
@@character_set_client
393
SET @@character_set_client = 36;
394
SELECT @@character_set_client;
395
@@character_set_client
397
SET @@character_set_client = 99;
398
SELECT @@character_set_client;
399
@@character_set_client
401
SET @@character_set_client = 100;
402
ERROR 42000: Unknown character set: '100'
403
SET @@global.character_set_client = 1;
404
SELECT @@global.character_set_client;
405
@@global.character_set_client
407
SET @@global.character_set_client = 2;
408
SELECT @@global.character_set_client;
409
@@global.character_set_client
411
SET @@global.character_set_client = 3;
412
SELECT @@global.character_set_client;
413
@@global.character_set_client
415
SET @@global.character_set_client = 36;
416
SELECT @@global.character_set_client;
417
@@global.character_set_client
419
SET @@global.character_set_client = 99;
420
SELECT @@global.character_set_client;
421
@@global.character_set_client
423
SET @@global.character_set_client = 100;
424
ERROR 42000: Unknown character set: '100'
425
SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
426
SELECT @total_charset;
429
'Bug # 34843: character sets are mapped in such a way that 100 and following';
430
'numbers gives error, and before 100 the 36 mapped wraps arround';
432
'#--------------------FN_DYNVARS_010_10-------------------------#'
433
SET @@character_set_client = abc;
434
ERROR 42000: Unknown character set: 'abc'
435
SET @@character_set_client = 1utf8;
436
ERROR 42000: Unknown character set: '1utf8'
437
SET @@character_set_client = 0;
438
ERROR 42000: Unknown character set: '0'
439
SET @@character_set_client = 1.1;
440
ERROR 42000: Incorrect argument type to variable 'character_set_client'
441
SET @@character_set_client = -1;
442
ERROR 42000: Unknown character set: '-1'
443
SET @@character_set_client = '';
444
ERROR 42000: Unknown character set: ''
445
SET @@character_set_client = 'utf';
446
ERROR 42000: Unknown character set: 'utf'
447
SET @@character_set_client = true;
448
SELECT @@character_set_client AS res_with_true;
451
SET @@character_set_client = ON;
452
ERROR 42000: Unknown character set: 'ON'
453
'#--------------------FN_DYNVARS_010_11-------------------------#'
454
SET @@global.character_set_client = abc;
455
ERROR 42000: Unknown character set: 'abc'
456
SET @@global.character_set_client = 1utf8;
457
ERROR 42000: Unknown character set: '1utf8'
458
SET @@global.character_set_client = 0;
459
ERROR 42000: Unknown character set: '0'
460
SET @@global.character_set_client = 1.1;
461
ERROR 42000: Incorrect argument type to variable 'character_set_client'
462
SET @@global.character_set_client = -1;
463
ERROR 42000: Unknown character set: '-1'
464
SET @@global.character_set_client = '';
465
ERROR 42000: Unknown character set: ''
466
SET @@global.character_set_client = 'utf';
467
ERROR 42000: Unknown character set: 'utf'
468
SET @@global.character_set_client = true;
469
SET @@global.character_set_client = ON;
470
ERROR 42000: Unknown character set: 'ON'
471
'#--------------------FN_DYNVARS_010_12-------------------------#'
472
SELECT @@global.character_set_client =
473
(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
474
WHERE VARIABLE_NAME='character_set_client') AS res;
477
SET @@global.character_set_client = 1;
478
SELECT @@global.character_set_client;
479
@@global.character_set_client
481
SELECT @@global.character_set_client =
482
(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
483
WHERE VARIABLE_NAME='character_set_client') AS res;
486
'#--------------------FN_DYNVARS_010_13-------------------------#'
487
SELECT @@character_set_client =
488
(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
489
WHERE VARIABLE_NAME='character_set_client') AS res;
492
SELECT @@local.character_set_client =
493
(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
494
WHERE VARIABLE_NAME='character_set_client') AS res;
497
SELECT @@session.character_set_client =
498
(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
499
WHERE VARIABLE_NAME='character_set_client') AS res;
502
SET @@global.character_set_client = @global_start_value;
503
SELECT @@global.character_set_client;
504
@@global.character_set_client
506
SET @@session.character_set_client = @session_start_value;
507
SELECT @@session.character_set_client;
508
@@session.character_set_client