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