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 'global.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 = gb18030;
154SELECT @@session.character_set_connection;
155@@session.character_set_connection
156gb18030
157SET @@session.character_set_connection = latin5;
158SELECT @@session.character_set_connection;
159@@session.character_set_connection
160latin5
161SET @@session.character_set_connection = armscii8;
162SELECT @@session.character_set_connection;
163@@session.character_set_connection
164armscii8
165SET @@session.character_set_connection = utf8;
166SELECT @@session.character_set_connection;
167@@session.character_set_connection
168utf8
169SET @@session.character_set_connection = ucs2;
170SELECT @@session.character_set_connection;
171@@session.character_set_connection
172ucs2
173SET @@session.character_set_connection = cp866;
174SELECT @@session.character_set_connection;
175@@session.character_set_connection
176cp866
177SET @@session.character_set_connection = keybcs2;
178SELECT @@session.character_set_connection;
179@@session.character_set_connection
180keybcs2
181SET @@session.character_set_connection = macce;
182SELECT @@session.character_set_connection;
183@@session.character_set_connection
184macce
185SET @@session.character_set_connection = macroman;
186SELECT @@session.character_set_connection;
187@@session.character_set_connection
188macroman
189SET @@session.character_set_connection = cp852;
190SELECT @@session.character_set_connection;
191@@session.character_set_connection
192cp852
193SET @@session.character_set_connection = latin7;
194SELECT @@session.character_set_connection;
195@@session.character_set_connection
196latin7
197SET @@session.character_set_connection = cp1251;
198SELECT @@session.character_set_connection;
199@@session.character_set_connection
200cp1251
201SET @@session.character_set_connection = cp1256;
202SELECT @@session.character_set_connection;
203@@session.character_set_connection
204cp1256
205SET @@session.character_set_connection = cp1257;
206SELECT @@session.character_set_connection;
207@@session.character_set_connection
208cp1257
209SET @@session.character_set_connection = binary;
210SELECT @@session.character_set_connection;
211@@session.character_set_connection
212binary
213SET @@session.character_set_connection = geostd8;
214SELECT @@session.character_set_connection;
215@@session.character_set_connection
216geostd8
217SET @@session.character_set_connection = cp932;
218SELECT @@session.character_set_connection;
219@@session.character_set_connection
220cp932
221SET @@session.character_set_connection = eucjpms;
222SELECT @@session.character_set_connection;
223@@session.character_set_connection
224eucjpms
225'#--------------------FN_DYNVARS_011_07-------------------------#'
226SET @@global.character_set_connection = big5;
227SELECT @@global.character_set_connection;
228@@global.character_set_connection
229big5
230SET @@global.character_set_connection = dec8;
231SELECT @@global.character_set_connection;
232@@global.character_set_connection
233dec8
234SET @@global.character_set_connection = cp850;
235SELECT @@global.character_set_connection;
236@@global.character_set_connection
237cp850
238SET @@global.character_set_connection = hp8;
239SELECT @@global.character_set_connection;
240@@global.character_set_connection
241hp8
242SET @@global.character_set_connection = koi8r;
243SELECT @@global.character_set_connection;
244@@global.character_set_connection
245koi8r
246SET @@global.character_set_connection = latin1;
247SELECT @@global.character_set_connection;
248@@global.character_set_connection
249latin1
250SET @@global.character_set_connection = latin2;
251SELECT @@global.character_set_connection;
252@@global.character_set_connection
253latin2
254SET @@global.character_set_connection = swe7;
255SELECT @@global.character_set_connection;
256@@global.character_set_connection
257swe7
258SET @@global.character_set_connection = ascii;
259SELECT @@global.character_set_connection;
260@@global.character_set_connection
261ascii
262SET @@global.character_set_connection = ujis;
263SELECT @@global.character_set_connection;
264@@global.character_set_connection
265ujis
266SET @@global.character_set_connection = sjis;
267SELECT @@global.character_set_connection;
268@@global.character_set_connection
269sjis
270SET @@global.character_set_connection = hebrew;
271SELECT @@global.character_set_connection;
272@@global.character_set_connection
273hebrew
274SET @@global.character_set_connection = tis620;
275SELECT @@global.character_set_connection;
276@@global.character_set_connection
277tis620
278SET @@global.character_set_connection = euckr;
279SELECT @@global.character_set_connection;
280@@global.character_set_connection
281euckr
282SET @@global.character_set_connection = koi8u;
283SELECT @@global.character_set_connection;
284@@global.character_set_connection
285koi8u
286SET @@global.character_set_connection = gb2312;
287SELECT @@global.character_set_connection;
288@@global.character_set_connection
289gb2312
290SET @@global.character_set_connection = greek;
291SELECT @@global.character_set_connection;
292@@global.character_set_connection
293greek
294SET @@global.character_set_connection = cp1250;
295SELECT @@global.character_set_connection;
296@@global.character_set_connection
297cp1250
298SET @@global.character_set_connection = gbk;
299SELECT @@global.character_set_connection;
300@@global.character_set_connection
301gbk
302SET @@global.character_set_connection = gb18030;
303SELECT @@global.character_set_connection;
304@@global.character_set_connection
305gb18030
306SET @@global.character_set_connection = latin5;
307SELECT @@global.character_set_connection;
308@@global.character_set_connection
309latin5
310SET @@global.character_set_connection = armscii8;
311SELECT @@global.character_set_connection;
312@@global.character_set_connection
313armscii8
314SET @@global.character_set_connection = utf8;
315SELECT @@global.character_set_connection;
316@@global.character_set_connection
317utf8
318SET @@global.character_set_connection = ucs2;
319SELECT @@global.character_set_connection;
320@@global.character_set_connection
321ucs2
322SET @@global.character_set_connection = cp866;
323SELECT @@global.character_set_connection;
324@@global.character_set_connection
325cp866
326SET @@global.character_set_connection = keybcs2;
327SELECT @@global.character_set_connection;
328@@global.character_set_connection
329keybcs2
330SET @@global.character_set_connection = macce;
331SELECT @@global.character_set_connection;
332@@global.character_set_connection
333macce
334SET @@global.character_set_connection = macroman;
335SELECT @@global.character_set_connection;
336@@global.character_set_connection
337macroman
338SET @@global.character_set_connection = cp852;
339SELECT @@global.character_set_connection;
340@@global.character_set_connection
341cp852
342SET @@global.character_set_connection = latin7;
343SELECT @@global.character_set_connection;
344@@global.character_set_connection
345latin7
346SET @@global.character_set_connection = cp1251;
347SELECT @@global.character_set_connection;
348@@global.character_set_connection
349cp1251
350SET @@global.character_set_connection = cp1256;
351SELECT @@global.character_set_connection;
352@@global.character_set_connection
353cp1256
354SET @@global.character_set_connection = cp1257;
355SELECT @@global.character_set_connection;
356@@global.character_set_connection
357cp1257
358SET @@global.character_set_connection = binary;
359SELECT @@global.character_set_connection;
360@@global.character_set_connection
361binary
362SET @@global.character_set_connection = geostd8;
363SELECT @@global.character_set_connection;
364@@global.character_set_connection
365geostd8
366SET @@global.character_set_connection = cp932;
367SELECT @@global.character_set_connection;
368@@global.character_set_connection
369cp932
370SET @@global.character_set_connection = eucjpms;
371SELECT @@global.character_set_connection;
372@@global.character_set_connection
373eucjpms
374'#--------------------FN_DYNVARS_011_08-------------------------#'
375SET @@character_set_connection = UTF8;
376SELECT @@character_set_connection;
377@@character_set_connection
378utf8
379SET @@character_set_connection = utf8;
380SELECT @@character_set_connection;
381@@character_set_connection
382utf8
383SET @@global.character_set_connection = uTf8;
384SELECT @@global.character_set_connection;
385@@global.character_set_connection
386utf8
387'#--------------------FN_DYNVARS_011_09-------------------------#'
388SET @@character_set_connection = 1;
389SELECT @@character_set_connection;
390@@character_set_connection
391big5
392SET @@character_set_connection = 2;
393SELECT @@character_set_connection;
394@@character_set_connection
395latin2
396SET @@character_set_connection = 3;
397SELECT @@character_set_connection;
398@@character_set_connection
399dec8
400SET @@character_set_connection = 36;
401SELECT @@character_set_connection;
402@@character_set_connection
403cp866
404SET @@character_set_connection = 99;
405SELECT @@character_set_connection;
406@@character_set_connection
407cp1250
408SET @@character_set_connection = 100;
409ERROR 42000: Unknown character set: '100'
410SET @@global.character_set_connection = 1;
411SELECT @@global.character_set_connection;
412@@global.character_set_connection
413big5
414SET @@global.character_set_connection = 2;
415SELECT @@global.character_set_connection;
416@@global.character_set_connection
417latin2
418SET @@global.character_set_connection = 3;
419SELECT @@global.character_set_connection;
420@@global.character_set_connection
421dec8
422SET @@global.character_set_connection = 36;
423SELECT @@global.character_set_connection;
424@@global.character_set_connection
425cp866
426SET @@global.character_set_connection = 99;
427SELECT @@global.character_set_connection;
428@@global.character_set_connection
429cp1250
430SET @@global.character_set_connection = 100;
431ERROR 42000: Unknown character set: '100'
432SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS);
433SELECT @total_charset;
434@total_charset
43541
436'#--------------------FN_DYNVARS_011_10-------------------------#'
437SET @@character_set_connection = abc;
438ERROR 42000: Unknown character set: 'abc'
439SET @@character_set_connection = 1utf8;
440ERROR 42000: Unknown character set: '1utf8'
441SET @@character_set_connection = 0;
442ERROR 42000: Unknown character set: '0'
443SET @@character_set_connection = 1.1;
444ERROR 42000: Incorrect argument type to variable 'character_set_connection'
445SET @@character_set_connection = -1;
446ERROR 42000: Unknown character set: '-1'
447SET @@character_set_connection = 'utf8 ';
448ERROR 42000: Unknown character set: 'utf8 '
449SET @@character_set_connection = 'l�tin2';
450ERROR 42000: Unknown character set: 'l�tin2'
451SET @@character_set_connection = true;
452SELECT @@character_set_connection AS res_with_true;
453res_with_true
454big5
455SET @@character_set_connection = ON;
456ERROR 42000: Unknown character set: 'ON'
457'#--------------------FN_DYNVARS_011_11-------------------------#'
458SET @@global.character_set_connection = abc;
459ERROR 42000: Unknown character set: 'abc'
460SET @@global.character_set_connection = 1utf8;
461ERROR 42000: Unknown character set: '1utf8'
462SET @@global.character_set_connection = 0;
463ERROR 42000: Unknown character set: '0'
464SET @@global.character_set_connection = 1.1;
465ERROR 42000: Incorrect argument type to variable 'character_set_connection'
466SET @@global.character_set_connection = -1;
467ERROR 42000: Unknown character set: '-1'
468SET @@global.character_set_connection = '';
469ERROR 42000: Unknown character set: ''
470SET @@global.character_set_connection = 'utf';
471ERROR 42000: Unknown character set: 'utf'
472SET @@global.character_set_connection = true;
473SET @@global.character_set_connection = ON;
474ERROR 42000: Unknown character set: 'ON'
475'#--------------------FN_DYNVARS_011_12-------------------------#'
476SELECT @@global.character_set_connection =
477(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
478WHERE VARIABLE_NAME='character_set_connection') AS res;
479res
4801
481SET @@global.character_set_connection = 1;
482SELECT @@global.character_set_connection;
483@@global.character_set_connection
484big5
485SELECT @@global.character_set_connection =
486(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
487WHERE VARIABLE_NAME='character_set_connection') AS res;
488res
4891
490'#--------------------FN_DYNVARS_011_13-------------------------#'
491SELECT @@character_set_connection =
492(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
493WHERE VARIABLE_NAME='character_set_connection') AS res;
494res
4951
496SELECT @@local.character_set_connection =
497(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
498WHERE VARIABLE_NAME='character_set_connection') AS res;
499res
5001
501SELECT @@session.character_set_connection =
502(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
503WHERE VARIABLE_NAME='character_set_connection') AS res;
504res
5051
506SET @@global.character_set_connection = @global_start_value;
507SELECT @@global.character_set_connection;
508@@global.character_set_connection
509latin1
510SET @@session.character_set_connection = @session_start_value;
511SELECT @@session.character_set_connection;
512@@session.character_set_connection
513latin1
514