Creating SQL Server index on a nvarchar column

Posted by Jahan on Stack Overflow See other posts from Stack Overflow or by Jahan
Published on 2010-04-27T01:21:28Z Indexed on 2010/04/27 1:23 UTC
Read the original article Hit count: 340

Filed under:
|

When I run this SQL statement:

CREATE UNIQUE INDEX WordsIndex ON Words (Word ASC);

I get the following exception message:

The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.Words' and the index name 'WordsIndex'. The duplicate key value is (ass). The statement has been terminated.

The 'Word' column has a datatype of nvarchar(100).

There are two items in the 'Word' column that SQL Server interprets as the same: 'aß' and 'ass', which causes the indexing failure.

Why would SQL Server interpret those two different words as the same word?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about index