1
SET @global_start_value = @@global.character_set_results;
2
SELECT @global_start_value;
5
SET @session_start_value = @@character_set_results;
6
SELECT @session_start_value;
9
SET @session_start_value = @@local.character_set_results;
10
SELECT @session_start_value;
13
SET @session_start_value = @@session.character_set_results;
14
SELECT @session_start_value;
17
'#--------------------FN_DYNVARS_013_01------------------#'
18
SELECT character_set_results;
19
ERROR 42S22: Unknown column 'character_set_results' in 'field list'
20
SET character_set_results=utf8;
21
SELECT @@session.character_set_results;
22
@@session.character_set_results
24
SET global.character_set_results=utf8;
25
ERROR 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_results=utf8' at line 1
26
SET session character_set_results=utf8;
27
SELECT session character_set_results;
28
ERROR 42S22: Unknown column 'session' in 'field list'
29
SET global character_set_results=utf8;
30
SELECT global character_set_results;
31
ERROR 42S22: Unknown column 'global' in 'field list'
32
'#--------------------FN_DYNVARS_013_02-------------------------#'
33
SET @@character_set_results = latin5;
34
SET @@character_set_results = DEFAULT;
35
SELECT @@character_set_results AS DEFAULT_VALUE;
38
SET @@global.character_set_results = latin5;
39
SET @@global.character_set_results = DEFAULT;
40
SELECT @@global.character_set_results;
41
@@global.character_set_results
43
'#--------------------FN_DYNVARS_013_03-------------------------#'
44
SET @@session.character_set_results = utf8;
45
SELECT @@session.character_set_results;
46
@@session.character_set_results
48
SET @@global.character_set_results = latin2;
49
SELECT @@global.character_set_results;
50
@@global.character_set_results
52
SELECT @@session.character_set_results AS res_is_utf8;
55
SET @@session.character_set_results = latin5;
56
SELECT @@session.character_set_results;
57
@@session.character_set_results
59
SELECT @@global.character_set_results AS res_is_latin2;
62
SELECT @@global.character_set_results=@@session.character_set_results
66
'#--------------------FN_DYNVARS_013_04-------------------------#'
67
SELECT @@character_set_results = @@session.character_set_results AS res;
70
SELECT @@character_set_results = @@local.character_set_results AS res;
73
'#--------------------FN_DYNVARS_013_05-------------------------#'
74
SET @@character_set_results = utf8 + latin2;
75
ERROR 42S22: Unknown column 'utf8' in 'field list'
76
'#--------------------FN_DYNVARS_013_06-------------------------#'
77
SET @@session.character_set_results = big5;
78
SELECT @@session.character_set_results;
79
@@session.character_set_results
81
SET @@session.character_set_results = dec8;
82
SELECT @@session.character_set_results;
83
@@session.character_set_results
85
SET @@session.character_set_results = cp850;
86
SELECT @@session.character_set_results;
87
@@session.character_set_results
89
SET @@session.character_set_results = hp8;
90
SELECT @@session.character_set_results;
91
@@session.character_set_results
93
SET @@session.character_set_results = koi8r;
94
SELECT @@session.character_set_results;
95
@@session.character_set_results
97
SET @@session.character_set_results = latin1;
98
SELECT @@session.character_set_results;
99
@@session.character_set_results
101
SET @@session.character_set_results = latin2;
102
SELECT @@session.character_set_results;
103
@@session.character_set_results
105
SET @@session.character_set_results = swe7;
106
SELECT @@session.character_set_results;
107
??session.character_set_results
109
SET @@session.character_set_results = ascii;
110
SELECT @@session.character_set_results;
111
@@session.character_set_results
113
SET @@session.character_set_results = ujis;
114
SELECT @@session.character_set_results;
115
@@session.character_set_results
117
SET @@session.character_set_results = sjis;
118
SELECT @@session.character_set_results;
119
@@session.character_set_results
121
SET @@session.character_set_results = hebrew;
122
SELECT @@session.character_set_results;
123
@@session.character_set_results
125
SET @@session.character_set_results = tis620;
126
SELECT @@session.character_set_results;
127
@@session.character_set_results
129
SET @@session.character_set_results = euckr;
130
SELECT @@session.character_set_results;
131
@@session.character_set_results
133
SET @@session.character_set_results = koi8u;
134
SELECT @@session.character_set_results;
135
@@session.character_set_results
137
SET @@session.character_set_results = gb2312;
138
SELECT @@session.character_set_results;
139
@@session.character_set_results
141
SET @@session.character_set_results = greek;
142
SELECT @@session.character_set_results;
143
@@session.character_set_results
145
SET @@session.character_set_results = cp1250;
146
SELECT @@session.character_set_results;
147
@@session.character_set_results
149
SET @@session.character_set_results = gbk;
150
SELECT @@session.character_set_results;
151
@@session.character_set_results
153
SET @@session.character_set_results = latin5;
154
SELECT @@session.character_set_results;
155
@@session.character_set_results
157
SET @@session.character_set_results = armscii8;
158
SELECT @@session.character_set_results;
159
@@session.character_set_results
161
SET @@session.character_set_results = utf8;
162
SELECT @@session.character_set_results;
163
@@session.character_set_results
165
SET @@session.character_set_results = ucs2;
166
SELECT @@session.character_set_results;