[wp-trac] [WordPress Trac] #60002: maybe_convert_table_to_utf8mb4() not work with new version of MySQL/MariaDB.

[WordPress Trac]

#60002: maybe_convert_table_to_utf8mb4() not work with new version of
MySQL/MariaDB.
--------------------------+------------------------------
 Reporter:  okvee         |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  General       |     Version:
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by okvee):

 Found another possible bug.

 File: wp-includes/class-wpdb.php
 Line: 886
 Method: `determine_charset()`

 {{{
 if ( 'utf8' === $charset ) {
     $charset = 'utf8mb4';
 }
 }}}

 Should be change to
 {{{
 if ( 'utf8' === $charset || 'utf8mb3' === $charset ) {
     $charset = 'utf8mb4';
 }
 }}}

 From same reason.
 ''Historically, MySQL has used utf8 as an alias for utf8mb3; beginning
 with MySQL 8.0.28, utf8mb3 is used exclusively in the output of SHOW
 statements and in Information Schema tables when this character set is
 meant.''

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