[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:  Awaiting Review
Component:  Database     |     Version:  3.4.1
 Severity:  normal       |  Resolution:
 Keywords:               |     Focuses:
-------------------------+------------------------------

Comment (by nerrad):

 So here's an example error in our unit testing that came up...


 {{{
 WordPress database error BLOB/TEXT column 'DTT_description' can't have a
 default value for query CREATE TABLE wptests_esp_datetime ( DTT_ID int(10)
 unsigned NOT NULL AUTO_INCREMENT,
                                   EVT_ID INT UNSIGNED NOT NULL ,
                                   DTT_name VARCHAR(255) NOT NULL default
 '',
                                   DTT_description TEXT NOT NULL default
 '',
                                   DTT_EVT_start datetime NOT NULL default
 '0000-00-00 00:00:00',
                                   DTT_EVT_end datetime NOT NULL default
 '0000-00-00 00:00:00',
                                   DTT_reg_limit mediumint(8) DEFAULT -1,
                                   DTT_sold mediumint(8) unsigned DEFAULT
 0,
                                   DTT_is_primary tinyint(1) UNSIGNED NOT
 NULL DEFAULT 0,
                                   DTT_order mediumint(3) unsigned DEFAULT
 0,
                                   DTT_parent int(10) unsigned DEFAULT 0,
                                   DTT_deleted tinyint(1) UNSIGNED NOT NULL
 DEFAULT 0,
                                                 PRIMARY KEY  (DTT_ID),
                                                 KEY EVT_ID (EVT_ID),
                                                 KEY DTT_is_primary
 (DTT_is_primary) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
 COLLATE=utf8_general_ci
 }}}

 Obviously, that reveals where our sql can be corrected.  However I suspect
 there will be a number of plugin authors and potentially theme authors who
 will have similar sql that fails strict standards and depending on who
 coded, might not understand what the problem is right away.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/21212#comment:36>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform