Feeling Lucky
No Code Attached Yet
[#47375] - The alphabetic sorting in danish i not correct
- New
- Medium
- Build: 5.4.3
- # 47375
I've made a standard menu with a category list for the category "leksikonartikler", and I have set the sorting to be alphabetic.
but the danish letters Æ, Ø, and Å is sorted as A,O and A and not as the tre last letters in the danish alphabet.
https://hilleroedleksikon.dk/alfabetisk-artikelliste
For instans "Øllingegård" on page 6, "Årets by 1990" on page 1, and "Følstrup" on page 2. These ar sorted wrongly.
| Labels |
Removed:
?
|
||
joomla-cms-bot
- | Labels |
Added:
No Code Attached Yet
|
||
drmenzelit
- comment
- 15 Mar 2026
@mykh-hailo please read #47215
This has been tested several times during the years, with various success. See:
https://github.com/joomla/joomla-cms/issues/26418 and
https://github.com/joomla/joomla-cms/issues/11609
As it is in my own backyard I had to test it again now :)
With the standard database collation you will get that sorting order still. But now it is actually possible to get the full correct order when using the utf8mb4_danish_ci collation.
So it is still a database level fix having to set the correct collations. But in 2026 it actually end up with a correct order.
*I did break the J5 test site I was using while changing table collation and column collations - so please don´t try this at home without a full and working backup.
I went from same ordering as you in shot 1 to having the correct order after changing the collations using phpmyadmin.