SQL语句查询结果区分大小写

1）select * from user where name like “A\%B%”  collate utf8_bin;

      或者

select * from user where name  collate utf8_bin like “A\%B%” ;

collate utf8_bin放在like前后都可以。

2）select * from user where name collate utf8_bin like “A$%B%” escape “$”;

—————————–

注：方法2中的collate utf8_bin不能放在escape “$”的后边。

utf8_bin表示建表时使用的字符集。

1）select * from user where name collate Chinese_PRC_CS_AS like ‘A$%B%’ escape ‘$’;

或者

select * from user where name like ‘A$%B%’ escape ‘$’ collate Chinese_PRC_CS_AS;

collate Chinese_PRC_CS_AS放在like前后都可以。

2）select * from user where name collate Chinese_PRC_CS_AS like ‘A[%]B%’;

或者

select * from user where name like ‘A[%]B%’ collate Chinese_PRC_CS_AS;

在MS SQL2005中我们可以这样来查询排序规则：

select * from ::fn_helpcollations();