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

[WordPress Trac]

#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