[wp-trac] [WordPress Trac] #58871: support uca14.0.0 collation in database where available

[WordPress Trac]

#58871: support uca14.0.0 collation in database where available
-------------------------------------------------+-------------------------
 Reporter:  danielblack                          |       Owner:  (none)
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Awaiting
                                                 |  Review
Component:  Database                             |     Version:  6.3
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch has-unit-tests needs-      |     Focuses:
  testing                                        |
-------------------------------------------------+-------------------------

Comment (by danielblack):

 Seems there's only a few `JOIN`s in the and codebase `src/wp-includes
 /class-wp-meta-query.php` could gain an explicit collate on comparison
 criteria to coerce comparison collation to the larger table.

 {{{
 select * from t1400 join t520 on t1400.t = t520.t collate
 utf8mb4_uca1400_ai_ci
 }}}

 Simpler however is:

 Alternately in the `upgrade.php` there is already a
 `wp_should_upgrade_global_tables` that could apply in the upgrade where
 existing criteria is around character set conversions. If the same
 criteria is used with collations that would be consistent.

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