Alphabetical order of Danish letters

General questions regarding the use of languages in Joomla! 3.x.

Moderators: infograf768, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
jumm
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Fri Oct 28, 2011 10:43 pm

Alphabetical order of Danish letters

Post by jumm » Thu Jan 11, 2018 11:09 am

I have just started a new Joomla 3.8.3 site with my own basic template.
On this site I have menu items which list all articles for a specific category.
These articles are sorted alphabetic by article title.
The whole site is in Danish language.
The articles are shown alphabetically except for nationally Danish letters "æøå" and "ÆØÅ".
These Danish letters should sort after "z", but "åÅ" and "æÆ" are sorted in front (I believe interpreted as "AA" and "AE" and "Ø" seems to be sorted as "OE"), but this is not correct according to Danish language standards.
The character set for the site is "utf-8".
See an example here http://jum.agurk.dk/webbog3/index.php/home/middagmenu-3 where the menu item "Desserter" shows the article with title "Æblecrumble" is sorted wrongly (should be last).

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 21959
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, The Netherlands
Contact:

Re: Alphabetical order of Danish letters

Post by pe7er » Thu Jan 11, 2018 3:36 pm

That problem is not Joomla but MySQL database related:
When you order fields in a database, the "Collation" of the database determines how the ordering should be.
By default Joomla uses utf8mb4_unicode_ci as collation.

You could try to change the collation of the #__content.title field to utf8mb4_danish_ci using e.g. phpmyadmin.
However, if you have a multilingual website with multiple languages, it might result in weird ordering in other languages.
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
Co-founder of data2.eu GDPR Tool https://data2.eu/en/gdpr-tool

jumm
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Fri Oct 28, 2011 10:43 pm

Re: Alphabetical order of Danish letters

Post by jumm » Thu Jan 11, 2018 5:35 pm

Tak for hurtigt svar.


Post Reply

Return to “Language - Joomla! 3.x”