[wp-trac] [WordPress Trac] #32105: Database collate should be utf8mb4_unicode_520_ci

[WordPress Trac]

#32105: Database collate should be utf8mb4_unicode_520_ci
--------------------------+-----------------------------
 Reporter:  miyauchi      |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:  4.2
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+-----------------------------
Changes (by pento):

 * milestone:  Awaiting Review => Future Release


Comment:

 I absolutely agree that we should be looking at moving to
 `utf8mb4_unicode_520_ci`.

 My primary concern is that we're already splitting behaviour between
 installs that can support `utf8mb4` and those that can't - figuring out a
 nice way to maintain splitting between `utf8mb4_unicode_ci` and
 `utf8mb4_unicode_520_ci` is yet another problem. It's possible that we'll
 need a general solution, for when MySQL adds support for later Unicode
 Collation Algorithms.

 @morgantocker, do you have any insight into when we need to start planning
 for MySQL to have later UCA support?

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