[wp-trac] [WordPress Trac] #36843: Wrong Taxonomy Term orderby 'name' in Cyrillic

[WordPress Trac]

#36843: Wrong Taxonomy Term orderby 'name' in Cyrillic
--------------------------+------------------------------
 Reporter:  esemlabel     |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Taxonomy      |     Version:  4.5.2
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by knutsp):

 `utf8_general_ci` will not work. It's the same problem with Norwegian.
 `æøå` will be sorted incorrectly if the column's collation is not set to
 `utf8_danish_ci` or `utf8mb4_danish_ci`.

 The two most important columns to fix are `posts.post_title` and
 `terms.name`. Beware that it's not sufficient to set the collation for the
 table, is this is just a default when new columns are created. It must be
 set on each individual indexed column contaning characters of the local
 language.

 Should WordPress offer to set the correct collation for these DB columns?

--
Ticket URL: <https://core.trac.wordpress.org/ticket/36843#comment:4>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform