3 ms·
Like "Aalborg" being after "Zaragoza" in a Danish sorting. And that's more tricky with "aa" being treated as a single character in Danish.
by Svip 5y ago
Like "Aalborg" being after "Zaragoza" in a Danish sorting. And that's more tricky with "aa" being treated as a single character in Danish.
- 3np 5y agoAalborg is one of very few exceptions that even in Danish can commonly be spelled with “aa” as a replacement for “å” (the single character). Just like ae for æ.
- Svip 5y agoUnfortunately, the exceptions only appear in names and proper nouns, which are where you generally want sorting the most.
- noctune 5y agoThis leads to fun things like the regex [a-z][a-z] not matching the string "aa" in SQL Server when using the Danish collation.