1
select collation(cast(0xA1A1 as char));
2
select hex(weight_string(cast(0x6141 as char)));
3
select hex(weight_string(cast(0xA1A1 as char)));
4
select hex(weight_string(cast(0xA1A1 as char) as char(1)));
5
select hex(weight_string(cast(0xA1A1A1A1 as char) as char(1)));
6
select hex(weight_string(cast(0xA1A1 as char) as char(3)));
7
select hex(weight_string(cast(0xA1A1A1A1 as char) as char(3)));
8
select hex(weight_string(cast(0x40A1A1 as char) as char(3)));
9
select hex(weight_string(cast(0x40A1A1A1A1 as char) as char(3)));
10
select hex(weight_string(cast(0x40A1A1A1A1A1A1 as char) as char(3)));
11
select hex(weight_string(cast(0x4040A1A1A1A1A1A1 as char) as char(3)));
13
# Read 2 characters from the source string (the last character is not used)
14
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 2, 0xC0));
15
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 2, 0xC0));
16
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 2, 0xC0));
17
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 2, 0xC0));
18
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 2, 0xC0));
19
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 2, 0xC0));
21
# Read 3 characters from the source string (the entire string is used)
22
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 3, 0xC0));
23
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 3, 0xC0));
24
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 3, 0xC0));
25
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 3, 0xC0));
26
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 3, 0xC0));
27
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 3, 0xC0));
29
# Read 4 characters from the source string (extra space is added)
30
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 1, 4, 0xC0));
31
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 2, 4, 0xC0));
32
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 3, 4, 0xC0));
33
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 4, 4, 0xC0));
34
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char), 5, 4, 0xC0));
35
select hex(weight_string(cast(0xA1A1A1A1A1A1 as char),25, 4, 0xC0));