使用波兰语字母排序 [英] Order By using Polish letters

问题描述

我有 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.

这篇关于使用波兰语字母排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！