SQL Server 2005 Unicode字符串排序问题 [英] SQL Server 2005 Unicode string sorting problem

问题描述

我有一个名为"Soum"的表.该表具有名为'Name'的NVARCHAR(100)字段.但是按name排序，那是错误的工作.请看图片.执行完查询后.

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.

我不明白为什么这是错误的工作方式.我检查过字符是否相同.但是红色行中的Ө"字符相同.我正在尝试重新插入这3行.但是结果是一样的.

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?

推荐答案

可以检查л"和г"的排序方式吗?使用该名称的2条记录进行测试，并按名称对它们进行排序.我认为г"中存在问题

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

这篇关于SQL Server 2005 Unicode字符串排序问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！