[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:  task (blessed)  |      Status:  reopened
 Priority:  normal          |   Milestone:  4.2
Component:  Database        |     Version:  3.4.1
 Severity:  normal          |  Resolution:
 Keywords:  has-patch       |     Focuses:
----------------------------+-----------------------

Comment (by pento):

 In [attachment:21212-utf8mb4.8.diff]:

 * Add a variable and comment explaining why we have the 191 character
 length indexes
 * Use `$wpdb->tables()` instead of `$wpdb->tables`
 * Add a `DO_NOT_UPGRADE_GLOBAL_TABLES` check, as `wp_sitemeta` can easily
 be a big table
 * In `$wpdb->db_connect()`, we only need to call `$wpdb->init_charset()`
 the first time we connect
 * Tidy up and clarify a few comments

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