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));