[wp-trac] [WordPress Trac] #21212: MySQL tables should use utf8mb4 character set
WordPress Trac
wp-trac at lists.automattic.com
Tue Aug 28 15:39:09 UTC 2012
#21212: MySQL tables should use utf8mb4 character set
------------------------------+--------------------
Reporter: pento | Owner:
Type: enhancement | Status: new
Priority: normal | Milestone: 3.5
Component: Database | Version: 3.4.1
Severity: minor | Resolution:
Keywords: has-patch commit |
------------------------------+--------------------
Comment (by ryan):
Our unique key on slug in the terms table fails miserably with utf8mb4.
{{{
WordPress database error Specified key was too long; max key length is 767
bytes for query
CREATE TABLE wp_terms (
term_id bigint(20) unsigned NOT NULL auto_increment,
name varchar(200) NOT NULL default '',
slug varchar(200) NOT NULL default '',
term_group bigint(10) NOT NULL default 0,
PRIMARY KEY (term_id),
UNIQUE KEY slug (slug),
KEY name (name)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci made by
wp_install, make_db_current_silent, dbDelta
}}}
--
Ticket URL: <http://core.trac.wordpress.org/ticket/21212#comment:10>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software
More information about the wp-trac
mailing list