Opened 8 years ago
Last modified 5 years ago
#35144 new defect (bug)
Sorting Greek characters
Reported by: |
|
Owned by: | |
---|---|---|---|
Milestone: | Priority: | normal | |
Severity: | normal | Version: | 4.4 |
Component: | Charset | Keywords: | |
Focuses: | ui | Cc: |
Description
There's an abnormal behaviour in alphabetically sorted lists containing terms in Greek. The expected order would be Latin characters on top, then Greek; two consecutive lists. However, the Greek list is actually further split into two other lists, one with terms starting with an upper case character and the other with terms starting with lower case. So it's Latin Aa-Zz, then Greek Α-Ω, then Greek α-ω. A real-world example is a tag cloud. See this for example: http://www.tastefull.gr/tagcloud
Note: See
TracTickets for help on using
tickets.
Update: The lists are five, not three:
The database collation is utf8mb4_unicode_ci and phpmyadmin sorts terms OK (e.g. Latin case-insensitive, then Greek case/accent-insensitive).