[wp-trac] [WordPress Trac] #21212: MySQL tables should use utf8mb4 character set

[WordPress Trac]

#21212: MySQL tables should use utf8mb4 character set
----------------------------+-----------------------
 Reporter:  pento           |       Owner:
     Type:  task (blessed)  |      Status:  reopened
 Priority:  normal          |   Milestone:  4.2
Component:  Database        |     Version:  3.4.1
 Severity:  normal          |  Resolution:
 Keywords:                  |     Focuses:
----------------------------+-----------------------

Comment (by morgantocker):

 A little bit more MySQL version context on `innodb_large_prefix`:
 - It was created so that MySQL downgrades would be possible (i.e. 5.5 ->
 5.1)
 - This purpose is now obsolete, since 5.5+ support large prefix (and 5.1
 is no longer officially supported).
 - We are proposing to enable `innodb_large_prefix` by default in MySQL
 5.7, since it is now a safe change.  I have the call out on my blog here:
 http://www.tocker.ca/2015/01/05/what-defaults-would-you-like-to-see-
 changed-in-mysql-5-7.html

 So I realize it's a while out for many people, but the story should be
 simpler with MySQL 5.7.

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