1
drop table if exists t1;
3
CREATE TABLE t1 (a char(1) character set latin2);
4
INSERT INTO t1 VALUES (0x20),(0x21),(0x22),(0x23),(0x24),(0x25),(0x26),(0x27);
5
INSERT INTO t1 VALUES (0x28),(0x29),(0x2A),(0x2B),(0x2C),(0x2D),(0x2E),(0x2F);
6
INSERT INTO t1 VALUES (0x30),(0x31),(0x32),(0x33),(0x34),(0x35),(0x36),(0x37);
7
INSERT INTO t1 VALUES (0x38),(0x39),(0x3A),(0x3B),(0x3C),(0x3D),(0x3E),(0x3F);
8
INSERT INTO t1 VALUES (0x40),(0x41),(0x42),(0x43),(0x44),(0x45),(0x46),(0x47);
9
INSERT INTO t1 VALUES (0x48),(0x49),(0x4A),(0x4B),(0x4C),(0x4D),(0x4E),(0x4F);
10
INSERT INTO t1 VALUES (0x50),(0x51),(0x52),(0x53),(0x54),(0x55),(0x56),(0x57);
11
INSERT INTO t1 VALUES (0x58),(0x59),(0x5A),(0x5B),(0x5C),(0x5D),(0x5E),(0x5F);
12
INSERT INTO t1 VALUES (0x60),(0x61),(0x62),(0x63),(0x64),(0x65),(0x66),(0x67);
13
INSERT INTO t1 VALUES (0x68),(0x69),(0x6A),(0x6B),(0x6C),(0x6D),(0x6E),(0x6F);
14
INSERT INTO t1 VALUES (0x70),(0x71),(0x72),(0x73),(0x74),(0x75),(0x76),(0x77);
15
INSERT INTO t1 VALUES (0x78),(0x79),(0x7A),(0x7B),(0x7C),(0x7D),(0x7E),(0x7F);
16
INSERT INTO t1 VALUES (0x80),(0x81),(0x82),(0x83),(0x84),(0x85),(0x86),(0x87);
17
INSERT INTO t1 VALUES (0x88),(0x89),(0x8A),(0x8B),(0x8C),(0x8D),(0x8E),(0x8F);
18
INSERT INTO t1 VALUES (0x90),(0x91),(0x92),(0x93),(0x94),(0x95),(0x96),(0x97);
19
INSERT INTO t1 VALUES (0x98),(0x99),(0x9A),(0x9B),(0x9C),(0x9D),(0x9E),(0x9F);
20
INSERT INTO t1 VALUES (0xA0),(0xA1),(0xA2),(0xA3),(0xA4),(0xA5),(0xA6),(0xA7);
21
INSERT INTO t1 VALUES (0xA8),(0xA9),(0xAA),(0xAB),(0xAC),(0xAD),(0xAE),(0xAF);
22
INSERT INTO t1 VALUES (0xB0),(0xB1),(0xB2),(0xB3),(0xB4),(0xB5),(0xB6),(0xB7);
23
INSERT INTO t1 VALUES (0xB8),(0xB9),(0xBA),(0xBB),(0xBC),(0xBD),(0xBE),(0xBF);
24
INSERT INTO t1 VALUES (0xC0),(0xC1),(0xC2),(0xC3),(0xC4),(0xC5),(0xC6),(0xC7);
25
INSERT INTO t1 VALUES (0xC8),(0xC9),(0xCA),(0xCB),(0xCC),(0xCD),(0xCE),(0xCF);
26
INSERT INTO t1 VALUES (0xD0),(0xD1),(0xD2),(0xD3),(0xD4),(0xD5),(0xD6),(0xD7);
27
INSERT INTO t1 VALUES (0xD8),(0xD9),(0xDA),(0xDB),(0xDC),(0xDD),(0xDE),(0xDF);
28
INSERT INTO t1 VALUES (0xE0),(0xE1),(0xE2),(0xE3),(0xE4),(0xE5),(0xE6),(0xE7);
29
INSERT INTO t1 VALUES (0xE8),(0xE9),(0xEA),(0xEB),(0xEC),(0xED),(0xEE),(0xEF);
30
INSERT INTO t1 VALUES (0xF0),(0xF1),(0xF2),(0xF3),(0xF4),(0xF5),(0xF6),(0xF7);
31
INSERT INTO t1 VALUES (0xF8),(0xF9),(0xFA),(0xFB),(0xFC),(0xFD),(0xFE),(0xFF);
32
SELECT hex(a) ha, hex(lower(a)) hl, hex(upper(a)) hu,
33
a, lower(a) l, upper(a) u from t1 order by ha;
259
SELECT group_concat(a collate latin2_croatian_ci order by binary a) from t1 group by a collate latin2_croatian_ci;
260
group_concat(a collate latin2_croatian_ci order by binary a)
294
A,a,�,�,�,�,�,�,�,�,�,�
386
select @@collation_connection;
387
@@collation_connection
389
select hex(weight_string('a'));
390
hex(weight_string('a'))
392
select hex(weight_string('A'));
393
hex(weight_string('A'))
395
select hex(weight_string('abc'));
396
hex(weight_string('abc'))
398
select hex(weight_string('abc' as char(2)));
399
hex(weight_string('abc' as char(2)))
401
select hex(weight_string('abc' as char(3)));
402
hex(weight_string('abc' as char(3)))
404
select hex(weight_string('abc' as char(5)));
405
hex(weight_string('abc' as char(5)))
407
select @@collation_connection;
408
@@collation_connection
410
select hex(weight_string('a' LEVEL 1));
411
hex(weight_string('a' LEVEL 1))
413
select hex(weight_string('A' LEVEL 1));
414
hex(weight_string('A' LEVEL 1))
416
select hex(weight_string('abc' LEVEL 1));
417
hex(weight_string('abc' LEVEL 1))
419
select hex(weight_string('abc' as char(2) LEVEL 1));
420
hex(weight_string('abc' as char(2) LEVEL 1))
422
select hex(weight_string('abc' as char(3) LEVEL 1));
423
hex(weight_string('abc' as char(3) LEVEL 1))
425
select hex(weight_string('abc' as char(5) LEVEL 1));
426
hex(weight_string('abc' as char(5) LEVEL 1))
428
select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE));
429
hex(weight_string('abc' as char(5) LEVEL 1 REVERSE))
431
select hex(weight_string('abc' as char(5) LEVEL 1 DESC));
432
hex(weight_string('abc' as char(5) LEVEL 1 DESC))
434
select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE));
435
hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE))
437
set collation_connection=latin2_bin;
438
select @@collation_connection;
439
@@collation_connection
441
select hex(weight_string('a'));
442
hex(weight_string('a'))
444
select hex(weight_string('A'));
445
hex(weight_string('A'))
447
select hex(weight_string('abc'));
448
hex(weight_string('abc'))
450
select hex(weight_string('abc' as char(2)));
451
hex(weight_string('abc' as char(2)))
453
select hex(weight_string('abc' as char(3)));
454
hex(weight_string('abc' as char(3)))
456
select hex(weight_string('abc' as char(5)));
457
hex(weight_string('abc' as char(5)))
459
select @@collation_connection;
460
@@collation_connection
462
select hex(weight_string('a' LEVEL 1));
463
hex(weight_string('a' LEVEL 1))
465
select hex(weight_string('A' LEVEL 1));
466
hex(weight_string('A' LEVEL 1))
468
select hex(weight_string('abc' LEVEL 1));
469
hex(weight_string('abc' LEVEL 1))
471
select hex(weight_string('abc' as char(2) LEVEL 1));
472
hex(weight_string('abc' as char(2) LEVEL 1))
474
select hex(weight_string('abc' as char(3) LEVEL 1));
475
hex(weight_string('abc' as char(3) LEVEL 1))
477
select hex(weight_string('abc' as char(5) LEVEL 1));
478
hex(weight_string('abc' as char(5) LEVEL 1))
480
select hex(weight_string('abc' as char(5) LEVEL 1 REVERSE));
481
hex(weight_string('abc' as char(5) LEVEL 1 REVERSE))
483
select hex(weight_string('abc' as char(5) LEVEL 1 DESC));
484
hex(weight_string('abc' as char(5) LEVEL 1 DESC))
486
select hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE));
487
hex(weight_string('abc' as char(5) LEVEL 1 DESC REVERSE))