我有 Order By 的问题.例如，我有三个词，在波兰语中:Zzzz"、Żubr"和Zajawka".
I have problem with Order By. For example i have three words, in Polish: "Zzzz", "Żubr" and "Zajawka".
它们应该是这样排序的:
They should be sort like that:
Zajawka Zzzz Żubr因为 Ż 字母在波兰语字母表中位于 Z 之后.但它对我来说是:
Cause Ż letter is after Z in polish alfabet. But it sorts to me:
Zajawka Żubr Zzzz所以它将字母 Ż 视为 Z 字母...
So it treats letter Ż like Z letter...
推荐答案我假设数据库不是使用波兰语排序规则创建的.但是你总是可以在排序时指定它:
I'm assuming the database wasn't created with a Polish collation. But you can always specify it when sorting:
SELECT name FROM mytable ORDER BY name COLLATE SQL_Polish_Cp1250_CS_AS_KI_WI我误读了标签，并认为这是 SQL Server.如果您有不同的 RDBMS，请在评论中回答 @RaphaëlAlthaus 的问题.
I misread the tags and assumed this was SQL Server. If you have a different RDBMS, please answer @RaphaëlAlthaus's question in the comments.