SQL Server 2005 Unicode string sorting problem

问题:

I have a table named 'Soum'. this table has NVARCHAR(100) field named 'Name'. But sort by name, that wrong working. Please see picture. After executing query.

First red row is wrong sorted.

I don't understand that why this is wrong working. I was checked character is same or not. But 'Ө' character is same in red rows. I'm trying to reinsert this 3 rows. But result is same.

How can I fix this error? I don't want to add Order field. What's wrong?

回答1:

Can you check sorting for "л" and "г"? Аdd 2 records for test with that names and sort them by name. I think problem in "г"