1
select @@collation_connection;
2
select hex(weight_string('a' LEVEL 1,3));
3
select hex(weight_string('a' LEVEL 1-3));
4
select hex(weight_string('A' LEVEL 1,3));
5
select hex(weight_string('A' LEVEL 1-3));
7
select hex(weight_string('a' LEVEL 1,4));
8
select hex(weight_string('a' LEVEL 1-4));
9
select hex(weight_string('A' LEVEL 1,4));
10
select hex(weight_string('A' LEVEL 1-4));
12
select hex(weight_string('a' LEVEL 2,3));
13
select hex(weight_string('a' LEVEL 2-3));
14
select hex(weight_string('A' LEVEL 2,3));
15
select hex(weight_string('A' LEVEL 2-3));
17
select hex(weight_string('a' LEVEL 2,4));
18
select hex(weight_string('a' LEVEL 2-4));
19
select hex(weight_string('A' LEVEL 2,4));
20
select hex(weight_string('A' LEVEL 2-4));
22
select hex(weight_string('a' LEVEL 3,4));
23
select hex(weight_string('a' LEVEL 3-4));
24
select hex(weight_string('A' LEVEL 3,4));
25
select hex(weight_string('A' LEVEL 3-4));
27
select hex(weight_string('a' LEVEL 1,2,3,4));
28
select hex(weight_string('a' LEVEL 2,3,4));
29
select hex(weight_string('a' LEVEL 1,3,4));
30
select hex(weight_string('a' LEVEL 1,2,3));
32
# If any number is less than 1, it is treated as 1.
33
select hex(weight_string('a' LEVEL 0));
35
#If any number is greater than the maximum, it is treated as the maximum.
36
select hex(weight_string('a' LEVEL 8));
37
select hex(weight_string('a' LEVEL 1,8));