Skip Navigation

[Resolved] Alphabetical Order of Filter Options is Wrong in Danish

This thread is resolved. Here is a description of the problem and solution.

Problem: The options shown in a View filter should be in alphabetical order, but the Danish characters like Å, æ and ø are not sorted correctly.

Solution: Check your database configuration. MySQL sorts differently based on the collation type, and utf8_danish_ci is probably best for your site.

This support ticket is created 6 years, 9 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 - -
13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 - -

Supporter timezone: America/New_York (GMT-04:00)

Tagged: 

This topic contains 2 replies, has 2 voices.

Last updated by jeanB 6 years, 9 months ago.

Assisted by: Christian Cox.

Author
Posts
#622641
Untitled.png

I am trying to:
My development site is in Danish, when I add a 'select' filter, the options are supposed to display in name order. However, my client tells me that the order is incorrect and that Å is the last letter in the Danish alphabet, but it comes first. How can I sort this and make sure Danish letters are correct? Including æ and ø.

Link to a page where the issue can be seen:
hidden link

(Please only use this page, Google Places API is live on the site, so too many refreshes = too many API calls!)

I expected to see:
Under the 'Steder' dropdown - Årby should be at the end as it's the final character in the Danish alphabet

Instead, I got:
Årby appearing at the top

#622765

What is the character set and collation type of your database, and the posts and postmeta tables? MySQL sorts differently depending on the database collation, and utf8_danish_ci is probably ideal in your case.

#622902

Ah, thanks very much Christian! Spot on 🙂