[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:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.5.2
 Severity:  normal        |  Resolution:  worksforme
 Keywords:                |     Focuses:
--------------------------+-------------------------
Changes (by esemlabel):

 * status:  reopened => closed
 * resolution:   => worksforme


Comment:

 '''Resolved'''

 I've finally, got it worked.

 1. In wp-config.php: define('DB_COLLATE', 'utf8_unicode_ci');
 2. Changed Collation of database: in db root in phpMyAdmin > Operation >
 Collation.
 3. Changed Collation of 'wp_terms' table (could be done to each table): in
 table root > Operation > Table Options > Collation.
 4. Changed server variables: in phpMyAdmin root > Variables > changed
 'collation connection', 'collation database' and 'collation server'
 parameters to 'utf8_unicode_ci'.

 Now all works fine, in back-end and front-end.

 Can wordpress do such routine automatically?

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