[wp-trac] [WordPress Trac] #53623: MariaDB 10.6 renamed utf8 to utf8mb3

[WordPress Trac]

#53623: MariaDB 10.6 renamed utf8 to utf8mb3
--------------------------+-----------------------------
 Reporter:  skithund      |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Future Release
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+-----------------------------

Comment (by JavierCasares):

 Tested with:
 - PHP 7.1 -> 8.1
 - MariaDB 10.6

 This makes some test errors:

 - Tests_DB_Charset::test_set_charset_changes_the_connection_collation
 {{{
 Failed asserting that two strings are identical.
 --- Expected
 +++ Actual
 @@ @@
 -'utf8_general_ci'
 +'utf8mb3_general_ci'
 }}}

 - Tests_DB_Charset::test_get_column_charset::test_get_column_charset with
 data set #5
 {{{
 Failed asserting that two strings are identical.
 --- Expected
 +++ Actual
 @@ @@
 -'utf8'
 +'utf8mb3'
 }}}

 - Tests_DB_Charset::test_get_column_charset::test_get_column_charset with
 data set #6
 {{{
 Failed asserting that two strings are identical.
 --- Expected
 +++ Actual
 @@ @@
 -'utf8'
 +'utf8mb3'
 }}}

 - Tests_DB_Charset::test_table_collation_check::test_table_collation_check
 with data set #0
 {{{
 ('CREATE TABLE table_collation_..._bin )', true, 'SELECT * FROM
 table_collation... a='😈'', 'DROP TABLE IF EXISTS table_co...heck_0',
 array('SELECT * FROM table_collation...='foo'', 'SHOW FULL TABLES LIKE
 table_c...heck_0', 'DESCRIBE table_collation_check_0', 'DESC
 table_collation_check_0', 'EXPLAIN SELECT * FROM table_c...heck_0'))
 Failed asserting that false is identical to true.
 }}}

 - Tests_DB_Charset::test_table_collation_check::test_table_collation_check
 with data set #1
 {{{
  ('CREATE TABLE table_collation_...l_ci )', true, 'SELECT * FROM
 table_collation... a='😈'', 'DROP TABLE IF EXISTS table_co...heck_1',
 array('SELECT * FROM table_collation...='foo'', 'SHOW FULL TABLES LIKE
 table_c...heck_1', 'DESCRIBE table_collation_check_1', 'DESC
 table_collation_check_1', 'EXPLAIN SELECT * FROM table_c...heck_1'))
 Failed asserting that false is identical to true.
 }}}

 - Tests_DB_Charset::test_table_collation_check::test_table_collation_check
 with data set #4
 {{{
 ('CREATE TABLE table_collation_... INT )', true, 'SELECT * FROM
 table_collation... a='😈'', 'DROP TABLE IF EXISTS table_co...heck_4',
 array('SELECT * FROM table_collation...='foo'', 'SHOW FULL TABLES LIKE
 table_c...heck_4', 'DESCRIBE table_collation_check_4', 'DESC
 table_collation_check_4', 'EXPLAIN SELECT * FROM table_c...heck_4'))
 Failed asserting that false is identical to true.
 }}}

 Also... should WordPress set the default charset to "utf8mb4"?

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