[wp-meta] [Making WordPress.org] #6036: MariaDB 10.6: utf8 vs. utf8mb3

[Making WordPress.org]

#6036: MariaDB 10.6: utf8 vs. utf8mb3
---------------------------+--------------------
 Reporter:  JavierCasares  |      Owner:  (none)
     Type:  enhancement    |     Status:  new
 Priority:  normal         |  Milestone:
Component:  General        |   Keywords:
---------------------------+--------------------
 MariaDB 10.6 [https://mariadb.com/docs/reference/mdb/character-
 sets/utf8mb3/ changed the default "utf8" to "utf8mb3"].

 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
 {{{
 Failed asserting that false is identical to true.
 }}}

 - Tests_DB_Charset::test_table_collation_check::test_table_collation_check
 with data set #1
 {{{
 Failed asserting that false is identical to true.
 }}}

 - Tests_DB_Charset::test_table_collation_check::test_table_collation_check
 with data set #4
 {{{
 Failed asserting that false is identical to true.
 }}}

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

-- 
Ticket URL: <https://meta.trac.wordpress.org/ticket/6036>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org