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