区分大小写的SQL区分大小写 [英] Case-sensitive SQL differentiate between upper and lower case

问题描述

我正尝试发出一个区分大小写结果的请求。

I'm trying to have a request with a case sensitive result.

例如，在我的数据库中，我有

For example in my database I have

ABCdef
abcDEF
abcdef

请求为

SELECT * FROM table WHERE col = 'abcdef'

但是我有3行作为结果，我只想要abcdef

but I have my 3 rows as result and I just want abcdef

我尝试用

SELECT * 
FROM table 
WHERE col COLLATE Latin1_General_CS_AS = 'abcdef' COLLATE Latin1_General_CS_AS 

但我有此错误：

未知排序规则：'Latin1_General_CS_AS'{成功：false，错误：＃1273-未知排序规则：'Latin1_General_CS_AS'}

Unknown collation: 'Latin1_General_CS_AS'{"success":false,"error":"#1273 - Unknown collation: 'Latin1_General_CS_AS'"}

谢谢

推荐答案

感谢您的帮助，我发现解决方案不是latin1 ut utf8

Thanks for your help I find the solution it was not latin1 ut utf8

COLLATE utf8_bin

这篇关于区分大小写的SQL区分大小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！