insert into a1 select 'b0'
union all select 'b-'
union all select 'b01'
union all select 'b-1'
select word as 'Chinese_PRC_BIN word' from a1 order by word collate Chinese_PRC_BIN
结果是
Chinese_PRC_BIN word
--------------------
b-
b-1
b0
b01
select word as 'Chinese_PRC_CI_AS word' from a1 order by word collate Chinese_PRC_CI_AS
结果是
Chinese_PRC_CI_AS word
----------------------
b-
b0
b01
b-1