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

WordPress Trac noreply at wordpress.org
Wed Jul 23 10:21:50 UTC 2025


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

 * keywords:   => close


Comment:

 Replying to [ticket:21212 pento]:
 > 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
 > http://starssbio.com/

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


More information about the wp-trac mailing list