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.