1
select @@collation_connection;
2
select collation(cast(_latin1 0xDF as char));
3
select hex(weight_string('s'));
4
select hex(weight_string(cast(_latin1 0xDF as char)));
5
select hex(weight_string(cast(_latin1 0xDF as char) as char(1)));
6
select hex(weight_string('c'));
7
select hex(weight_string('h'));
8
select hex(weight_string('ch'));
9
select hex(weight_string('i'));
10
# contraction 'ch' plus expansion 'sharp s'
11
select hex(weight_string(cast(_latin1 0x6368DF as char)));
12
select hex(weight_string(cast(_latin1 0x6368DF as char) as char(1)));
13
select hex(weight_string(cast(_latin1 0x6368DF as char) as char(2)));
14
select hex(weight_string(cast(_latin1 0x6368DF as char) as char(3)));
15
select hex(weight_string(cast(_latin1 0x6368DF as char) as char(4)));
16
# expansion 'shart s' plus contraction 'ch'
17
select hex(weight_string(cast(_latin1 0xDF6368 as char)));
18
select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(1)));
19
select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(2)));
20
select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(3)));
21
select hex(weight_string(cast(_latin1 0xDF6368 as char) as char(4)));