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

WordPress Trac wp-trac at lists.automattic.com
Wed Jul 11 05:40:54 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    |
-------------------------+------------------------------

Comment (by pento):

 $wpdb would be fine for new installs, it may also be an option for
 existing installs, too.

 According to the [http://dev.mysql.com/doc//refman/5.5/en/charset-unicode-
 upgrading.html MySQL upgrade notes], feeding 4 byte characters into a utf8
 column is not allowed. My testing showed, however, that it was just
 replaced with a '?' (the same as it always has) regardless of the
 character set of the input string.

 So, if DB_CHARSET is set to utf8 and the MySQL version >= 5.5.3,
 wpdb::ini_charset() could just force it to utf8mb4.

 For new installs, the same thing in wp-admin/includes/schema.php.

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


More information about the wp-trac mailing list