1 select @@collation_connection;
2 select hex(weight_string(
'a' LEVEL 4));
3 select hex(weight_string(
'A' LEVEL 4));
4 select hex(weight_string(
'abc' LEVEL 4));
5 select hex(weight_string(
'abc' as
char(2) LEVEL 4));
6 select hex(weight_string(
'abc' as
char(3) LEVEL 4));
7 select hex(weight_string(
'abc' as
char(5) LEVEL 4));
8 select hex(weight_string(
'abc' as
char(5) LEVEL 4 REVERSE));
9 select hex(weight_string(
'abc' as
char(5) LEVEL 4 DESC));
10 select hex(weight_string(
'abc' as
char(5) LEVEL 4 DESC REVERSE));