Wrong menu item sorting under Hungarian language

[csbalazs]

Wrong menu item sorting under Hungarian langauge in Component menu in Joomla! admin.
In the Hungarian alphabet, the second letter is the "á" ("Á"), but the "Átirányítás" (Redirect) component almost the last in the menu.

[brianteeman]

Unfortunately this is the case with all languages that have extended accented characters. @ot2sen and myself looked at this before and if I recall correctly it requires a change in the mysql database collation for each specific language.

[brianteeman]

see #11609

[csbalazs]

Hungarian alphabetical rule: Short (a, e, i, o, ö, u, ü) and long (á, é, í, ó, ő, ú, ű) vowels appear anywhere in words, they are always considered equal. So, for the letters "a" and "á", neither the letter "a" nor the letter "á" takes precedence, but the order of the letters following them.

For example, articles ordering by title looks good in admin:

[SharkyKZ]

We do sort admin menu items in PHP here:

joomla-cms/administrator/modules/mod_menu/menu.php

Line 391 in b61308f

$item->components = ArrayHelper::sortObjects($item->components, 'text', 1, false, true);

We could do it the same way we sort components in com_config:

joomla-cms/administrator/components/com_config/helper/config.php

Line 78 in b61308f

$result[$component] = JApplicationHelper::stringURLSafe(JText::_($component)) . '_' . $component;

But it's not completely accurate either.

[brianteeman]

Interesting - ArrayHelper::sortObjects supports an option locale parameter

* @param mixed $locale Boolean or array of booleans to let sort occur using the locale language or not

[SharkyKZ]

I tried that once but it doesn't work on Windows, apparently. See #22542.

[brianteeman]

Where we you getting the locale from,? The language file or the OS. it should be the language file.

[SharkyKZ]

The language file.