Hacker News Reader

Like "Aalborg" being after "Zaragoza" in a Danish sorting. And that's more tricky with "aa" being treated as a single character in Danish.

This leads to fun things like the regex [a-z][a-z] not matching the string "aa" in SQL Server when using the Danish collation.

Aalborg 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 æ.

Unfortunately, the exceptions only appear in names and proper nouns, which are where you generally want sorting the most.