区分ß和ss的SQL查询 [英] SQL query that distinguishes between ß and ss

问题描述

在SQL中似乎ß= ss 。我必须能够在严格的等同字符基础上进行区分。

It seems that ß=ss in SQL. I need to be able to distinguish on a strict charcter equivalent basis.

即 SELECT *从表中的名称类似'％ß％'

收益

BrianBruß
Steven Sossmix

等。

我查看了不同的排序规则，以查看是否有忽略字符扩展的文件，但到目前为止没有运气。

I've looked at different Collations to see if there is one that ignores character expansions, but no luck so far.

数据库的默认为Latin1_General_CI_AS -我也尝试过 Latin1_General_CS_AS 和 Latin1_General_CS_AS_WS 都没有用

Database has Latin1_General_CI_AS as default - I've also tried Latin1_General_CS_AS and Latin1_General_CS_AS_WS, neither of which worked.

任何帮助将不胜感激。

推荐答案

您需要使用二进制排序规则以便区分大小写，区分重音等。

You need to use a binary collation so that it's case-sensitive, accent-sensitive, etc.

整理： SQL_Latin1_General_Cp437_BIN

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