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

WordPress Trac wp-trac at lists.automattic.com
Wed Jul 11 11:22:07 UTC 2012


#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


More information about the wp-trac mailing list