[wp-trac] [WordPress Trac] #33697: utf8mb4 conversion runs on "term_relationships" when perhaps it should not

[WordPress Trac]

#33697: utf8mb4 conversion runs on "term_relationships" when perhaps it should not
--------------------------+----------------------
 Reporter:  tollmanz      |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.2
 Severity:  normal        |  Resolution:  invalid
 Keywords:                |     Focuses:
--------------------------+----------------------
Changes (by pento):

 * status:  new => closed
 * resolution:   => invalid
 * milestone:  Awaiting Review =>


Comment:

 This behaviour is on purpose.

 Apart from changing the character set of the columns, the `ALTER TABLE`
 also changes the default character set of the table. While it's unlikely
 that `term_relationships` will ever have new columns added, it's quite
 possible that a plugin using that function could add new string columns.
 If we didn't update the table character set, and the plugin didn't specify
 a character set for the new column, it would unexpectedly be added as
 `utf8` instead of `utf8mb4`.

 (I also like having all of the tables showing as `utf8mb4` when looking at
 the table list in phpMyAdmin.) ;-)

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