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