[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:  reopened
 Priority:  normal       |   Milestone:
Component:  Database     |     Version:  3.4.1
 Severity:  minor        |  Resolution:
 Keywords:               |
-------------------------+-----------------------
Changes (by pento):

 * keywords:  has-patch commit =>
 * status:  closed => reopened
 * resolution:  maybelater =>


Comment:

 It turns out this is possible, thanks to the `innodb_large_prefix` option,
 introduced in 5.5.14:
 http://dev.mysql.com/doc/refman/5.5/en/innodb-
 parameters.html#sysvar_innodb_large_prefix

 So, the requirements are:
 MyISAM tables:
 MySQL >= 5.5.3 (Assuming we don't add any indexes larger than 250
 characters.)

 InnoDB tables:
 MySQL >= 5.5.14
 innodb_file_format=barracuda
 innodb_file_per_table=true
 innodb_large_prefix=true
 All tables with ROW_FORMAT=(DYNAMIC|COMPRESSED)

 Any other table formats:
 *head explode*

 We can certainly detect these settings, it's just a question of whether
 that kind of complex (and edge-case-y) test should be in core.

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