1 select collation(cast(0x8FA2C3 as
char));
2 select hex(weight_string(cast(0x6141 as
char)));
3 select hex(weight_string(cast(0x8FA2C3 as
char)));
4 select hex(weight_string(cast(0x8FA2C3 as
char) as
char(1)));
5 select hex(weight_string(cast(0x8FA2C38FA2C3 as
char) as
char(1)));
6 select hex(weight_string(cast(0x8FA2C3 as
char) as
char(3)));
7 select hex(weight_string(cast(0x8FA2C38FA2C3 as
char) as
char(3)));
8 select hex(weight_string(cast(0x408FA2C3 as
char) as
char(3)));
9 select hex(weight_string(cast(0x408FA2C38FA2C3 as
char) as
char(3)));
10 select hex(weight_string(cast(0x408FA2C38FA2C38FA2C3 as
char) as
char(3)));
11 select hex(weight_string(cast(0x40408FA2C38FA2C38FA2C3 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(0x8FA2C38FA2C38FA2C3 as
char), 1, 2, 0xC0));
15 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 2, 2, 0xC0));
16 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 3, 2, 0xC0));
17 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 4, 2, 0xC0));
18 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 5, 2, 0xC0));
19 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char),25, 2, 0xC0));
21 # Read 3 characters from the source string (the entire string is used)
22 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 1, 3, 0xC0));
23 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 2, 3, 0xC0));
24 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 3, 3, 0xC0));
25 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 4, 3, 0xC0));
26 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 5, 3, 0xC0));
27 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char),25, 3, 0xC0));
29 # Read 4 characters from the source string (extra space is added)
30 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 1, 4, 0xC0));
31 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 2, 4, 0xC0));
32 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 3, 4, 0xC0));
33 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 4, 4, 0xC0));
34 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char), 5, 4, 0xC0));
35 select hex(weight_string(cast(0x8FA2C38FA2C38FA2C3 as
char),25, 4, 0xC0));
1.8.1.2 
