[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 pento):

 I've split the patch into two parts:

 [attachment:21212-utf8mb4.4.diff] enables `utf8mb4`, when available. It
 now sanity checks that all columns in a table (that have a character set)
 are `utf8`, before doing the conversion. It also reduces the size of a
 handful of indexes, to fit within the 767 byte limit. This allows as to
 avoid the mess of checking for `innodb_large_prefix`.

 [attachment:21212-emoji.diff] adds Emoji support for databases that are
 using the `utf8` character set. Emoji are allowed in `post_title`,
 `post_content` and 'post_excerpt', as well as the Site Name and
 Description. This patch is dependant upon
 [attachment:21212-utf8mb4.4.diff].

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