MariaDB 10.6: utf8 vs. utf8mb3

[JavierCasares]

MariaDB 10.6 ​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"?

[JavierCasares]

Update:

• 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.