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