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