1select @@collation_connection;
2select collation(cast(_latin1 0xDF as char));
3select hex(weight_string('s'));
4select hex(weight_string(cast(_latin1 0xDF as char)));
5select hex(weight_string(cast(_latin1 0xDF as char) as char(1)));
6select hex(weight_string('c'));
7select hex(weight_string('h'));
8select hex(weight_string('ch'));
9select hex(weight_string('i'));
10# contraction 'ch' plus expansion 'sharp s'
11select hex(weight_string(cast(_latin1 0x6368DF as char)));
12select hex(weight_string(cast(_latin1 0x6368DF as char) as char(1)));
13select hex(weight_string(cast(_latin1 0x6368DF as char) as char(2)));
14select hex(weight_string(cast(_latin1 0x6368DF as char) as char(3)));
15select hex(weight_string(cast(_latin1 0x6368DF as char) as char(4)));
16# expansion 'sharp s' plus contraction 'ch'
17select hex(weight_string(cast(_latin1 0xDF6368 as char)));
18select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(1)));
19select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(2)));
20select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(3)));
21select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(4)));
22
23# contraction 'ch' plus expansion 'sharp s'
24select hex(weight_string(cast(_latin1 0x6368DF as char), 1, 2, 0xC0));
25select hex(weight_string(cast(_latin1 0x6368DF as char), 2, 2, 0xC0));
26select hex(weight_string(cast(_latin1 0x6368DF as char), 3, 2, 0xC0));
27select hex(weight_string(cast(_latin1 0x6368DF as char), 4, 2, 0xC0));
28select hex(weight_string(cast(_latin1 0x6368DF as char),25, 2, 0xC0));
29
30select hex(weight_string(cast(_latin1 0x6368DF as char), 1, 3, 0xC0));
31select hex(weight_string(cast(_latin1 0x6368DF as char), 2, 3, 0xC0));
32select hex(weight_string(cast(_latin1 0x6368DF as char), 3, 3, 0xC0));
33select hex(weight_string(cast(_latin1 0x6368DF as char), 4, 3, 0xC0));
34select hex(weight_string(cast(_latin1 0x6368DF as char),25, 3, 0xC0));
35
36select hex(weight_string(cast(_latin1 0x6368DF as char), 1, 4, 0xC0));
37select hex(weight_string(cast(_latin1 0x6368DF as char), 2, 4, 0xC0));
38select hex(weight_string(cast(_latin1 0x6368DF as char), 3, 4, 0xC0));
39select hex(weight_string(cast(_latin1 0x6368DF as char), 4, 4, 0xC0));
40select hex(weight_string(cast(_latin1 0x6368DF as char),25, 4, 0xC0));
41
42# expansion 'sharp s' plus contraction 'ch'
43select hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 2,0xC0));
44select hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 2,0xC0));
45select hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 2,0xC0));
46select hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 2,0xC0));
47select hex(weight_string(cast(_latin1 0xDF6368 as char),25, 2,0xC0));
48
49select hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 3,0xC0));
50select hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 3,0xC0));
51select hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 3,0xC0));
52select hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 3,0xC0));
53select hex(weight_string(cast(_latin1 0xDF6368 as char),25, 3,0xC0));
54
55select hex(weight_string(cast(_latin1 0xDF6368 as char), 1, 4,0xC0));
56select hex(weight_string(cast(_latin1 0xDF6368 as char), 2, 4,0xC0));
57select hex(weight_string(cast(_latin1 0xDF6368 as char), 3, 4,0xC0));
58select hex(weight_string(cast(_latin1 0xDF6368 as char), 4, 4,0xC0));
59select hex(weight_string(cast(_latin1 0xDF6368 as char),25, 4,0xC0));
60