'ß' and 'ss' are NOT equal - by BetterToday

Status : 


Sign in
to vote
ID 341130 Comments
Status Active Workarounds
Type Bug Repros 8
Opened 4/30/2008 1:58:17 AM
Access Restriction Public



when setting SQL Server to standard latin collation (Latin1_General_CI_AS), a NVARCHAR(x) UNIQUE column raises a Unique Constraint error, when adding these two rows to the table:


This is not correct. Maße and Masse are two different words having different meanings. Especially after German spelling reform, 'ß' and 'ss' got even more separated. (Whereas 'SS' is currently still are replacement for 'ß' when capitalizing a word to upper-case, since 'ß' is only a lower-case letter.)

After discussing this online (http://groups.google.com/group/microsoft.public.de.sqlserver/browse_thread/thread/c2f2b1dd36ab439b)
I've been discussing this issue with DIN. They are currently discussing this issue internally to update the DIN/ISO standards.

Nonetheless, SQL2005/2008 should provide an option to *not* regards 'ß' and 'ss' as being equal while still adhering to all other dictionary collating rules.

Axel Dahmen
Sign in to post a comment.
Posted by Mark Guinness on 5/20/2013 at 11:49 AM
This still appears to be an issue in SQL Server 2012. FWIW, the same problem occurs with æ and ae. Has anyone from the SQL team consulted with the Windows team to see if they are adopting the new DIN/ISO standards?
Posted by Umachandar [MSFT] on 6/21/2011 at 3:02 PM
Thanks for your feedback. Our current behavior follows the SQL/ISO standard and unless those standards are updated with the latest changes we don't intend to change the behavior in SQL Server. Changing existing SQL Server behavior has lot of implications and today we rely on Windows for all of our windows collation sorting capabilities. If and when in the future Windows adopts these new rules / Unicode standard we will incorporate it in SQL Server. Till then, you have to use other workarounds suggested in the comments. Hope this helps.

Umachandar, SQL Programmability Team
Posted by YingXiao on 7/14/2010 at 6:58 PM
Hi there,

We have the same issue as Axel. We don't want to add an extra column to this table, or change collation of this column, as it will have negative effect to the existing system.

Do you already have a fix for this issue? If not, when are you going to fix this?

Posted by BetterToday on 8/4/2008 at 3:45 AM
Hi Jim,

sorry for taking me so long to reply..

The corresponding DIN group is discussing this issue now. I can provide you with the personal contact at DIN if you provide me with your e-mail address.

I've played my part in this game so far by getting DIN (ISO) aware of the problem and having a discussion started to update the standards. This is where I'm off the train now.

Do you want me to provide you with the contact at DIN?

Best regards,
Axel Dahmen
Posted by Jim [MSFT] on 5/1/2008 at 8:13 AM
Hi Axel,

Thankyou for this bug report. I've passed it over to the Developer Team to investigate; in particular, how much work it would take us to fix and/or provide an option to differentiate.

Please let us know how/when DIN decides on this issue, so we can adhere with their standard.

However, it's unlikely this change will make it into the current release. The 'bar' for checking-in fixes is now very high, as we enter the 'end-game' for Katmai.