1SET @global_start_value = @@global.character_set_client;
2SELECT @global_start_value;
3@global_start_value
4latin1
5SET @session_start_value = @@character_set_client;
6SELECT @session_start_value;
7@session_start_value
8latin1
9SET @session_start_value = @@local.character_set_client;
10SELECT @session_start_value;
11@session_start_value
12latin1
13SET @session_start_value = @@session.character_set_client;
14SELECT @session_start_value;
15@session_start_value
16latin1
17'#--------------------FN_DYNVARS_010_01------------------#'
18SELECT character_set_client;
19ERROR 42S22: Unknown column 'character_set_client' in 'field list'
20SET character_set_client=utf8;
21SELECT @@session.character_set_client;
22@@session.character_set_client
23utf8
24SET global.character_set_client=utf8;
25ERROR 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
26SET session character_set_client=utf8;
27SELECT session character_set_client;
28ERROR 42S22: Unknown column 'session' in 'field list'
29SET global character_set_client=utf8;
30SELECT global character_set_client;
31ERROR 42S22: Unknown column 'global' in 'field list'
32'#--------------------FN_DYNVARS_010_02-------------------------#'
33SET @@character_set_client = latin5;
34SET @@character_set_client = DEFAULT;
35SELECT @@character_set_client AS DEFAULT_VALUE;
36DEFAULT_VALUE
37utf8
38SET @@global.character_set_client = latin5;
39SET @@global.character_set_client = DEFAULT;
40SELECT @@global.character_set_client;
41@@global.character_set_client
42latin1
43'#--------------------FN_DYNVARS_010_03-------------------------#'
44SET @@session.character_set_client = utf8;
45SELECT @@session.character_set_client;
46@@session.character_set_client
47utf8
48SET @@global.character_set_client = latin2;
49SELECT @@global.character_set_client;
50@@global.character_set_client
51latin2
52SELECT @@session.character_set_client AS res_is_utf8;
53res_is_utf8
54utf8
55SET @@session.character_set_client = latin5;
56SELECT @@session.character_set_client;
57@@session.character_set_client
58latin5
59SELECT @@global.character_set_client AS res_is_latin2;
60res_is_latin2
61latin2
62SELECT @@global.character_set_client=@@session.character_set_client
63AS res_is_false;
64res_is_false
650
66'#--------------------FN_DYNVARS_010_04-------------------------#'
67SELECT @@character_set_client = @@session.character_set_client AS res;
68res
691
70SELECT @@character_set_client = @@local.character_set_client AS res;
71res
721
73'#--------------------FN_DYNVARS_010_05-------------------------#'
74SET @@character_set_client = utf8 + latin2;
75ERROR 42S22: Unknown column 'utf8' in 'field list'
76'#--------------------FN_DYNVARS_010_06-------------------------#'
77SET @@character_set_client = big5;
78SELECT @@character_set_client;
79@@character_set_client
80big5
81SET @@character_set_client = dec8;
82SELECT @@character_set_client;
83@@character_set_client
84dec8
85SET @@character_set_client = cp850;
86SELECT @@character_set_client;
87@@character_set_client
88cp850
89SET @@character_set_client = hp8;
90SELECT @@character_set_client;
91@@character_set_client
92hp8
93SET @@character_set_client = koi8r;
94SELECT @@character_set_client;
95@@character_set_client
96koi8r
97SET @@character_set_client = latin1;
98SELECT @@character_set_client;
99@@character_set_client
100latin1
101SET @@character_set_client = latin2;
102SELECT @@character_set_client;
103@@character_set_client
104latin2
105SET @@character_set_client = swe7;
106SELECT @@character_set_client;
107��character_set_client
108swe7
109SET @@character_set_client = ascii;
110SELECT @@character_set_client;
111@@character_set_client
112ascii
113SET @@character_set_client = ujis;
114SELECT @@character_set_client;
115@@character_set_client
116ujis
117SET @@character_set_client = sjis;
118SELECT @@character_set_client;
119@@character_set_client
120sjis
121SET @@character_set_client = hebrew;
122SELECT @@character_set_client;
123@@character_set_client
124hebrew
125SET @@character_set_client = tis620;
126SELECT @@character_set_client;
127@@character_set_client
128tis620
129SET @@character_set_client = euckr;
130SELECT @@character_set_client;
131@@character_set_client
132euckr
133SET @@character_set_client = koi8u;
134SELECT @@character_set_client;
135@@character_set_client
136koi8u
137SET @@character_set_client = gb2312;
138SELECT @@character_set_client;
139@@character_set_client
140gb2312
141SET @@character_set_client = greek;
142SELECT @@character_set_client;
143@@character_set_client
144greek
145SET @@character_set_client = cp1250;
146SELECT @@character_set_client;
147@@character_set_client
148cp1250
149SET @@character_set_client = gbk;
150SELECT @@character_set_client;
151@@character_set_client
152gbk
153SET @@character_set_client = latin5;
154SELECT @@character_set_client;
155@@character_set_client
156latin5
157SET @@character_set_client = armscii8;
158SELECT @@character_set_client;
159@@character_set_client
160armscii8
161SET @@character_set_client = utf8;
162SELECT @@character_set_client;
163@@character_set_client
164utf8
165SET @@character_set_client = utf8mb4;
166SELECT @@character_set_client;
167@@character_set_client
168utf8mb4
169SET @@character_set_client = ucs2;
170ERROR 42000: Variable 'character_set_client' can't be set to the value of 'ucs2'
171SET @@character_set_client = utf16;
172ERROR 42000: Variable 'character_set_client' can't be set to the value of 'utf16'
173SET @@character_set_client = utf32;
174ERROR 42000: Variable 'character_set_client' can't be set to the value of 'utf32'
175SET @@character_set_client = cp866;
176SELECT @@character_set_client;
177@@character_set_client
178cp866
179SET @@character_set_client = keybcs2;
180SELECT @@character_set_client;
181@@character_set_client
182keybcs2
183SET @@character_set_client = macce;
184SELECT @@character_set_client;
185@@character_set_client
186macce
187SET @@character_set_client = macroman;
188SELECT @@character_set_client;
189@@character_set_client
190macroman
191SET @@character_set_client = cp852;
192SELECT @@character_set_client;
193@@character_set_client
194cp852
195SET @@character_set_client = latin7;
196SELECT @@character_set_client;
197@@character_set_client
198latin7
199SET @@character_set_client = cp1251;
200SELECT @@character_set_client;
201@@character_set_client
202cp1251
203SET @@character_set_client = cp1256;
204SELECT @@character_set_client;
205@@character_set_client
206cp1256
207SET @@character_set_client = cp1257;
208SELECT @@character_set_client;
209@@character_set_client
210cp1257
211SET @@character_set_client = binary;
212SELECT @@character_set_client;
213@@character_set_client
214binary
215SET @@character_set_client = geostd8;
216SELECT @@character_set_client;
217@@character_set_client
218geostd8
219SET @@character_set_client = cp932;
220SELECT @@character_set_client;
221@@character_set_client
222cp932
223SET @@character_set_client = eucjpms;
224SELECT @@character_set_client;
225@@character_set_client
226eucjpms
227'#--------------------FN_DYNVARS_010_07-------------------------#'
228SET @@global.character_set_client = big5;
229SELECT @@global.character_set_client;
230@@global.character_set_client
231big5
232SET @@global.character_set_client = dec8;
233SELECT @@global.character_set_client;
234@@global.character_set_client
235dec8
236SET @@global.character_set_client = cp850;
237SELECT @@global.character_set_client;
238@@global.character_set_client
239cp850
240SET @@global.character_set_client = hp8;
241SELECT @@global.character_set_client;
242@@global.character_set_client
243hp8
244SET @@global.character_set_client = koi8r;
245SELECT @@global.character_set_client;
246@@global.character_set_client
247koi8r
248SET @@global.character_set_client = latin1;
249SELECT @@global.character_set_client;
250@@global.character_set_client
251latin1
252SET @@global.character_set_client = latin2;
253SELECT @@global.character_set_client;
254@@global.character_set_client
255latin2
256SET @@global.character_set_client = swe7;
257SELECT @@global.character_set_client;
258@@global.character_set_client
259swe7
260SET @@global.character_set_client = ascii;
261SELECT @@global.character_set_client;
262@@global.character_set_client
263ascii
264SET @@global.character_set_client = ujis;
265SELECT @@global.character_set_client;
266@@global.character_set_client
267ujis
268SET @@global.character_set_client = sjis;
269SELECT @@global.character_set_client;
270@@global.character_set_client
271sjis
272SET @@global.character_set_client = hebrew;
273SELECT @@global.character_set_client;
274@@global.character_set_client
275hebrew
276SET @@global.character_set_client = tis620;
277SELECT @@global.character_set_client;
278@@global.character_set_client
279tis620
280SET @@global.character_set_client = euckr;
281SELECT @@global.character_set_client;
282@@global.character_set_client
283euckr
284SET @@global.character_set_client = koi8u;
285SELECT @@global.character_set_client;
286@@global.character_set_client
287koi8u
288SET @@global.character_set_client = gb2312;
289SELECT @@global.character_set_client;
290@@global.character_set_client
291gb2312
292SET @@global.character_set_client = greek;
293SELECT @@global.character_set_client;
294@@global.character_set_client
295greek
296SET @@global.character_set_client = cp1250;
297SELECT @@global.character_set_client;
298@@global.character_set_client
299cp1250
300SET @@global.character_set_client = gbk;
301SELECT @@global.character_set_client;
302@@global.character_set_client
303gbk
304SET @@global.character_set_client = latin5;
305SELECT @@global.character_set_client;
306@@global.character_set_client
307latin5
308SET @@global.character_set_client = armscii8;
309SELECT @@global.character_set_client;
310@@global.character_set_client
311armscii8
312SET @@global.character_set_client = utf8;
313SELECT @@global.character_set_client;
314@@global.character_set_client
315utf8
316SET @@global.character_set_client = ucs2;
317SELECT @@global.character_set_client;
318@@global.character_set_client
319utf8
320SET @@global.character_set_client = cp866;
321SELECT @@global.character_set_client;
322@@global.character_set_client
323cp866
324SET @@global.character_set_client = keybcs2;
325SELECT @@global.character_set_client;
326@@global.character_set_client
327keybcs2
328SET @@global.character_set_client = macce;
329SELECT @@global.character_set_client;
330@@global.character_set_client
331macce
332SET @@global.character_set_client = macroman;
333SELECT @@global.character_set_client;
334@@global.character_set_client
335macroman
336SET @@global.character_set_client = cp852;
337SELECT @@global.character_set_client;
338@@global.character_set_client
339cp852
340SET @@global.character_set_client = latin7;
341SELECT @@global.character_set_client;
342@@global.character_set_client
343latin7
344SET @@global.character_set_client = cp1251;
345SELECT @@global.character_set_client;
346@@global.character_set_client
347cp1251
348SET @@global.character_set_client = cp1256;
349SELECT @@global.character_set_client;
350@@global.character_set_client
351cp1256
352SET @@global.character_set_client = cp1257;
353SELECT @@global.character_set_client;
354@@global.character_set_client
355cp1257
356SET @@global.character_set_client = binary;
357SELECT @@global.character_set_client;
358@@global.character_set_client
359binary
360SET @@global.character_set_client = geostd8;
361SELECT @@global.character_set_client;
362@@global.character_set_client
363geostd8
364SET @@global.character_set_client = cp932;
365SELECT @@global.character_set_client;
366@@global.character_set_client
367cp932
368SET @@global.character_set_client = eucjpms;
369SELECT @@global.character_set_client;
370@@global.character_set_client
371eucjpms
372'#--------------------FN_DYNVARS_010_08-------------------------#'
373SET @@character_set_client = UTF8;
374SELECT @@character_set_client;
375@@character_set_client
376utf8
377SET @@character_set_client = utf8;
378SELECT @@character_set_client;
379@@character_set_client
380utf8
381SET @@global.character_set_client = uTf8;
382SELECT @@global.character_set_client;
383@@global.character_set_client
384utf8
385'#--------------------FN_DYNVARS_010_09-------------------------#'
386SET @@character_set_client = 1;
387SELECT @@character_set_client;
388@@character_set_client
389big5
390SET @@character_set_client = 2;
391SELECT @@character_set_client;
392@@character_set_client
393latin2
394SET @@character_set_client = 3;
395SELECT @@character_set_client;
396@@character_set_client
397dec8
398SET @@character_set_client = 36;
399SELECT @@character_set_client;
400@@character_set_client
401cp866
402SET @@character_set_client = 99;
403SELECT @@character_set_client;
404@@character_set_client
405cp1250
406SET @@character_set_client = 100;
407ERROR 42000: Unknown character set: '100'
408SET @@global.character_set_client = 1;
409SELECT @@global.character_set_client;
410@@global.character_set_client
411big5
412SET @@global.character_set_client = 2;
413SELECT @@global.character_set_client;
414@@global.character_set_client
415latin2
416SET @@global.character_set_client = 3;
417SELECT @@global.character_set_client;
418@@global.character_set_client
419dec8
420SET @@global.character_set_client = 36;
421SELECT @@global.character_set_client;
422@@global.character_set_client
423cp866
424SET @@global.character_set_client = 99;
425SELECT @@global.character_set_client;
426@@global.character_set_client
427cp1250
428SET @@global.character_set_client = 100;
429ERROR 42000: Unknown character set: '100'
430SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
431SELECT @total_charset;
432@total_charset
43340
434'#--------------------FN_DYNVARS_010_10-------------------------#'
435SET @@character_set_client = abc;
436ERROR 42000: Unknown character set: 'abc'
437SET @@character_set_client = 1utf8;
438ERROR 42000: Unknown character set: '1utf8'
439SET @@character_set_client = 0;
440ERROR 42000: Unknown character set: '0'
441SET @@character_set_client = 1.1;
442ERROR 42000: Incorrect argument type to variable 'character_set_client'
443SET @@character_set_client = -1;
444ERROR 42000: Unknown character set: '-1'
445SET @@character_set_client = '';
446ERROR 42000: Unknown character set: ''
447SET @@character_set_client = 'utf';
448ERROR 42000: Unknown character set: 'utf'
449SET @@character_set_client = true;
450SELECT @@character_set_client AS res_with_true;
451res_with_true
452big5
453SET @@character_set_client = ON;
454ERROR 42000: Unknown character set: 'ON'
455'#--------------------FN_DYNVARS_010_11-------------------------#'
456SET @@global.character_set_client = abc;
457ERROR 42000: Unknown character set: 'abc'
458SET @@global.character_set_client = 1utf8;
459ERROR 42000: Unknown character set: '1utf8'
460SET @@global.character_set_client = 0;
461ERROR 42000: Unknown character set: '0'
462SET @@global.character_set_client = 1.1;
463ERROR 42000: Incorrect argument type to variable 'character_set_client'
464SET @@global.character_set_client = -1;
465ERROR 42000: Unknown character set: '-1'
466SET @@global.character_set_client = '';
467ERROR 42000: Unknown character set: ''
468SET @@global.character_set_client = 'utf';
469ERROR 42000: Unknown character set: 'utf'
470SET @@global.character_set_client = true;
471SET @@global.character_set_client = ON;
472ERROR 42000: Unknown character set: 'ON'
473'#--------------------FN_DYNVARS_010_12-------------------------#'
474SELECT @@global.character_set_client =
475(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
476WHERE VARIABLE_NAME='character_set_client') AS res;
477res
4781
479SET @@global.character_set_client = 1;
480SELECT @@global.character_set_client;
481@@global.character_set_client
482big5
483SELECT @@global.character_set_client =
484(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
485WHERE VARIABLE_NAME='character_set_client') AS res;
486res
4871
488'#--------------------FN_DYNVARS_010_13-------------------------#'
489SELECT @@character_set_client =
490(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
491WHERE VARIABLE_NAME='character_set_client') AS res;
492res
4931
494SELECT @@local.character_set_client =
495(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
496WHERE VARIABLE_NAME='character_set_client') AS res;
497res
4981
499SELECT @@session.character_set_client =
500(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
501WHERE VARIABLE_NAME='character_set_client') AS res;
502res
5031
504SET @@global.character_set_client = @global_start_value;
505SELECT @@global.character_set_client;
506@@global.character_set_client
507latin1
508SET @@session.character_set_client = @session_start_value;
509SELECT @@session.character_set_client;
510@@session.character_set_client
511latin1
512