[wp-trac] [WordPress Trac] #45697: Database: Upgrading field collations

[WordPress Trac]

#45697: Database: Upgrading field collations
-------------------------+----------------------------
 Reporter:  pento        |      Owner:  (none)
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Future Release
Component:  Database     |    Version:
 Severity:  normal       |   Keywords:
  Focuses:               |
-------------------------+----------------------------
 [37523] added support for the `utf8mb4_unicode_520_ci ` collation, and
 #38036 exists to look at adding support for the `utf8mb4_0900_ai_ci`
 collation.

 With these variations, it's possible for a WordPress site to be installed,
 then MySQL is upgraded sometime later. Subsequent table changes (for
 example, a plugin creating a new table) would use the newer collation,
 while the original tables would use the older collation. This will cause
 `JOIN` queries between fields of different collations to fail.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/45697>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform