[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:
--------------------------+-----------------------------

Comment (by netweb):

 Replying to [comment:10 morgantocker]:
 > An update on character set/collation support.  Here is the plan for
 MySQL 5.8:
 > http://mysqlserverteam.com/planning-the-defaults-for-mysql-5-8/
 Nice, thanks for this

 A couple of the key points:
 > We are considering changing the default character set to `utf8mb4`.
 Modern applications frequently store 4 byte characters, as emoji input is
 common for mobile devices.

 > In addition to `utf8mb4`, we are also considering switching the default
 collation to be `utf8mb4_unicode_520_ci`. We plan to add collations to
 include per-language collation rules as we currently offer with latin1
 based collations. They will have a more modern version of the Unicode
 Collation Algorithm than the `utf8mb4_unicode_520_ci`.

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