with a(c1) as (values '泸州' union values '成都'
union values '汶川'
union values '绵阳' union values '稻城' union values '中国' union values '沧州' union values '温州'
union values '囧' )
select c1,hex(c1) from a order by COLLATION_KEY_BIT (c1, 'UCA500R1_LZH_AN_CX_EX_FX_HX_NX_S3')
union values '汶川'
union values '绵阳' union values '稻城' union values '中国' union values '沧州' union values '温州'
union values '囧' )
select c1,hex(c1) from a order by COLLATION_KEY_BIT (c1, 'UCA500R1_LZH_AN_CX_EX_FX_HX_NX_S3')