Debian Codegraph @

mysql-test/suite/funcs_2/charset/charset_master.test

raw
1 #################################################################################
2 # Author: Serge Kozlov #
3 # Date: 2005-09-21 #
4 # Purpose: used by ../t/*_charset.test #
5 # Require: set $engine_type= [NDB,MyISAM,InnoDB,etc] before calling #
6 # #
7 # Last modification: Matthias Leich #
8 # Date: 2008-07-02 #
9 # Purpose: Fix Bug#37160 funcs_2: The tests do not check if optional character #
10 # sets exist. #
11 # Add checking of prerequisites + minor cleanup #
12 #################################################################################
13
14 #
15 #
16 #
17
18 let $test_charset_name=
19 `select DEFAULT_CHARACTER_SET_NAME from information_schema.schemata
20 where SCHEMA_NAME = 'test'`;
21
22 # Check that all character sets needed are available
23 # Note(mleich):
24 # It is intentional that the common solution with
25 # "--source include/have_<character set>.inc"
26 # is not applied.
27 # - We currently do not have such a prerequisite test for every character set
28 # /collation needed.
29 # - There is also no real value in mentioning the first missing character set
30 # /collation within the "skip message" because it is most probably only
31 # one of many.
32 #
33 # Hint: 5 character_set_names per source line if possible
34 if (`SELECT COUNT(*) <> 37 FROM information_schema.character_sets
35 WHERE CHARACTER_SET_NAME IN (
36 'armscii8', 'ascii' , 'big5' , 'binary' , 'cp1250',
37 'cp1251' , 'cp1256' , 'cp1257' , 'cp850' , 'cp852' ,
38 'cp866' , 'cp932' , 'dec8' , 'eucjpms', 'euckr' ,
39 'gb2312' , 'gbk' , 'geostd8', 'greek' , 'hebrew',
40 'hp8' , 'keybcs2', 'koi8r' , 'koi8u' , 'latin1',
41 'latin2' , 'latin5' , 'latin7' , 'macce' , 'macroman',
42 'sjis' , 'swe7' , 'tis620' , 'ucs2' , 'ujis',
43 'utf8mb3' , 'gb18030'
44 )`)
45 {
46 --die Not all character sets required for this test are present
47 }
48 # Check that all collations needed are available
49 # Hint: 4 collation_names per source line if possible
50 if (`SELECT COUNT(*) <> 125 FROM information_schema.collations
51 WHERE collation_name IN (
52 'armscii8_bin', 'armscii8_general_ci', 'ascii_bin', 'ascii_general_ci',
53 'big5_bin', 'big5_chinese_ci', 'cp1250_bin', 'cp1250_croatian_ci',
54 'cp1250_czech_cs', 'cp1250_general_ci', 'cp1251_bin', 'cp1251_bulgarian_ci',
55 'cp1251_general_ci', 'cp1251_general_cs', 'cp1251_ukrainian_ci', 'cp1256_bin',
56 'cp1256_general_ci', 'cp1257_bin', 'cp1257_general_ci', 'cp1257_lithuanian_ci',
57 'cp850_bin', 'cp850_general_ci', 'cp852_bin', 'cp852_general_ci',
58 'cp866_bin', 'cp866_general_ci', 'cp932_bin', 'cp932_japanese_ci',
59 'dec8_bin', 'dec8_swedish_ci', 'eucjpms_bin', 'eucjpms_japanese_ci',
60 'euckr_bin', 'euckr_korean_ci', 'gb2312_bin', 'gb2312_chinese_ci',
61 'gbk_bin', 'gbk_chinese_ci', 'geostd8_bin', 'geostd8_general_ci',
62 'greek_bin', 'greek_general_ci', 'hebrew_bin', 'hebrew_general_ci',
63 'hp8_bin', 'hp8_english_ci', 'keybcs2_bin', 'keybcs2_general_ci',
64 'koi8r_bin', 'koi8r_general_ci', 'koi8u_bin', 'koi8u_general_ci',
65 'latin1_bin', 'latin1_danish_ci', 'latin1_general_ci', 'latin1_general_cs',
66 'latin1_german1_ci', 'latin1_german2_ci', 'latin1_spanish_ci', 'latin1_swedish_ci',
67 'latin2_bin', 'latin2_croatian_ci', 'latin2_czech_cs', 'latin2_general_ci',
68 'latin2_hungarian_ci', 'latin5_bin', 'latin5_turkish_ci', 'latin7_bin',
69 'latin7_estonian_cs', 'latin7_general_ci', 'latin7_general_cs', 'macce_bin',
70 'macce_general_ci', 'macroman_bin', 'macroman_general_ci', 'sjis_bin',
71 'sjis_japanese_ci', 'swe7_bin', 'swe7_swedish_ci', 'tis620_bin',
72 'tis620_thai_ci', 'ucs2_bin', 'ucs2_czech_ci', 'ucs2_danish_ci',
73 'ucs2_estonian_ci', 'ucs2_general_ci', 'ucs2_hungarian_ci', 'ucs2_icelandic_ci',
74 'ucs2_latvian_ci', 'ucs2_lithuanian_ci', 'ucs2_persian_ci', 'ucs2_polish_ci',
75 'ucs2_roman_ci', 'ucs2_romanian_ci', 'ucs2_slovak_ci', 'ucs2_slovenian_ci',
76 'ucs2_spanish2_ci', 'ucs2_spanish_ci', 'ucs2_swedish_ci', 'ucs2_turkish_ci',
77 'ucs2_unicode_ci', 'ujis_bin', 'ujis_japanese_ci', 'utf8mb3_bin',
78 'utf8mb3_czech_ci', 'utf8mb3_danish_ci', 'utf8mb3_estonian_ci', 'utf8mb3_general_ci',
79 'utf8mb3_hungarian_ci', 'utf8mb3_icelandic_ci', 'utf8mb3_latvian_ci', 'utf8mb3_lithuanian_ci',
80 'utf8mb3_persian_ci', 'utf8mb3_polish_ci', 'utf8mb3_roman_ci', 'utf8mb3_romanian_ci',
81 'utf8mb3_slovak_ci', 'utf8mb3_slovenian_ci', 'utf8mb3_spanish2_ci', 'utf8mb3_spanish_ci',
82 'utf8mb3_swedish_ci', 'utf8mb3_turkish_ci', 'utf8mb3_unicode_ci', 'gb18030_bin',
83 'gb18030_chinese_ci'
84 )`)
85 {
86 --die Not all collations required for this test are present
87 }
88
89 ################################
90 let $check_std_csets= 1;
91 let $check_ucs2_csets= 1;
92 let $check_utf8_csets= 1;
93
94 # Bug#32784: Timeout in test "innodb_charset": InnoDB much slower
95 # than other handlers
96 # NOTE: We turn autocommit off to improve the performance of the innodb variant
97 # of this test. Per Innobase's recommendation.
98
99 --disable_query_log
100 SET autocommit=0;
101 --enable_query_log
102
103 #
104 # Check all charsets/collation combinations
105 #
106
107 ################################
108 let $check_std_csets= 1;
109 let $check_ucs2_csets= 1;
110 let $check_utf8_csets= 1;
111
112 #
113 # Check all charsets/collation combinations
114 #
115
116 if ($check_std_csets)
117 {
118
119 # armscii8
120
121 let $cset= armscii8;
122 let $coll= armscii8_bin;
123 --source suite/funcs_2/include/check_charset.inc
124
125 let $cset= armscii8;
126 let $coll= armscii8_general_ci;
127 --source suite/funcs_2/include/check_charset.inc
128
129 # ascii
130
131 let $cset= ascii;
132 let $coll= ascii_bin;
133 --source suite/funcs_2/include/check_charset.inc
134
135 let $cset= ascii;
136 let $coll= ascii_general_ci;
137 --source suite/funcs_2/include/check_charset.inc
138
139 # big5
140
141 let $cset= big5;
142 let $coll= big5_bin;
143 --source suite/funcs_2/include/check_charset.inc
144
145 let $cset= big5;
146 let $coll= big5_chinese_ci;
147 --source suite/funcs_2/include/check_charset.inc
148
149 # binary
150
151 let $cset= binary;
152 let $coll= ;
153 let $bin_cset= 1;
154 --source suite/funcs_2/include/check_charset.inc
155
156 # cp1250
157
158 let $cset= cp1250;
159 let $coll= cp1250_bin;
160 --source suite/funcs_2/include/check_charset.inc
161
162 let $cset= cp1250;
163 let $coll= cp1250_croatian_ci;
164 --source suite/funcs_2/include/check_charset.inc
165
166
167 let $cset= cp1250;
168 let $coll= cp1250_czech_cs;
169 --source suite/funcs_2/include/check_charset.inc
170
171
172 let $cset= cp1250;
173 let $coll= cp1250_general_ci;
174 --source suite/funcs_2/include/check_charset.inc
175
176 # cp1251
177
178 let $cset= cp1251;
179 let $coll= cp1251_bin;
180 --source suite/funcs_2/include/check_charset.inc
181
182 let $cset= cp1251;
183 let $coll= cp1251_bulgarian_ci;
184 --source suite/funcs_2/include/check_charset.inc
185
186 let $cset= cp1251;
187 let $coll= cp1251_general_ci;
188 --source suite/funcs_2/include/check_charset.inc
189
190 let $cset= cp1251;
191 let $coll= cp1251_general_cs;
192 --source suite/funcs_2/include/check_charset.inc
193
194 let $cset= cp1251;
195 let $coll= cp1251_ukrainian_ci;
196 --source suite/funcs_2/include/check_charset.inc
197
198 # cp1256
199
200 let $cset= cp1256;
201 let $coll= cp1256_bin;
202 --source suite/funcs_2/include/check_charset.inc
203
204 let $cset= cp1256;
205 let $coll= cp1256_general_ci;
206 --source suite/funcs_2/include/check_charset.inc
207
208 # cp1257
209
210 let $cset= cp1257;
211 let $coll= cp1257_bin;
212 --source suite/funcs_2/include/check_charset.inc
213
214 let $cset= cp1257;
215 let $coll= cp1257_general_ci;
216 --source suite/funcs_2/include/check_charset.inc
217
218 let $cset= cp1257;
219 let $coll= cp1257_lithuanian_ci;
220 --source suite/funcs_2/include/check_charset.inc
221
222 # cp850
223
224 let $cset= cp850;
225 let $coll= cp850_bin;
226 --source suite/funcs_2/include/check_charset.inc
227
228 let $cset= cp850;
229 let $coll= cp850_general_ci;
230 --source suite/funcs_2/include/check_charset.inc
231
232 # cp852
233
234 let $cset= cp852;
235 let $coll= cp852_bin;
236 --source suite/funcs_2/include/check_charset.inc
237
238 let $cset= cp852;
239 let $coll= cp852_general_ci;
240 --source suite/funcs_2/include/check_charset.inc
241
242 # cp866
243
244 let $cset= cp866;
245 let $coll= cp866_bin;
246 --source suite/funcs_2/include/check_charset.inc
247
248 let $cset= cp866;
249 let $coll= cp866_general_ci;
250 --source suite/funcs_2/include/check_charset.inc
251
252 # cp932
253
254 let $cset= cp932;
255 let $coll= cp932_bin;
256 --source suite/funcs_2/include/check_charset.inc
257
258 let $cset= cp932;
259 let $coll= cp932_japanese_ci;
260 --source suite/funcs_2/include/check_charset.inc
261
262 # dec8
263
264 let $cset= dec8;
265 let $coll= dec8_bin;
266 --source suite/funcs_2/include/check_charset.inc
267
268 let $cset= dec8;
269 let $coll= dec8_swedish_ci;
270 --source suite/funcs_2/include/check_charset.inc
271
272 # eucjpms
273
274 let $cset= eucjpms;
275 let $coll= eucjpms_bin;
276 --source suite/funcs_2/include/check_charset.inc
277
278 let $cset= eucjpms;
279 let $coll= eucjpms_japanese_ci;
280 --source suite/funcs_2/include/check_charset.inc
281
282 # euckr
283
284 let $cset= euckr;
285 let $coll= euckr_bin;
286 --source suite/funcs_2/include/check_charset.inc
287
288 let $cset= euckr;
289 let $coll= euckr_korean_ci;
290 --source suite/funcs_2/include/check_charset.inc
291
292 # gb2312
293
294 let $cset= gb2312;
295 let $coll= gb2312_bin;
296 --source suite/funcs_2/include/check_charset.inc
297
298 let $cset= gb2312;
299 let $coll= gb2312_chinese_ci;
300 --source suite/funcs_2/include/check_charset.inc
301
302 # gbk
303
304 let $cset= gbk;
305 let $coll= gbk_bin;
306 --source suite/funcs_2/include/check_charset.inc
307
308 let $cset= gbk;
309 let $coll= gbk_chinese_ci;
310 --source suite/funcs_2/include/check_charset.inc
311
312 # gb18030
313 let $cset= gb18030;
314 let $coll= gb18030_bin;
315 --source suite/funcs_2/include/check_charset.inc
316
317 let $cset= gb18030;
318 let $coll= gb18030_chinese_ci;
319 --source suite/funcs_2/include/check_charset.inc
320
321 # geostd8
322
323 let $cset= geostd8;
324 let $coll= geostd8_bin;
325 --source suite/funcs_2/include/check_charset.inc
326
327 let $cset= geostd8;
328 let $coll= geostd8_general_ci;
329 --source suite/funcs_2/include/check_charset.inc
330
331 # greek
332
333 let $cset= greek;
334 let $coll= greek_bin;
335 --source suite/funcs_2/include/check_charset.inc
336
337 let $cset= greek;
338 let $coll= greek_general_ci;
339 --source suite/funcs_2/include/check_charset.inc
340
341 # hebrew
342
343 let $cset= hebrew;
344 let $coll= hebrew_bin;
345 --source suite/funcs_2/include/check_charset.inc
346
347 let $cset= hebrew;
348 let $coll= hebrew_general_ci;
349 --source suite/funcs_2/include/check_charset.inc
350
351 # hp8
352
353 let $cset= hp8;
354 let $coll= hp8_bin;
355 --source suite/funcs_2/include/check_charset.inc
356
357 let $cset= hp8;
358 let $coll= hp8_english_ci;
359 --source suite/funcs_2/include/check_charset.inc
360
361 # keybcs2
362
363 let $cset= keybcs2;
364 let $coll= keybcs2_bin;
365 --source suite/funcs_2/include/check_charset.inc
366
367 let $cset= keybcs2;
368 let $coll= keybcs2_general_ci;
369 --source suite/funcs_2/include/check_charset.inc
370
371 # koi8r
372
373 let $cset= koi8r;
374 let $coll= koi8r_bin;
375 --source suite/funcs_2/include/check_charset.inc
376
377 let $cset= koi8r;
378 let $coll= koi8r_general_ci;
379 --source suite/funcs_2/include/check_charset.inc
380
381 # koi8u
382
383 let $cset= koi8u;
384 let $coll= koi8u_bin;
385 --source suite/funcs_2/include/check_charset.inc
386
387 let $cset= koi8u;
388 let $coll= koi8u_general_ci;
389 --source suite/funcs_2/include/check_charset.inc
390
391 # latin1
392
393 let $cset= latin1;
394 let $coll= latin1_bin;
395 --source suite/funcs_2/include/check_charset.inc
396
397 let $cset= latin1;
398 let $coll= latin1_danish_ci;
399 --source suite/funcs_2/include/check_charset.inc
400
401 let $cset= latin1;
402 let $coll= latin1_general_ci;
403 --source suite/funcs_2/include/check_charset.inc
404
405 let $cset= latin1;
406 let $coll= latin1_general_cs;
407 --source suite/funcs_2/include/check_charset.inc
408
409
410 let $cset= latin1;
411 let $coll= latin1_german1_ci;
412 --source suite/funcs_2/include/check_charset.inc
413
414 let $cset= latin1;
415 let $coll= latin1_german2_ci;
416 --source suite/funcs_2/include/check_charset.inc
417
418 let $cset= latin1;
419 let $coll= latin1_spanish_ci;
420 --source suite/funcs_2/include/check_charset.inc
421
422 let $cset= latin1;
423 let $coll= latin1_swedish_ci;
424 --source suite/funcs_2/include/check_charset.inc
425
426 # latin2
427
428 let $cset= latin2;
429 let $coll= latin2_bin;
430 --source suite/funcs_2/include/check_charset.inc
431
432 let $cset= latin2;
433 let $coll= latin2_croatian_ci;
434 --source suite/funcs_2/include/check_charset.inc
435
436 let $cset= latin2;
437 let $coll= latin2_czech_cs;
438 --source suite/funcs_2/include/check_charset.inc
439
440 let $cset= latin2;
441 let $coll= latin2_general_ci;
442 --source suite/funcs_2/include/check_charset.inc
443
444 let $cset= latin2;
445 let $coll= latin2_hungarian_ci;
446 --source suite/funcs_2/include/check_charset.inc
447
448 # latin5
449
450 let $cset= latin5;
451 let $coll= latin5_bin;
452 --source suite/funcs_2/include/check_charset.inc
453
454 let $cset= latin5;
455 let $coll= latin5_turkish_ci;
456 --source suite/funcs_2/include/check_charset.inc
457
458 # latin7
459
460 let $cset= latin7;
461 let $coll= latin7_bin;
462 --source suite/funcs_2/include/check_charset.inc
463
464 let $cset= latin7;
465 let $coll= latin7_estonian_cs;
466 --source suite/funcs_2/include/check_charset.inc
467
468 let $cset= latin7;
469 let $coll= latin7_general_ci;
470 --source suite/funcs_2/include/check_charset.inc
471
472 let $cset= latin7;
473 let $coll= latin7_general_cs;
474 --source suite/funcs_2/include/check_charset.inc
475
476 # macce
477
478 let $cset= macce;
479 let $coll= macce_bin;
480 --source suite/funcs_2/include/check_charset.inc
481
482 let $cset= macce;
483 let $coll= macce_general_ci;
484 --source suite/funcs_2/include/check_charset.inc
485
486 # macroman
487
488 let $cset= macroman;
489 let $coll= macroman_bin;
490 --source suite/funcs_2/include/check_charset.inc
491
492 let $cset= macroman;
493 let $coll= macroman_general_ci;
494 --source suite/funcs_2/include/check_charset.inc
495
496 # sjis
497
498 let $cset= sjis;
499 let $coll= sjis_bin;
500 --source suite/funcs_2/include/check_charset.inc
501
502 let $cset= sjis;
503 let $coll= sjis_japanese_ci;
504 --source suite/funcs_2/include/check_charset.inc
505
506 # swe7
507
508 let $cset= swe7;
509 let $coll= swe7_bin;
510 --source suite/funcs_2/include/check_charset.inc
511
512 let $cset= swe7;
513 let $coll= swe7_swedish_ci;
514 --source suite/funcs_2/include/check_charset.inc
515
516 # tis620
517
518 let $cset= tis620;
519 let $coll= tis620_bin;
520 --source suite/funcs_2/include/check_charset.inc
521
522 let $cset= tis620;
523 let $coll= tis620_thai_ci;
524 --source suite/funcs_2/include/check_charset.inc
525
526 # ujis
527
528 let $cset= ujis;
529 let $coll= ujis_bin;
530 --source suite/funcs_2/include/check_charset.inc
531
532 let $cset= ujis;
533 let $coll= ujis_japanese_ci;
534 --source suite/funcs_2/include/check_charset.inc
535
536 }
537
538 if ($check_ucs2_csets)
539 {
540
541 # ucs2
542
543 let $cset= ucs2;
544 let $coll= ucs2_bin;
545 --source suite/funcs_2/include/check_charset_ucs2.inc
546
547 let $cset= ucs2;
548 let $coll= ucs2_czech_ci;
549 --source suite/funcs_2/include/check_charset_ucs2.inc
550
551 let $cset= ucs2;
552 let $coll= ucs2_danish_ci;
553 --source suite/funcs_2/include/check_charset_ucs2.inc
554
555 let $cset= ucs2;
556 let $coll= ucs2_estonian_ci;
557 --source suite/funcs_2/include/check_charset_ucs2.inc
558
559 let $cset= ucs2;
560 let $coll= ucs2_general_ci;
561 --source suite/funcs_2/include/check_charset_ucs2.inc
562
563 let $cset= ucs2;
564 let $coll= ucs2_hungarian_ci;
565 --source suite/funcs_2/include/check_charset_ucs2.inc
566
567 let $cset= ucs2;
568 let $coll= ucs2_icelandic_ci;
569 --source suite/funcs_2/include/check_charset_ucs2.inc
570
571 let $cset= ucs2;
572 let $coll= ucs2_latvian_ci;
573 --source suite/funcs_2/include/check_charset_ucs2.inc
574
575 let $cset= ucs2;
576 let $coll= ucs2_lithuanian_ci;
577 --source suite/funcs_2/include/check_charset_ucs2.inc
578
579 let $cset= ucs2;
580 let $coll= ucs2_persian_ci;
581 --source suite/funcs_2/include/check_charset_ucs2.inc
582
583 let $cset= ucs2;
584 let $coll= ucs2_polish_ci;
585 --source suite/funcs_2/include/check_charset_ucs2.inc
586
587 let $cset= ucs2;
588 let $coll= ucs2_roman_ci;
589 --source suite/funcs_2/include/check_charset_ucs2.inc
590
591 let $cset= ucs2;
592 let $coll= ucs2_romanian_ci;
593 --source suite/funcs_2/include/check_charset_ucs2.inc
594
595 let $cset= ucs2;
596 let $coll= ucs2_slovak_ci;
597 --source suite/funcs_2/include/check_charset_ucs2.inc
598
599 let $cset= ucs2;
600 let $coll= ucs2_slovenian_ci;
601 --source suite/funcs_2/include/check_charset_ucs2.inc
602
603 let $cset= ucs2;
604 let $coll= ucs2_spanish2_ci;
605 --source suite/funcs_2/include/check_charset_ucs2.inc
606
607 let $cset= ucs2;
608 let $coll= ucs2_spanish_ci;
609 --source suite/funcs_2/include/check_charset_ucs2.inc
610
611 let $cset= ucs2;
612 let $coll= ucs2_swedish_ci;
613 --source suite/funcs_2/include/check_charset_ucs2.inc
614
615 let $cset= ucs2;
616 let $coll= ucs2_turkish_ci;
617 --source suite/funcs_2/include/check_charset_ucs2.inc
618
619 let $cset= ucs2;
620 let $coll= ucs2_unicode_ci;
621 --source suite/funcs_2/include/check_charset_ucs2.inc
622
623 }
624
625 if ($check_utf8_csets)
626 {
627
628 # utf8
629
630 let $cset= utf8;
631 let $coll= utf8_bin;
632 --source suite/funcs_2/include/check_charset_utf8.inc
633
634 let $cset= utf8;
635 let $coll= utf8_czech_ci;
636 --source suite/funcs_2/include/check_charset_utf8.inc
637
638 let $cset= utf8;
639 let $coll= utf8_danish_ci;
640 --source suite/funcs_2/include/check_charset_utf8.inc
641
642 let $cset= utf8;
643 let $coll= utf8_estonian_ci;
644 --source suite/funcs_2/include/check_charset_utf8.inc
645
646 let $cset= utf8;
647 let $coll= utf8_general_ci;
648 --source suite/funcs_2/include/check_charset_utf8.inc
649
650 let $cset= utf8;
651 let $coll= utf8_hungarian_ci;
652 --source suite/funcs_2/include/check_charset_utf8.inc
653
654 let $cset= utf8;
655 let $coll= utf8_icelandic_ci;
656 --source suite/funcs_2/include/check_charset_utf8.inc
657
658 let $cset= utf8;
659 let $coll= utf8_latvian_ci;
660 --source suite/funcs_2/include/check_charset_utf8.inc
661
662 let $cset= utf8;
663 let $coll= utf8_lithuanian_ci;
664 --source suite/funcs_2/include/check_charset_utf8.inc
665
666 let $cset= utf8;
667 let $coll= utf8_persian_ci;
668 --source suite/funcs_2/include/check_charset_utf8.inc
669
670 let $cset= utf8;
671 let $coll= utf8_polish_ci;
672 --source suite/funcs_2/include/check_charset_utf8.inc
673
674 let $cset= utf8;
675 let $coll= utf8_roman_ci;
676 --source suite/funcs_2/include/check_charset_utf8.inc
677
678 let $cset= utf8;
679 let $coll= utf8_romanian_ci;
680 --source suite/funcs_2/include/check_charset_utf8.inc
681
682 let $cset= utf8;
683 let $coll= utf8_slovak_ci;
684 --source suite/funcs_2/include/check_charset_utf8.inc
685
686 let $cset= utf8;
687 let $coll= utf8_slovenian_ci;
688 --source suite/funcs_2/include/check_charset_utf8.inc
689
690 let $cset= utf8;
691 let $coll= utf8_spanish2_ci;
692 --source suite/funcs_2/include/check_charset_utf8.inc
693
694 let $cset= utf8;
695 let $coll= utf8_spanish_ci;
696 --source suite/funcs_2/include/check_charset_utf8.inc
697
698 let $cset= utf8;
699 let $coll= utf8_swedish_ci;
700 --source suite/funcs_2/include/check_charset_utf8.inc
701
702 let $cset= utf8;
703 let $coll= utf8_turkish_ci;
704 --source suite/funcs_2/include/check_charset_utf8.inc
705
706 let $cset= utf8;
707 let $coll= utf8_unicode_ci;
708 --source suite/funcs_2/include/check_charset_utf8.inc
709
710 }
711
712 # check_charset_utf8.inc and check_charset_ucs2.inc do DROP DATABASE test;
713 # and then create a test database with their own character set.
714 # Re-create with original character set to make mtr happy
715 DROP database test;
716 eval CREATE database test CHARACTER SET $test_charset_name;