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