确切的排序规则是什么？ 匈牙利有一个特殊的Dz字母，可能与D不同，因此您的问题可能实际上是d，而不是z。

What is the exact collation? Hungarian does have a special Dz letter, which might be collated differently from D - so your problem might actually be d, not z.

Deadzone is [D][e][a][dz][o][n][e]
DeadZone is [D][e][a][d][Z][o][n][e]
deadZone is [d][e][a][d][Z][o][n][e]

查看与LY相关的问题： http://www.sqlservercentral.com/Forums/Topic19439-9-1.aspx

See related issue with LY: http://www.sqlservercentral.com/Forums/Topic19439-9-1.aspx

我不认为删除和重新添加您的列会有所帮助。如果要使用匈牙利数据库排序规则，您应该只能使用真正的匈牙利列名称！

And I don't think dropping and re-adding your column is going to help. You should probably only use real Hungarian column names if you are going to use a Hungarian database collation!