WordPress.org

Make WordPress Core

Opened 2 years ago

Closed 2 years ago

Last modified 2 years ago

#43845 closed defect (bug) (invalid)

Incorrect sorting with åæøäö characters

Reported by: bilievesser Owned by:
Milestone: Priority: normal
Severity: normal Version: 4.9.5
Component: General Keywords:
Focuses: Cc:

Description

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.

Change History (2)

#1 @tobifjellner
2 years ago

  • Resolution set to invalid
  • Status changed from new to closed

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.

Last edited 2 years ago by tobifjellner (previous) (diff)

#2 @Clorith
2 years ago

  • Milestone Awaiting Review deleted
Note: See TracTickets for help on using tickets.