Skip Navigation

[Résolu] Alphabetical Order of Filter Options is Wrong in Danish

Ce fil est résolu. Voici une description du problème et la solution proposée.

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 Il y a 6 années et 9 mois. 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)

Marqué : 

Ce sujet contient 2 réponses, a 2 voix.

Dernière mise à jour par jeanB Il y a 6 années et 9 mois.

Assisté par: Christian Cox.

Auteur
Publications
#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:
lien caché

(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 🙂