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