[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:                  |     Focuses:
----------------------------+-----------------------

Comment (by netweb):

 Here's a dump of my DB table collation
 https://gist.github.com/ntwb/00918b2f625281853502

 The reason why I thought `nw_term_relationships` was not being converted
 to `utf8mb4` is because data types `INT`, `BIGINT`, `DATETIME` do NOT have
 a collation, as the `wp_terms_relationships` table only includes `INT` and
 `BIGINT` this is why MySQL was not displaying/showing this table as
 `utf8mb4` for me.

 One other note I read but cannot find reference now was:
 > "Altering a table can impact the auto increment values"

 So, should we not alter numeric/datetime columns?

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