CODEWITHSUNDEEP
sqlsql-server-2008collation
Will Jenkins
Will Jenkins

Reputation: 9787

SQL query that distinguishes between ß and ss

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

i.e. SELECT * from table WHERE name LIKE '%ß%'

yields

Brian Bruß Steven Sossmix

etc..

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

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.

Any help would be appreciated.

Upvotes: 6

Views: 5011

Answers (1)

Jose Basilio
Jose Basilio

Reputation: 51488

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

Collation: SQL_Latin1_General_Cp437_BIN

Upvotes: 11

Related Questions