在需要区分的字段前加 BINARY (实测有用)
SELECT
*
FROM
table
where BINARY username =“LiYuanBa”
下面是网上找到的其他方法,我测试无效
SELECT
*
FROM
table
where cast(username as varbinary)=cast(‘LiYuanBa’ as varbinary)
SELECT
*
FROM
table
where username collate Chinese_PRC_CS_AS =“LiYuanBa”