[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:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Database     |     Version:  3.4.1
 Severity:  minor        |  Resolution:
 Keywords:  has-patch    |
-------------------------+------------------------------

Old description:

> Historically, the MySQL utf8 character set has only supported the first
> character plane of UTF-8. With MySQL 5.5.3, it now supports the entire
> character plane, using the utf8mb4 character set. This character set is
> 100% backwards compatible, and does not require more space than utf8 for
> characters that fall within the utf8 set, only using an extra byte for
> characters outside of the utf8 set.
>
> References:
>
> http://en.wikipedia.org/wiki/Mapping_of_Unicode_character_planes
> http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html

New description:

 Historically, the MySQL utf8 character set has only supported the first
 character plane of UTF-8. With MySQL 5.5.3, it now supports the entire
 character plane, using the utf8mb4 character set. This character set is
 100% backwards compatible, and does not require more space than utf8 for
 characters that fall within the utf8 set, only using an extra byte for
 characters outside of the utf8 set.

 References:

 http://en.wikipedia.org/wiki/Mapping_of_Unicode_character_planes [[BR]]
 http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html

--

Comment (by SergeyBiryukov):

 Related: #13590

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/21212#comment:4>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software