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

 Looks like [31051] broke `test_query_tag_nun()` added in [UT1032].

 [source:tags/4.1/src/wp-includes/taxonomy.php#L1410 $wpdb->get_row()] in
 `get_term_by()` returns unexpected result and causes some notices:

 {{{

 object(stdClass)#3499 (9) {
   ["Field"]=>
   string(7) "term_id"
   ["Type"]=>
   string(19) "bigint(20) unsigned"
   ["Collation"]=>
   NULL
   ["Null"]=>
   string(2) "NO"
   ["Key"]=>
   string(3) "PRI"
   ["Default"]=>
   NULL
   ["Extra"]=>
   string(14) "auto_increment"
   ["Privileges"]=>
   string(31) "select,insert,update,references"
   ["Comment"]=>
   string(0) ""
 }

 Notice: Undefined property: stdClass::$term_id in
 S:\home\wordpress\develop\src\wp-includes\taxonomy.php on line 1415
 Notice: Undefined property: stdClass::$term_id in
 S:\home\wordpress\develop\src\wp-includes\taxonomy.php on line 2124
 Notice: Undefined property: stdClass::$slug in
 S:\home\wordpress\develop\src\wp-includes\taxonomy.php on line 2812
 }}}

 The same happens when adding a "test-נ" or "САПР" tag via UI, although
 these are valid UTF-8 characters.

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