Incorrect sorting with åæøäö characters

[bilievesser]

When viewing lists of items in the WordPress admin area (pages, posts) and sorting by title, items that start with either of the characters æäøöå are sorted in the wrong order. At least for some languages.

I realize the "correct" order will depend of the person being asked, but these characters are native to Scandinavia, and the sort order is wrong for our countries.

For Norway and Denmark, our alphabets end in... xyzæøå

For Sweden and Finand, the ending is xyzåäö

So in short, Ø or Ö being sorted as O does not make sense for us. Neither will Å being treated as A, as it is on the opposite side of the alphabet.

[tobifjellner]

Better to ask this question over at the support forum: wordpress.org/support
But in short: The sorting is not done by WordPress, but by your database. You need to make sure that your database collation is correctly set in your database. Unfortunately, it's not totally trivial to fix. (And for multilingual solutions it may not even be possible to get everything right without coding special solutions.)
EditAdd: Google and you'll find more.