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

Comment (by tollmanz):

 This is what I get and hence the reason I opened this ticket:

 {{{
 mysql> SHOW TABLE STATUS LIKE "wp_term_relationships"\G
 *************************** 1. row ***************************
            Name: wp_term_relationships
          Engine: InnoDB
         Version: 10
      Row_format: Compact
            Rows: 685560
  Avg_row_length: 42
     Data_length: 28917760
 Max_data_length: 0
    Index_length: 15253504
       Data_free: 4194304
  Auto_increment: NULL
     Create_time: 2015-03-25 21:48:18
     Update_time: NULL
      Check_time: NULL
       Collation: utf8_general_ci
        Checksum: NULL
  Create_options:
         Comment:
 1 row in set (0.00 sec)

 mysql> ALTER TABLE wp_term_relationships CONVERT TO CHARACTER SET utf8mb4
 COLLATE utf8mb4_unicode_ci;
 Query OK, 0 rows affected (0.11 sec)
 Records: 0  Duplicates: 0  Warnings: 0

 mysql> SHOW TABLE STATUS LIKE "wp_term_relationships"\G
 *************************** 1. row ***************************
            Name: wp_term_relationships
          Engine: InnoDB
         Version: 10
      Row_format: Compact
            Rows: 685560
  Avg_row_length: 42
     Data_length: 28917760
 Max_data_length: 0
    Index_length: 15253504
       Data_free: 4194304
  Auto_increment: NULL
     Create_time: 2015-03-25 21:48:18
     Update_time: NULL
      Check_time: NULL
       Collation: utf8_general_ci
        Checksum: NULL
  Create_options:
         Comment:
 1 row in set (0.00 sec)
 }}}

 Is the original `utf8_general_ci` collation causing an issue?

 P.S. - Thanks for the `\G` trick!

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