[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