[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 mnelson4):

 Setting `STRICT_ALL_TABLES` means that queries that were passing before
 [30400] are now failing, even when WP_DEBUG is set to OFF.

 I think the idea of making the MySQL modes filterable, so plugin or theme
 authors can choose to disable `STRICT_ALL_TABLES` is good, but I agree
 with @nerrad: this will come as a surprise to plugin or theme developers,
 and even if they do put out a quick update to their plugin or theme, many
 of their users may update wordpress core before they update the affected
 plugins or themes.

 If we're going to be setting `STRICT_ALL_TABLES` as a mode in 4.1, I'd
 suggest it just be the default when WP_DEBUG is on. That way affected
 plugins and themes will be made aware soon, but it won't affect users live
 installs.

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