← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid

« back to all changes in this revision

Viewing changes to mysql-test/r/collation_server_basic.result

  • Committer: Bazaar Package Importer
  • Author(s): Mathias Gug
  • Date: 2009-06-25 12:55:45 UTC
  • mfrom: (1.1.2 upstream) (0.1.3 experimental)
  • Revision ID: james.westby@ubuntu.com-20090625125545-m8ogs96zzsri74xe
Tags: 5.1.34-1ubuntu1
https://launchpad.net/bugs/319843
https://launchpad.net/bugs/259477
https://launchpad.net/bugs/310211
https://launchpad.net/bugs/201799
https://launchpad.net/bugs/316974
http://bugs.debian.org/314785
http://bugs.debian.org/324834
http://bugs.debian.org/435165
http://bugs.debian.org/444216
https://launchpad.net/bugs/344816
https://launchpad.net/bugs/323755
* Merge from debian experimental (and 5.0 from main), remaining changes:
  - debian/mysql-server-5.1.config:
    + ask for MySQL root password at priority high instead of medium so
      that the password prompt is seen on a default install. (LP: #319843)
    + don't ask for root password when upgrading from a 5.0 install.
  - debian/control:
    + Make libmysqlclient16-dev a transitional package depending on
      libmysqlclient-dev.
    + Make libmysqlclient-dev conflict with libmysqlclient15-dev.
    + Don't build mysql-server, mysql-client, mysql-common and
      libmysqlclient15-dev binary packages since they're still provided
      by mysql-dfsg-5.0.
    + Make mysql-{client,server}-5.1 packages conflict and
      replace mysql-{client,server}-5.0, but not provide
      mysql-{client,server}.
    + Depend on a specific version of mysql-common rather than the src
      version of mysql-dfsg-5.1 since mysql-common is currently part of
      mysql-dfsg-5.0.
    + Lower mailx from a Recommends to a Suggests to avoid pulling in
      a full MTA on all installs of mysql-server. (LP: #259477)
  - debian/rules:
    + added -fno-strict-aliasing to CFLAGS to get around mysql testsuite
      build failures.
    + install mysql-test and sql-bench to /usr/share/mysql/ rather than
      /usr/.
  - debian/additions/debian-start.inc.sh: support ANSI mode (LP: #310211)
  - Add AppArmor profile:
    - debian/apparmor-profile: apparmor profile.
    - debian/rules, debian/mysql-server-5.0.files: install apparmor profile.
    - debian/mysql-server-5.0.dirs: add etc/apparmor.d/force-complain
    - debian/mysql-server-5.0.postrm: remove symlink in force-complain/ on
      purge.
    - debian/mysql-server-5.1.README.Debian: add apparmor documentation.
    - debian/additions/my.cnf: Add warning about apparmor. (LP: #201799)
    - debian/mysql-server-5.1.postinst: reload apparmor profiles.
  - debian/additions/my.cnf: remove language option. Error message files are
    located in a different directory in MySQL 5.0. Setting the language
    option to use /usr/share/mysql/english breaks 5.0. Both 5.0 and 5.1
    use a default value that works. (LP: #316974)
  - debian/mysql-server-5.1.mysql.init:
    + Clearly indicate that we do not support running multiple instances
      of mysqld by duplicating the init script.
      (closes: #314785, #324834, #435165, #444216)
    + Properly parameterize all existing references to the mysql config
      file (/etc/mysql/my.cnf).
  - debian/mysql-server-5.0.postinst: Clear out the second password
    when setting up mysql. (LP: #344816)
  - mysql-server-core-5.1 package for files needed by Akonadi:
    + debian/control: create mysql-server-core-5.1 package.
    + debian/mysql-server-core-5.1.files, debian/mysql-server-5.1.files:
      move core mysqld files to mysql-server-core-5.1 package.
  - Don't package sql-bench and mysql-test file.
* Dropped changes:
  - debian/patches/92_ssl_test_cert.dpatch: certificate expiration in
    test suite (LP: #323755). Included upstream.
* Dropped from 5.0:
  - apparmor profile:
    - debian/control: Recommends apparmor >= 2.1+1075-0ubuntu6. All version
      of apparmor-profile (>hardy) are higher than this version.
    - debian/mysql-server-5.0.preinst: create symlink for force-complain/
      on pre-feisty upgrades, upgrades where apparmor-profiles profile is
      unchanged (ie non-enforcing) and upgrades where the profile
      doesn't exist. Support for pre-hardy upgrades is no longer needed.
* debian/mysql-server-5.1.postinst: fix debian-sys-maint user creation.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/collation_server_basic.result
1
 
SET @global_start_value = @@global.collation_server;
2
 
SELECT @global_start_value;
3
 
@global_start_value
4
 
latin1_swedish_ci
5
 
SET @session_start_value = @@collation_server;
6
 
SELECT @session_start_value;
7
 
@session_start_value
8
 
latin1_swedish_ci
9
 
SET @session_start_value = @@local.collation_server;
10
 
SELECT @session_start_value;
11
 
@session_start_value
12
 
latin1_swedish_ci
13
 
SET @session_start_value = @@session.collation_server;
14
 
SELECT @session_start_value;
15
 
@session_start_value
16
 
latin1_swedish_ci
17
 
'#--------------------FN_DYNVARS_014_01------------------#'
18
 
SELECT collation_server;
19
 
ERROR 42S22: Unknown column 'collation_server' in 'field list'
20
 
SET collation_server=utf8_unicode_ci;
21
 
SELECT @@session.collation_server;
22
 
@@session.collation_server
23
 
utf8_unicode_ci
24
 
SET global.collation_server=utf8_unicode_ci;
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 'collation_server=utf8_unicode_ci' at line 1
26
 
SET session collation_server=utf8_unicode_ci;
27
 
SELECT session collation_server;
28
 
ERROR 42S22: Unknown column 'session' in 'field list'
29
 
SET global collation_server=utf8_unicode_ci;
30
 
SELECT global collation_server;
31
 
ERROR 42S22: Unknown column 'global' in 'field list'
32
 
'#--------------------FN_DYNVARS_014_02-------------------------#'
33
 
SET @@collation_server = latin1_bin;
34
 
SET @@collation_server = DEFAULT;
35
 
SELECT @@collation_server AS DEFAULT_VALUE;
36
 
DEFAULT_VALUE
37
 
utf8_unicode_ci
38
 
SET @@global.collation_server = latin1_bin;
39
 
SET @@global.collation_server = DEFAULT;
40
 
SELECT @@global.collation_server;
41
 
@@global.collation_server
42
 
latin1_swedish_ci
43
 
'#--------------------FN_DYNVARS_014_03-------------------------#'
44
 
SET @@session.collation_server = utf8_polish_ci;
45
 
SELECT @@session.collation_server;
46
 
@@session.collation_server
47
 
utf8_polish_ci
48
 
SET @@global.collation_server = latin7_general_ci;
49
 
SELECT @@global.collation_server;
50
 
@@global.collation_server
51
 
latin7_general_ci
52
 
SELECT @@session.collation_server AS res_is_utf8_polish_ci;
53
 
res_is_utf8_polish_ci
54
 
utf8_polish_ci
55
 
SET @@session.collation_server = latin7_bin;
56
 
SELECT @@session.collation_server;
57
 
@@session.collation_server
58
 
latin7_bin
59
 
SELECT @@global.collation_server AS res_is_latin7_general_ci;
60
 
res_is_latin7_general_ci
61
 
latin7_general_ci
62
 
SELECT @@global.collation_server=@@session.collation_server AS res_is_false;
63
 
res_is_false
64
 
0
65
 
'#--------------------FN_DYNVARS_014_04-------------------------#'
66
 
SELECT @@collation_server = @@session.collation_server AS res;
67
 
res
68
 
1
69
 
SELECT @@collation_server = @@local.collation_server AS res;
70
 
res
71
 
1
72
 
'#--------------------FN_DYNVARS_014_05-------------------------#'
73
 
SET @@collation_server = latin7_general_ci + latin7_general_cs;
74
 
ERROR 42S22: Unknown column 'latin7_general_ci' in 'field list'
75
 
'#--------------------FN_DYNVARS_014_06-------------------------#'
76
 
SET @@session.collation_server = big5_chinese_ci;
77
 
SELECT @@session.collation_server;
78
 
@@session.collation_server
79
 
big5_chinese_ci
80
 
SET @@session.collation_server = big5_bin;
81
 
SELECT @@session.collation_server;
82
 
@@session.collation_server
83
 
big5_bin
84
 
SET @@session.collation_server = dec8_swedish_ci;
85
 
SELECT @@session.collation_server;
86
 
@@session.collation_server
87
 
dec8_swedish_ci
88
 
SET @@session.collation_server = dec8_bin;
89
 
SELECT @@session.collation_server;
90
 
@@session.collation_server
91
 
dec8_bin
92
 
SET @@session.collation_server = cp850_general_ci;
93
 
SELECT @@session.collation_server;
94
 
@@session.collation_server
95
 
cp850_general_ci
96
 
SET @@session.collation_server = cp850_bin;
97
 
SELECT @@session.collation_server;
98
 
@@session.collation_server
99
 
cp850_bin
100
 
SET @@session.collation_server = hp8_english_ci;
101
 
SELECT @@session.collation_server;
102
 
@@session.collation_server
103
 
hp8_english_ci
104
 
SET @@session.collation_server = hp8_bin;
105
 
SELECT @@session.collation_server;
106
 
@@session.collation_server
107
 
hp8_bin
108
 
SET @@session.collation_server = koi8r_general_ci;
109
 
SELECT @@session.collation_server;
110
 
@@session.collation_server
111
 
koi8r_general_ci
112
 
SET @@session.collation_server = koi8r_bin;
113
 
SELECT @@session.collation_server;
114
 
@@session.collation_server
115
 
koi8r_bin
116
 
SET @@session.collation_server = latin1_german1_ci;
117
 
SELECT @@session.collation_server;
118
 
@@session.collation_server
119
 
latin1_german1_ci
120
 
SET @@session.collation_server = latin1_swedish_ci;
121
 
SELECT @@session.collation_server;
122
 
@@session.collation_server
123
 
latin1_swedish_ci
124
 
SET @@session.collation_server = latin1_danish_ci;
125
 
SELECT @@session.collation_server;
126
 
@@session.collation_server
127
 
latin1_danish_ci
128
 
SET @@session.collation_server = latin1_german2_ci;
129
 
SELECT @@session.collation_server;
130
 
@@session.collation_server
131
 
latin1_german2_ci
132
 
SET @@session.collation_server = latin1_bin;
133
 
SELECT @@session.collation_server;
134
 
@@session.collation_server
135
 
latin1_bin
136
 
SET @@session.collation_server = latin1_general_ci;
137
 
SELECT @@session.collation_server;
138
 
@@session.collation_server
139
 
latin1_general_ci
140
 
SET @@session.collation_server = latin1_general_cs;
141
 
SELECT @@session.collation_server;
142
 
@@session.collation_server
143
 
latin1_general_cs
144
 
SET @@session.collation_server = latin1_spanish_ci;
145
 
SELECT @@session.collation_server;
146
 
@@session.collation_server
147
 
latin1_spanish_ci
148
 
SET @@session.collation_server = latin2_czech_cs;
149
 
SELECT @@session.collation_server;
150
 
@@session.collation_server
151
 
latin2_czech_cs
152
 
SET @@session.collation_server = latin2_general_ci;
153
 
SELECT @@session.collation_server;
154
 
@@session.collation_server
155
 
latin2_general_ci
156
 
SET @@session.collation_server = latin2_hungarian_ci;
157
 
SELECT @@session.collation_server;
158
 
@@session.collation_server
159
 
latin2_hungarian_ci
160
 
SET @@session.collation_server = latin2_croatian_ci;
161
 
SELECT @@session.collation_server;
162
 
@@session.collation_server
163
 
latin2_croatian_ci
164
 
SET @@session.collation_server = latin2_bin;
165
 
SELECT @@session.collation_server;
166
 
@@session.collation_server
167
 
latin2_bin
168
 
SET @@session.collation_server = swe7_swedish_ci;
169
 
SELECT @@session.collation_server;
170
 
@@session.collation_server
171
 
swe7_swedish_ci
172
 
SET @@session.collation_server = swe7_bin;
173
 
SELECT @@session.collation_server;
174
 
@@session.collation_server
175
 
swe7_bin
176
 
SET @@session.collation_server = ascii_general_ci;
177
 
SELECT @@session.collation_server;
178
 
@@session.collation_server
179
 
ascii_general_ci
180
 
SET @@session.collation_server = ascii_bin;
181
 
SELECT @@session.collation_server;
182
 
@@session.collation_server
183
 
ascii_bin
184
 
SET @@session.collation_server = ujis_japanese_ci;
185
 
SELECT @@session.collation_server;
186
 
@@session.collation_server
187
 
ujis_japanese_ci
188
 
SET @@session.collation_server = ujis_bin;
189
 
SELECT @@session.collation_server;
190
 
@@session.collation_server
191
 
ujis_bin
192
 
SET @@session.collation_server = sjis_japanese_ci;
193
 
SELECT @@session.collation_server;
194
 
@@session.collation_server
195
 
sjis_japanese_ci
196
 
SET @@session.collation_server = sjis_bin;
197
 
SELECT @@session.collation_server;
198
 
@@session.collation_server
199
 
sjis_bin
200
 
SET @@session.collation_server = hebrew_general_ci;
201
 
SELECT @@session.collation_server;
202
 
@@session.collation_server
203
 
hebrew_general_ci
204
 
SET @@session.collation_server = hebrew_bin;
205
 
SELECT @@session.collation_server;
206
 
@@session.collation_server
207
 
hebrew_bin
208
 
SET @@session.collation_server = tis620_thai_ci;
209
 
SELECT @@session.collation_server;
210
 
@@session.collation_server
211
 
tis620_thai_ci
212
 
SET @@session.collation_server = tis620_bin;
213
 
SELECT @@session.collation_server;
214
 
@@session.collation_server
215
 
tis620_bin
216
 
SET @@session.collation_server = euckr_korean_ci;
217
 
SELECT @@session.collation_server;
218
 
@@session.collation_server
219
 
euckr_korean_ci
220
 
SET @@session.collation_server = euckr_bin;
221
 
SELECT @@session.collation_server;
222
 
@@session.collation_server
223
 
euckr_bin
224
 
SET @@session.collation_server = koi8u_general_ci;
225
 
SELECT @@session.collation_server;
226
 
@@session.collation_server
227
 
koi8u_general_ci
228
 
SET @@session.collation_server = koi8u_bin;
229
 
SELECT @@session.collation_server;
230
 
@@session.collation_server
231
 
koi8u_bin
232
 
SET @@session.collation_server = gb2312_chinese_ci;
233
 
SELECT @@session.collation_server;
234
 
@@session.collation_server
235
 
gb2312_chinese_ci
236
 
SET @@session.collation_server = gb2312_bin;
237
 
SELECT @@session.collation_server;
238
 
@@session.collation_server
239
 
gb2312_bin
240
 
SET @@session.collation_server = greek_general_ci;
241
 
SELECT @@session.collation_server;
242
 
@@session.collation_server
243
 
greek_general_ci
244
 
SET @@session.collation_server = greek_bin;
245
 
SELECT @@session.collation_server;
246
 
@@session.collation_server
247
 
greek_bin
248
 
SET @@session.collation_server = cp1250_general_ci;
249
 
SELECT @@session.collation_server;
250
 
@@session.collation_server
251
 
cp1250_general_ci
252
 
SET @@session.collation_server = cp1250_czech_cs;
253
 
SELECT @@session.collation_server;
254
 
@@session.collation_server
255
 
cp1250_czech_cs
256
 
SET @@session.collation_server = cp1250_croatian_ci;
257
 
SELECT @@session.collation_server;
258
 
@@session.collation_server
259
 
cp1250_croatian_ci
260
 
SET @@session.collation_server = cp1250_bin;
261
 
SELECT @@session.collation_server;
262
 
@@session.collation_server
263
 
cp1250_bin
264
 
SET @@session.collation_server = cp1250_polish_ci;
265
 
SELECT @@session.collation_server;
266
 
@@session.collation_server
267
 
cp1250_polish_ci
268
 
SET @@session.collation_server = gbk_chinese_ci;
269
 
SELECT @@session.collation_server;
270
 
@@session.collation_server
271
 
gbk_chinese_ci
272
 
SET @@session.collation_server = gbk_bin;
273
 
SELECT @@session.collation_server;
274
 
@@session.collation_server
275
 
gbk_bin
276
 
SET @@session.collation_server = latin5_turkish_ci;
277
 
SELECT @@session.collation_server;
278
 
@@session.collation_server
279
 
latin5_turkish_ci
280
 
SET @@session.collation_server = latin5_bin;
281
 
SELECT @@session.collation_server;
282
 
@@session.collation_server
283
 
latin5_bin
284
 
SET @@session.collation_server = armscii8_general_ci;
285
 
SELECT @@session.collation_server;
286
 
@@session.collation_server
287
 
armscii8_general_ci
288
 
SET @@session.collation_server = armscii8_bin;
289
 
SELECT @@session.collation_server;
290
 
@@session.collation_server
291
 
armscii8_bin
292
 
SET @@session.collation_server = utf8_general_ci;
293
 
SELECT @@session.collation_server;
294
 
@@session.collation_server
295
 
utf8_general_ci
296
 
SET @@session.collation_server = utf8_bin;
297
 
SELECT @@session.collation_server;
298
 
@@session.collation_server
299
 
utf8_bin
300
 
SET @@session.collation_server = utf8_unicode_ci;
301
 
SELECT @@session.collation_server;
302
 
@@session.collation_server
303
 
utf8_unicode_ci
304
 
SET @@session.collation_server = utf8_icelandic_ci;
305
 
SELECT @@session.collation_server;
306
 
@@session.collation_server
307
 
utf8_icelandic_ci
308
 
SET @@session.collation_server = utf8_latvian_ci;
309
 
SELECT @@session.collation_server;
310
 
@@session.collation_server
311
 
utf8_latvian_ci
312
 
SET @@session.collation_server = utf8_romanian_ci;
313
 
SELECT @@session.collation_server;
314
 
@@session.collation_server
315
 
utf8_romanian_ci
316
 
SET @@session.collation_server = utf8_slovenian_ci;
317
 
SELECT @@session.collation_server;
318
 
@@session.collation_server
319
 
utf8_slovenian_ci
320
 
SET @@session.collation_server = utf8_polish_ci;
321
 
SELECT @@session.collation_server;
322
 
@@session.collation_server
323
 
utf8_polish_ci
324
 
SET @@session.collation_server = utf8_estonian_ci;
325
 
SELECT @@session.collation_server;
326
 
@@session.collation_server
327
 
utf8_estonian_ci
328
 
SET @@session.collation_server = utf8_spanish_ci;
329
 
SELECT @@session.collation_server;
330
 
@@session.collation_server
331
 
utf8_spanish_ci
332
 
SET @@session.collation_server = utf8_swedish_ci;
333
 
SELECT @@session.collation_server;
334
 
@@session.collation_server
335
 
utf8_swedish_ci
336
 
SET @@session.collation_server = utf8_turkish_ci;
337
 
SELECT @@session.collation_server;
338
 
@@session.collation_server
339
 
utf8_turkish_ci
340
 
SET @@session.collation_server = utf8_czech_ci;
341
 
SELECT @@session.collation_server;
342
 
@@session.collation_server
343
 
utf8_czech_ci
344
 
SET @@session.collation_server = utf8_danish_ci;
345
 
SELECT @@session.collation_server;
346
 
@@session.collation_server
347
 
utf8_danish_ci
348
 
SET @@session.collation_server = utf8_lithuanian_ci;
349
 
SELECT @@session.collation_server;
350
 
@@session.collation_server
351
 
utf8_lithuanian_ci
352
 
SET @@session.collation_server = utf8_slovak_ci;
353
 
SELECT @@session.collation_server;
354
 
@@session.collation_server
355
 
utf8_slovak_ci
356
 
SET @@session.collation_server = utf8_spanish2_ci;
357
 
SELECT @@session.collation_server;
358
 
@@session.collation_server
359
 
utf8_spanish2_ci
360
 
SET @@session.collation_server = utf8_roman_ci;
361
 
SELECT @@session.collation_server;
362
 
@@session.collation_server
363
 
utf8_roman_ci
364
 
SET @@session.collation_server = utf8_persian_ci;
365
 
SELECT @@session.collation_server;
366
 
@@session.collation_server
367
 
utf8_persian_ci
368
 
SET @@session.collation_server = utf8_esperanto_ci;
369
 
SELECT @@session.collation_server;
370
 
@@session.collation_server
371
 
utf8_esperanto_ci
372
 
SET @@session.collation_server = utf8_hungarian_ci;
373
 
SELECT @@session.collation_server;
374
 
@@session.collation_server
375
 
utf8_hungarian_ci
376
 
SET @@session.collation_server = ucs2_general_ci;
377
 
SELECT @@session.collation_server;
378
 
@@session.collation_server
379
 
ucs2_general_ci
380
 
SET @@session.collation_server = ucs2_bin;
381
 
SELECT @@session.collation_server;
382
 
@@session.collation_server
383
 
ucs2_bin
384
 
SET @@session.collation_server = ucs2_unicode_ci;
385
 
SELECT @@session.collation_server;
386
 
@@session.collation_server
387
 
ucs2_unicode_ci
388
 
SET @@session.collation_server = ucs2_icelandic_ci;
389
 
SELECT @@session.collation_server;
390
 
@@session.collation_server
391
 
ucs2_icelandic_ci
392
 
SET @@session.collation_server = ucs2_latvian_ci;
393
 
SELECT @@session.collation_server;
394
 
@@session.collation_server
395
 
ucs2_latvian_ci
396
 
SET @@session.collation_server = ucs2_romanian_ci;
397
 
SELECT @@session.collation_server;
398
 
@@session.collation_server
399
 
ucs2_romanian_ci
400
 
SET @@session.collation_server = ucs2_slovenian_ci;
401
 
SELECT @@session.collation_server;
402
 
@@session.collation_server
403
 
ucs2_slovenian_ci
404
 
SET @@session.collation_server = ucs2_polish_ci;
405
 
SELECT @@session.collation_server;
406
 
@@session.collation_server
407
 
ucs2_polish_ci
408
 
SET @@session.collation_server = ucs2_estonian_ci;
409
 
SELECT @@session.collation_server;
410
 
@@session.collation_server
411
 
ucs2_estonian_ci
412
 
SET @@session.collation_server = ucs2_spanish_ci;
413
 
SELECT @@session.collation_server;
414
 
@@session.collation_server
415
 
ucs2_spanish_ci
416
 
SET @@session.collation_server = ucs2_swedish_ci;
417
 
SELECT @@session.collation_server;
418
 
@@session.collation_server
419
 
ucs2_swedish_ci
420
 
SET @@session.collation_server = ucs2_turkish_ci;
421
 
SELECT @@session.collation_server;
422
 
@@session.collation_server
423
 
ucs2_turkish_ci
424
 
SET @@session.collation_server = ucs2_czech_ci;
425
 
SELECT @@session.collation_server;
426
 
@@session.collation_server
427
 
ucs2_czech_ci
428
 
SET @@session.collation_server = ucs2_danish_ci;
429
 
SELECT @@session.collation_server;
430
 
@@session.collation_server
431
 
ucs2_danish_ci
432
 
SET @@session.collation_server = ucs2_lithuanian_ci;
433
 
SELECT @@session.collation_server;
434
 
@@session.collation_server
435
 
ucs2_lithuanian_ci
436
 
SET @@session.collation_server = ucs2_slovak_ci;
437
 
SELECT @@session.collation_server;
438
 
@@session.collation_server
439
 
ucs2_slovak_ci
440
 
SET @@session.collation_server = ucs2_spanish2_ci;
441
 
SELECT @@session.collation_server;
442
 
@@session.collation_server
443
 
ucs2_spanish2_ci
444
 
SET @@session.collation_server = ucs2_roman_ci;
445
 
SELECT @@session.collation_server;
446
 
@@session.collation_server
447
 
ucs2_roman_ci
448
 
SET @@session.collation_server = ucs2_persian_ci;
449
 
SELECT @@session.collation_server;
450
 
@@session.collation_server
451
 
ucs2_persian_ci
452
 
SET @@session.collation_server = ucs2_esperanto_ci;
453
 
SELECT @@session.collation_server;
454
 
@@session.collation_server
455
 
ucs2_esperanto_ci
456
 
SET @@session.collation_server = ucs2_hungarian_ci;
457
 
SELECT @@session.collation_server;
458
 
@@session.collation_server
459
 
ucs2_hungarian_ci
460
 
SET @@session.collation_server = cp866_general_ci;
461
 
SELECT @@session.collation_server;
462
 
@@session.collation_server
463
 
cp866_general_ci
464
 
SET @@session.collation_server = cp866_bin;
465
 
SELECT @@session.collation_server;
466
 
@@session.collation_server
467
 
cp866_bin
468
 
SET @@session.collation_server = keybcs2_general_ci;
469
 
SELECT @@session.collation_server;
470
 
@@session.collation_server
471
 
keybcs2_general_ci
472
 
SET @@session.collation_server = keybcs2_bin;
473
 
SELECT @@session.collation_server;
474
 
@@session.collation_server
475
 
keybcs2_bin
476
 
SET @@session.collation_server = macce_general_ci;
477
 
SELECT @@session.collation_server;
478
 
@@session.collation_server
479
 
macce_general_ci
480
 
SET @@session.collation_server = macce_bin;
481
 
SELECT @@session.collation_server;
482
 
@@session.collation_server
483
 
macce_bin
484
 
SET @@session.collation_server = macroman_general_ci;
485
 
SELECT @@session.collation_server;
486
 
@@session.collation_server
487
 
macroman_general_ci
488
 
SET @@session.collation_server = macroman_bin;
489
 
SELECT @@session.collation_server;
490
 
@@session.collation_server
491
 
macroman_bin
492
 
SET @@session.collation_server = cp852_general_ci;
493
 
SELECT @@session.collation_server;
494
 
@@session.collation_server
495
 
cp852_general_ci
496
 
SET @@session.collation_server = cp852_bin;
497
 
SELECT @@session.collation_server;
498
 
@@session.collation_server
499
 
cp852_bin
500
 
SET @@session.collation_server = latin7_estonian_cs;
501
 
SELECT @@session.collation_server;
502
 
@@session.collation_server
503
 
latin7_estonian_cs
504
 
SET @@session.collation_server = latin7_general_ci;
505
 
SELECT @@session.collation_server;
506
 
@@session.collation_server
507
 
latin7_general_ci
508
 
SET @@session.collation_server = latin7_general_cs;
509
 
SELECT @@session.collation_server;
510
 
@@session.collation_server
511
 
latin7_general_cs
512
 
SET @@session.collation_server = latin7_bin;
513
 
SELECT @@session.collation_server;
514
 
@@session.collation_server
515
 
latin7_bin
516
 
SET @@session.collation_server = cp1251_bulgarian_ci;
517
 
SELECT @@session.collation_server;
518
 
@@session.collation_server
519
 
cp1251_bulgarian_ci
520
 
SET @@session.collation_server = cp1251_ukrainian_ci;
521
 
SELECT @@session.collation_server;
522
 
@@session.collation_server
523
 
cp1251_ukrainian_ci
524
 
SET @@session.collation_server = cp1251_bin;
525
 
SELECT @@session.collation_server;
526
 
@@session.collation_server
527
 
cp1251_bin
528
 
SET @@session.collation_server = cp1251_general_ci;
529
 
SELECT @@session.collation_server;
530
 
@@session.collation_server
531
 
cp1251_general_ci
532
 
SET @@session.collation_server = cp1251_general_cs;
533
 
SELECT @@session.collation_server;
534
 
@@session.collation_server
535
 
cp1251_general_cs
536
 
SET @@session.collation_server = cp1256_general_ci;
537
 
SELECT @@session.collation_server;
538
 
@@session.collation_server
539
 
cp1256_general_ci
540
 
SET @@session.collation_server = cp1256_bin;
541
 
SELECT @@session.collation_server;
542
 
@@session.collation_server
543
 
cp1256_bin
544
 
SET @@session.collation_server = cp1257_lithuanian_ci;
545
 
SELECT @@session.collation_server;
546
 
@@session.collation_server
547
 
cp1257_lithuanian_ci
548
 
SET @@session.collation_server = cp1257_bin;
549
 
SELECT @@session.collation_server;
550
 
@@session.collation_server
551
 
cp1257_bin
552
 
SET @@session.collation_server = cp1257_general_ci;
553
 
SELECT @@session.collation_server;
554
 
@@session.collation_server
555
 
cp1257_general_ci
556
 
SET @@session.collation_server = binary;
557
 
SELECT @@session.collation_server;
558
 
@@session.collation_server
559
 
binary
560
 
SET @@session.collation_server = geostd8_general_ci;
561
 
SELECT @@session.collation_server;
562
 
@@session.collation_server
563
 
geostd8_general_ci
564
 
SET @@session.collation_server = geostd8_bin;
565
 
SELECT @@session.collation_server;
566
 
@@session.collation_server
567
 
geostd8_bin
568
 
SET @@session.collation_server = cp932_japanese_ci;
569
 
SELECT @@session.collation_server;
570
 
@@session.collation_server
571
 
cp932_japanese_ci
572
 
SET @@session.collation_server = cp932_bin;
573
 
SELECT @@session.collation_server;
574
 
@@session.collation_server
575
 
cp932_bin
576
 
SET @@session.collation_server = eucjpms_japanese_ci;
577
 
SELECT @@session.collation_server;
578
 
@@session.collation_server
579
 
eucjpms_japanese_ci
580
 
SET @@session.collation_server = eucjpms_bin;
581
 
SELECT @@session.collation_server;
582
 
@@session.collation_server
583
 
eucjpms_bin
584
 
'#--------------------FN_DYNVARS_014_07-------------------------#'
585
 
SET @@global.collation_server = big5_chinese_ci;
586
 
SELECT @@global.collation_server;
587
 
@@global.collation_server
588
 
big5_chinese_ci
589
 
SET @@global.collation_server = big5_bin;
590
 
SELECT @@global.collation_server;
591
 
@@global.collation_server
592
 
big5_bin
593
 
SET @@global.collation_server = dec8_swedish_ci;
594
 
SELECT @@global.collation_server;
595
 
@@global.collation_server
596
 
dec8_swedish_ci
597
 
SET @@global.collation_server = dec8_bin;
598
 
SELECT @@global.collation_server;
599
 
@@global.collation_server
600
 
dec8_bin
601
 
SET @@global.collation_server = cp850_general_ci;
602
 
SELECT @@global.collation_server;
603
 
@@global.collation_server
604
 
cp850_general_ci
605
 
SET @@global.collation_server = cp850_bin;
606
 
SELECT @@global.collation_server;
607
 
@@global.collation_server
608
 
cp850_bin
609
 
SET @@global.collation_server = hp8_english_ci;
610
 
SELECT @@global.collation_server;
611
 
@@global.collation_server
612
 
hp8_english_ci
613
 
SET @@global.collation_server = hp8_bin;
614
 
SELECT @@global.collation_server;
615
 
@@global.collation_server
616
 
hp8_bin
617
 
SET @@global.collation_server = koi8r_general_ci;
618
 
SELECT @@global.collation_server;
619
 
@@global.collation_server
620
 
koi8r_general_ci
621
 
SET @@global.collation_server = koi8r_bin;
622
 
SELECT @@global.collation_server;
623
 
@@global.collation_server
624
 
koi8r_bin
625
 
SET @@global.collation_server = latin1_german1_ci;
626
 
SELECT @@global.collation_server;
627
 
@@global.collation_server
628
 
latin1_german1_ci
629
 
SET @@global.collation_server = latin1_swedish_ci;
630
 
SELECT @@global.collation_server;
631
 
@@global.collation_server
632
 
latin1_swedish_ci
633
 
SET @@global.collation_server = latin1_danish_ci;
634
 
SELECT @@global.collation_server;
635
 
@@global.collation_server
636
 
latin1_danish_ci
637
 
SET @@global.collation_server = latin1_german2_ci;
638
 
SELECT @@global.collation_server;
639
 
@@global.collation_server
640
 
latin1_german2_ci
641
 
SET @@global.collation_server = latin1_bin;
642
 
SELECT @@global.collation_server;
643
 
@@global.collation_server
644
 
latin1_bin
645
 
SET @@global.collation_server = latin1_general_ci;
646
 
SELECT @@global.collation_server;
647
 
@@global.collation_server
648
 
latin1_general_ci
649
 
SET @@global.collation_server = latin1_general_cs;
650
 
SELECT @@global.collation_server;
651
 
@@global.collation_server
652
 
latin1_general_cs
653
 
SET @@global.collation_server = latin1_spanish_ci;
654
 
SELECT @@global.collation_server;
655
 
@@global.collation_server
656
 
latin1_spanish_ci
657
 
SET @@global.collation_server = latin2_czech_cs;
658
 
SELECT @@global.collation_server;
659
 
@@global.collation_server
660
 
latin2_czech_cs
661
 
SET @@global.collation_server = latin2_general_ci;
662
 
SELECT @@global.collation_server;
663
 
@@global.collation_server
664
 
latin2_general_ci
665
 
SET @@global.collation_server = latin2_hungarian_ci;
666
 
SELECT @@global.collation_server;
667
 
@@global.collation_server
668
 
latin2_hungarian_ci
669
 
SET @@global.collation_server = latin2_croatian_ci;
670
 
SELECT @@global.collation_server;
671
 
@@global.collation_server
672
 
latin2_croatian_ci
673
 
SET @@global.collation_server = latin2_bin;
674
 
SELECT @@global.collation_server;
675
 
@@global.collation_server
676
 
latin2_bin
677
 
SET @@global.collation_server = swe7_swedish_ci;
678
 
SELECT @@global.collation_server;
679
 
@@global.collation_server
680
 
swe7_swedish_ci
681
 
SET @@global.collation_server = swe7_bin;
682
 
SELECT @@global.collation_server;
683
 
@@global.collation_server
684
 
swe7_bin
685
 
SET @@global.collation_server = ascii_general_ci;
686
 
SELECT @@global.collation_server;
687
 
@@global.collation_server
688
 
ascii_general_ci
689
 
SET @@global.collation_server = ascii_bin;
690
 
SELECT @@global.collation_server;
691
 
@@global.collation_server
692
 
ascii_bin
693
 
SET @@global.collation_server = ujis_japanese_ci;
694
 
SELECT @@global.collation_server;
695
 
@@global.collation_server
696
 
ujis_japanese_ci
697
 
SET @@global.collation_server = ujis_bin;
698
 
SELECT @@global.collation_server;
699
 
@@global.collation_server
700
 
ujis_bin
701
 
SET @@global.collation_server = sjis_japanese_ci;
702
 
SELECT @@global.collation_server;
703
 
@@global.collation_server
704
 
sjis_japanese_ci
705
 
SET @@global.collation_server = sjis_bin;
706
 
SELECT @@global.collation_server;
707
 
@@global.collation_server
708
 
sjis_bin
709
 
SET @@global.collation_server = hebrew_general_ci;
710
 
SELECT @@global.collation_server;
711
 
@@global.collation_server
712
 
hebrew_general_ci
713
 
SET @@global.collation_server = hebrew_bin;
714
 
SELECT @@global.collation_server;
715
 
@@global.collation_server
716
 
hebrew_bin
717
 
SET @@global.collation_server = tis620_thai_ci;
718
 
SELECT @@global.collation_server;
719
 
@@global.collation_server
720
 
tis620_thai_ci
721
 
SET @@global.collation_server = tis620_bin;
722
 
SELECT @@global.collation_server;
723
 
@@global.collation_server
724
 
tis620_bin
725
 
SET @@global.collation_server = euckr_korean_ci;
726
 
SELECT @@global.collation_server;
727
 
@@global.collation_server
728
 
euckr_korean_ci
729
 
SET @@global.collation_server = euckr_bin;
730
 
SELECT @@global.collation_server;
731
 
@@global.collation_server
732
 
euckr_bin
733
 
SET @@global.collation_server = koi8u_general_ci;
734
 
SELECT @@global.collation_server;
735
 
@@global.collation_server
736
 
koi8u_general_ci
737
 
SET @@global.collation_server = koi8u_bin;
738
 
SELECT @@global.collation_server;
739
 
@@global.collation_server
740
 
koi8u_bin
741
 
SET @@global.collation_server = gb2312_chinese_ci;
742
 
SELECT @@global.collation_server;
743
 
@@global.collation_server
744
 
gb2312_chinese_ci
745
 
SET @@global.collation_server = gb2312_bin;
746
 
SELECT @@global.collation_server;
747
 
@@global.collation_server
748
 
gb2312_bin
749
 
SET @@global.collation_server = greek_general_ci;
750
 
SELECT @@global.collation_server;
751
 
@@global.collation_server
752
 
greek_general_ci
753
 
SET @@global.collation_server = greek_bin;
754
 
SELECT @@global.collation_server;
755
 
@@global.collation_server
756
 
greek_bin
757
 
SET @@global.collation_server = cp1250_general_ci;
758
 
SELECT @@global.collation_server;
759
 
@@global.collation_server
760
 
cp1250_general_ci
761
 
SET @@global.collation_server = cp1250_czech_cs;
762
 
SELECT @@global.collation_server;
763
 
@@global.collation_server
764
 
cp1250_czech_cs
765
 
SET @@global.collation_server = cp1250_croatian_ci;
766
 
SELECT @@global.collation_server;
767
 
@@global.collation_server
768
 
cp1250_croatian_ci
769
 
SET @@global.collation_server = cp1250_bin;
770
 
SELECT @@global.collation_server;
771
 
@@global.collation_server
772
 
cp1250_bin
773
 
SET @@global.collation_server = cp1250_polish_ci;
774
 
SELECT @@global.collation_server;
775
 
@@global.collation_server
776
 
cp1250_polish_ci
777
 
SET @@global.collation_server = gbk_chinese_ci;
778
 
SELECT @@global.collation_server;
779
 
@@global.collation_server
780
 
gbk_chinese_ci
781
 
SET @@global.collation_server = gbk_bin;
782
 
SELECT @@global.collation_server;
783
 
@@global.collation_server
784
 
gbk_bin
785
 
SET @@global.collation_server = latin5_turkish_ci;
786
 
SELECT @@global.collation_server;
787
 
@@global.collation_server
788
 
latin5_turkish_ci
789
 
SET @@global.collation_server = latin5_bin;
790
 
SELECT @@global.collation_server;
791
 
@@global.collation_server
792
 
latin5_bin
793
 
SET @@global.collation_server = armscii8_general_ci;
794
 
SELECT @@global.collation_server;
795
 
@@global.collation_server
796
 
armscii8_general_ci
797
 
SET @@global.collation_server = armscii8_bin;
798
 
SELECT @@global.collation_server;
799
 
@@global.collation_server
800
 
armscii8_bin
801
 
SET @@global.collation_server = utf8_general_ci;
802
 
SELECT @@global.collation_server;
803
 
@@global.collation_server
804
 
utf8_general_ci
805
 
SET @@global.collation_server = utf8_bin;
806
 
SELECT @@global.collation_server;
807
 
@@global.collation_server
808
 
utf8_bin
809
 
SET @@global.collation_server = utf8_unicode_ci;
810
 
SELECT @@global.collation_server;
811
 
@@global.collation_server
812
 
utf8_unicode_ci
813
 
SET @@global.collation_server = utf8_icelandic_ci;
814
 
SELECT @@global.collation_server;
815
 
@@global.collation_server
816
 
utf8_icelandic_ci
817
 
SET @@global.collation_server = utf8_latvian_ci;
818
 
SELECT @@global.collation_server;
819
 
@@global.collation_server
820
 
utf8_latvian_ci
821
 
SET @@global.collation_server = utf8_romanian_ci;
822
 
SELECT @@global.collation_server;
823
 
@@global.collation_server
824
 
utf8_romanian_ci
825
 
SET @@global.collation_server = utf8_slovenian_ci;
826
 
SELECT @@global.collation_server;
827
 
@@global.collation_server
828
 
utf8_slovenian_ci
829
 
SET @@global.collation_server = utf8_polish_ci;
830
 
SELECT @@global.collation_server;
831
 
@@global.collation_server
832
 
utf8_polish_ci
833
 
SET @@global.collation_server = utf8_estonian_ci;
834
 
SELECT @@global.collation_server;
835
 
@@global.collation_server
836
 
utf8_estonian_ci
837
 
SET @@global.collation_server = utf8_spanish_ci;
838
 
SELECT @@global.collation_server;
839
 
@@global.collation_server
840
 
utf8_spanish_ci
841
 
SET @@global.collation_server = utf8_swedish_ci;
842
 
SELECT @@global.collation_server;
843
 
@@global.collation_server
844
 
utf8_swedish_ci
845
 
SET @@global.collation_server = utf8_turkish_ci;
846
 
SELECT @@global.collation_server;
847
 
@@global.collation_server
848
 
utf8_turkish_ci
849
 
SET @@global.collation_server = utf8_czech_ci;
850
 
SELECT @@global.collation_server;
851
 
@@global.collation_server
852
 
utf8_czech_ci
853
 
SET @@global.collation_server = utf8_danish_ci;
854
 
SELECT @@global.collation_server;
855
 
@@global.collation_server
856
 
utf8_danish_ci
857
 
SET @@global.collation_server = utf8_lithuanian_ci;
858
 
SELECT @@global.collation_server;
859
 
@@global.collation_server
860
 
utf8_lithuanian_ci
861
 
SET @@global.collation_server = utf8_slovak_ci;
862
 
SELECT @@global.collation_server;
863
 
@@global.collation_server
864
 
utf8_slovak_ci
865
 
SET @@global.collation_server = utf8_spanish2_ci;
866
 
SELECT @@global.collation_server;
867
 
@@global.collation_server
868
 
utf8_spanish2_ci
869
 
SET @@global.collation_server = utf8_roman_ci;
870
 
SELECT @@global.collation_server;
871
 
@@global.collation_server
872
 
utf8_roman_ci
873
 
SET @@global.collation_server = utf8_persian_ci;
874
 
SELECT @@global.collation_server;
875
 
@@global.collation_server
876
 
utf8_persian_ci
877
 
SET @@global.collation_server = utf8_esperanto_ci;
878
 
SELECT @@global.collation_server;
879
 
@@global.collation_server
880
 
utf8_esperanto_ci
881
 
SET @@global.collation_server = utf8_hungarian_ci;
882
 
SELECT @@global.collation_server;
883
 
@@global.collation_server
884
 
utf8_hungarian_ci
885
 
SET @@global.collation_server = ucs2_general_ci;
886
 
SELECT @@global.collation_server;
887
 
@@global.collation_server
888
 
ucs2_general_ci
889
 
SET @@global.collation_server = ucs2_bin;
890
 
SELECT @@global.collation_server;
891
 
@@global.collation_server
892
 
ucs2_bin
893
 
SET @@global.collation_server = ucs2_unicode_ci;
894
 
SELECT @@global.collation_server;
895
 
@@global.collation_server
896
 
ucs2_unicode_ci
897
 
SET @@global.collation_server = ucs2_icelandic_ci;
898
 
SELECT @@global.collation_server;
899
 
@@global.collation_server
900
 
ucs2_icelandic_ci
901
 
SET @@global.collation_server = ucs2_latvian_ci;
902
 
SELECT @@global.collation_server;
903
 
@@global.collation_server
904
 
ucs2_latvian_ci
905
 
SET @@global.collation_server = ucs2_romanian_ci;
906
 
SELECT @@global.collation_server;
907
 
@@global.collation_server
908
 
ucs2_romanian_ci
909
 
SET @@global.collation_server = ucs2_slovenian_ci;
910
 
SELECT @@global.collation_server;
911
 
@@global.collation_server
912
 
ucs2_slovenian_ci
913
 
SET @@global.collation_server = ucs2_polish_ci;
914
 
SELECT @@global.collation_server;
915
 
@@global.collation_server
916
 
ucs2_polish_ci
917
 
SET @@global.collation_server = ucs2_estonian_ci;
918
 
SELECT @@global.collation_server;
919
 
@@global.collation_server
920
 
ucs2_estonian_ci
921
 
SET @@global.collation_server = ucs2_spanish_ci;
922
 
SELECT @@global.collation_server;
923
 
@@global.collation_server
924
 
ucs2_spanish_ci
925
 
SET @@global.collation_server = ucs2_swedish_ci;
926
 
SELECT @@global.collation_server;
927
 
@@global.collation_server
928
 
ucs2_swedish_ci
929
 
SET @@global.collation_server = ucs2_turkish_ci;
930
 
SELECT @@global.collation_server;
931
 
@@global.collation_server
932
 
ucs2_turkish_ci
933
 
SET @@global.collation_server = ucs2_czech_ci;
934
 
SELECT @@global.collation_server;
935
 
@@global.collation_server
936
 
ucs2_czech_ci
937
 
SET @@global.collation_server = ucs2_danish_ci;
938
 
SELECT @@global.collation_server;
939
 
@@global.collation_server
940
 
ucs2_danish_ci
941
 
SET @@global.collation_server = ucs2_lithuanian_ci;
942
 
SELECT @@global.collation_server;
943
 
@@global.collation_server
944
 
ucs2_lithuanian_ci
945
 
SET @@global.collation_server = ucs2_slovak_ci;
946
 
SELECT @@global.collation_server;
947
 
@@global.collation_server
948
 
ucs2_slovak_ci
949
 
SET @@global.collation_server = ucs2_spanish2_ci;
950
 
SELECT @@global.collation_server;
951
 
@@global.collation_server
952
 
ucs2_spanish2_ci
953
 
SET @@global.collation_server = ucs2_roman_ci;
954
 
SELECT @@global.collation_server;
955
 
@@global.collation_server
956
 
ucs2_roman_ci
957
 
SET @@global.collation_server = ucs2_persian_ci;
958
 
SELECT @@global.collation_server;
959
 
@@global.collation_server
960
 
ucs2_persian_ci
961
 
SET @@global.collation_server = ucs2_esperanto_ci;
962
 
SELECT @@global.collation_server;
963
 
@@global.collation_server
964
 
ucs2_esperanto_ci
965
 
SET @@global.collation_server = ucs2_hungarian_ci;
966
 
SELECT @@global.collation_server;
967
 
@@global.collation_server
968
 
ucs2_hungarian_ci
969
 
SET @@global.collation_server = cp866_general_ci;
970
 
SELECT @@global.collation_server;
971
 
@@global.collation_server
972
 
cp866_general_ci
973
 
SET @@global.collation_server = cp866_bin;
974
 
SELECT @@global.collation_server;
975
 
@@global.collation_server
976
 
cp866_bin
977
 
SET @@global.collation_server = keybcs2_general_ci;
978
 
SELECT @@global.collation_server;
979
 
@@global.collation_server
980
 
keybcs2_general_ci
981
 
SET @@global.collation_server = keybcs2_bin;
982
 
SELECT @@global.collation_server;
983
 
@@global.collation_server
984
 
keybcs2_bin
985
 
SET @@global.collation_server = macce_general_ci;
986
 
SELECT @@global.collation_server;
987
 
@@global.collation_server
988
 
macce_general_ci
989
 
SET @@global.collation_server = macce_bin;
990
 
SELECT @@global.collation_server;
991
 
@@global.collation_server
992
 
macce_bin
993
 
SET @@global.collation_server = macroman_general_ci;
994
 
SELECT @@global.collation_server;
995
 
@@global.collation_server
996
 
macroman_general_ci
997
 
SET @@global.collation_server = macroman_bin;
998
 
SELECT @@global.collation_server;
999
 
@@global.collation_server
1000
 
macroman_bin
1001
 
SET @@global.collation_server = cp852_general_ci;
1002
 
SELECT @@global.collation_server;
1003
 
@@global.collation_server
1004
 
cp852_general_ci
1005
 
SET @@global.collation_server = cp852_bin;
1006
 
SELECT @@global.collation_server;
1007
 
@@global.collation_server
1008
 
cp852_bin
1009
 
SET @@global.collation_server = latin7_estonian_cs;
1010
 
SELECT @@global.collation_server;
1011
 
@@global.collation_server
1012
 
latin7_estonian_cs
1013
 
SET @@global.collation_server = latin7_general_ci;
1014
 
SELECT @@global.collation_server;
1015
 
@@global.collation_server
1016
 
latin7_general_ci
1017
 
SET @@global.collation_server = latin7_general_cs;
1018
 
SELECT @@global.collation_server;
1019
 
@@global.collation_server
1020
 
latin7_general_cs
1021
 
SET @@global.collation_server = latin7_bin;
1022
 
SELECT @@global.collation_server;
1023
 
@@global.collation_server
1024
 
latin7_bin
1025
 
SET @@global.collation_server = cp1251_bulgarian_ci;
1026
 
SELECT @@global.collation_server;
1027
 
@@global.collation_server
1028
 
cp1251_bulgarian_ci
1029
 
SET @@global.collation_server = cp1251_ukrainian_ci;
1030
 
SELECT @@global.collation_server;
1031
 
@@global.collation_server
1032
 
cp1251_ukrainian_ci
1033
 
SET @@global.collation_server = cp1251_bin;
1034
 
SELECT @@global.collation_server;
1035
 
@@global.collation_server
1036
 
cp1251_bin
1037
 
SET @@global.collation_server = cp1251_general_ci;
1038
 
SELECT @@global.collation_server;
1039
 
@@global.collation_server
1040
 
cp1251_general_ci
1041
 
SET @@global.collation_server = cp1251_general_cs;
1042
 
SELECT @@global.collation_server;
1043
 
@@global.collation_server
1044
 
cp1251_general_cs
1045
 
SET @@global.collation_server = cp1256_general_ci;
1046
 
SELECT @@global.collation_server;
1047
 
@@global.collation_server
1048
 
cp1256_general_ci
1049
 
SET @@global.collation_server = cp1256_bin;
1050
 
SELECT @@global.collation_server;
1051
 
@@global.collation_server
1052
 
cp1256_bin
1053
 
SET @@global.collation_server = cp1257_lithuanian_ci;
1054
 
SELECT @@global.collation_server;
1055
 
@@global.collation_server
1056
 
cp1257_lithuanian_ci
1057
 
SET @@global.collation_server = cp1257_bin;
1058
 
SELECT @@global.collation_server;
1059
 
@@global.collation_server
1060
 
cp1257_bin
1061
 
SET @@global.collation_server = cp1257_general_ci;
1062
 
SELECT @@global.collation_server;
1063
 
@@global.collation_server
1064
 
cp1257_general_ci
1065
 
SET @@global.collation_server = binary;
1066
 
SELECT @@global.collation_server;
1067
 
@@global.collation_server
1068
 
binary
1069
 
SET @@global.collation_server = geostd8_general_ci;
1070
 
SELECT @@global.collation_server;
1071
 
@@global.collation_server
1072
 
geostd8_general_ci
1073
 
SET @@global.collation_server = geostd8_bin;
1074
 
SELECT @@global.collation_server;
1075
 
@@global.collation_server
1076
 
geostd8_bin
1077
 
SET @@global.collation_server = cp932_japanese_ci;
1078
 
SELECT @@global.collation_server;
1079
 
@@global.collation_server
1080
 
cp932_japanese_ci
1081
 
SET @@global.collation_server = cp932_bin;
1082
 
SELECT @@global.collation_server;
1083
 
@@global.collation_server
1084
 
cp932_bin
1085
 
SET @@global.collation_server = eucjpms_japanese_ci;
1086
 
SELECT @@global.collation_server;
1087
 
@@global.collation_server
1088
 
eucjpms_japanese_ci
1089
 
SET @@global.collation_server = eucjpms_bin;
1090
 
SELECT @@global.collation_server;
1091
 
@@global.collation_server
1092
 
eucjpms_bin
1093
 
'#--------------------FN_DYNVARS_014_08-------------------------#'
1094
 
SET @@collation_server = LATIN7_GENERAL_CS;
1095
 
SELECT @@collation_server;
1096
 
@@collation_server
1097
 
latin7_general_cs
1098
 
SET @@collation_server = latin7_general_cs;
1099
 
SELECT @@collation_server;
1100
 
@@collation_server
1101
 
latin7_general_cs
1102
 
SET @@global.collation_server = Latin7_GeneRal_cS;
1103
 
SELECT @@global.collation_server;
1104
 
@@global.collation_server
1105
 
latin7_general_cs
1106
 
'#--------------------FN_DYNVARS_014_09-------------------------#'
1107
 
SET @@collation_server = 1;
1108
 
SELECT @@collation_server;
1109
 
@@collation_server
1110
 
big5_chinese_ci
1111
 
SET @@collation_server = 2;
1112
 
SELECT @@collation_server;
1113
 
@@collation_server
1114
 
latin2_czech_cs
1115
 
SET @@collation_server = 3;
1116
 
SELECT @@collation_server;
1117
 
@@collation_server
1118
 
dec8_swedish_ci
1119
 
SET @@collation_server = 99;
1120
 
SELECT @@collation_server;
1121
 
@@collation_server
1122
 
cp1250_polish_ci
1123
 
SET @@collation_server = 100;
1124
 
ERROR HY000: Unknown collation: '100'
1125
 
SET @@global.collation_server = 1;
1126
 
SELECT @@global.collation_server;
1127
 
@@global.collation_server
1128
 
big5_chinese_ci
1129
 
SET @@global.collation_server = 2;
1130
 
SELECT @@global.collation_server;
1131
 
@@global.collation_server
1132
 
latin2_czech_cs
1133
 
SET @@global.collation_server = 3;
1134
 
SELECT @@global.collation_server;
1135
 
@@global.collation_server
1136
 
dec8_swedish_ci
1137
 
SET @@global.collation_server = 99;
1138
 
SELECT @@global.collation_server;
1139
 
@@global.collation_server
1140
 
cp1250_polish_ci
1141
 
SET @@global.collation_server = 100;
1142
 
ERROR HY000: Unknown collation: '100'
1143
 
SET @total_collations = (SELECT count(*) FROM INFORMATION_SCHEMA.COLLATIONS);
1144
 
SELECT @total_collations > 120;
1145
 
@total_collations > 120
1146
 
1
1147
 
'#--------------------FN_DYNVARS_014_10-------------------------#'
1148
 
SET @@collation_server = latin7_binary;
1149
 
ERROR HY000: Unknown collation: 'latin7_binary'
1150
 
SET @@collation_server = 'eucjpms_japanese_cs';
1151
 
ERROR HY000: Unknown collation: 'eucjpms_japanese_cs'
1152
 
SET @@collation_server = 0;
1153
 
ERROR HY000: Unknown collation: '0'
1154
 
SET @@collation_server = 1.01;
1155
 
ERROR 42000: Incorrect argument type to variable 'collation_server'
1156
 
SET @@collation_server = -1;
1157
 
ERROR HY000: Unknown collation: '-1'
1158
 
SET @@collation_server = '';
1159
 
ERROR HY000: Unknown collation: ''
1160
 
SET @@collation_server = ' eucjpms_bin';
1161
 
ERROR HY000: Unknown collation: ' eucjpms_bin'
1162
 
SET @@collation_server = true;
1163
 
SELECT @@collation_server AS res_with_true;
1164
 
res_with_true
1165
 
big5_chinese_ci
1166
 
SET @@collation_server = ON;
1167
 
ERROR HY000: Unknown collation: 'ON'
1168
 
'#--------------------FN_DYNVARS_014_11-------------------------#'
1169
 
SET @@global.collation_server = latin7_binary;
1170
 
ERROR HY000: Unknown collation: 'latin7_binary'
1171
 
SET @@global.collation_server = 'eucjpms_japanese_cs';
1172
 
ERROR HY000: Unknown collation: 'eucjpms_japanese_cs'
1173
 
SET @@global.collation_server = 0;
1174
 
ERROR HY000: Unknown collation: '0'
1175
 
SET @@global.collation_server = 1.1;
1176
 
ERROR 42000: Incorrect argument type to variable 'collation_server'
1177
 
SET @@global.collation_server = -1;
1178
 
ERROR HY000: Unknown collation: '-1'
1179
 
SET @@global.collation_server = "";
1180
 
ERROR HY000: Unknown collation: ''
1181
 
SET @@global.collation_server = ' eucjpms_bin';
1182
 
ERROR HY000: Unknown collation: ' eucjpms_bin'
1183
 
SET @@global.collation_server = true;
1184
 
SET @@global.collation_server = ON;
1185
 
ERROR HY000: Unknown collation: 'ON'
1186
 
'#--------------------FN_DYNVARS_014_12-------------------------#'
1187
 
SELECT @@global.collation_server =
1188
 
(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
1189
 
WHERE VARIABLE_NAME='collation_server') AS res;
1190
 
res
1191
 
1
1192
 
SET @@global.collation_server = 1;
1193
 
SELECT @@global.collation_server;
1194
 
@@global.collation_server
1195
 
big5_chinese_ci
1196
 
SELECT @@global.collation_server =
1197
 
(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
1198
 
WHERE VARIABLE_NAME='collation_server') AS res;
1199
 
res
1200
 
1
1201
 
'#--------------------FN_DYNVARS_014_13-------------------------#'
1202
 
SELECT @@collation_server =
1203
 
(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1204
 
WHERE VARIABLE_NAME='collation_server') AS res;
1205
 
res
1206
 
1
1207
 
SELECT @@local.collation_server =
1208
 
(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1209
 
WHERE VARIABLE_NAME='collation_server') AS res;
1210
 
res
1211
 
1
1212
 
SELECT @@session.collation_server =
1213
 
(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
1214
 
WHERE VARIABLE_NAME='collation_server') AS res;
1215
 
res
1216
 
1
1217
 
SET @@global.collation_server = @global_start_value;
1218
 
SELECT @@global.collation_server;
1219
 
@@global.collation_server
1220
 
latin1_swedish_ci
1221
 
SET @@session.collation_server = @session_start_value;
1222
 
SELECT @@session.collation_server;
1223
 
@@session.collation_server
1224
 
latin1_swedish_ci