Making WordPress.org

Opened 2 years ago

Closed 2 years ago

#6036 closed defect (bug) (invalid)

MariaDB 10.6: utf8 vs. utf8mb3

Reported by: javiercasares's profile JavierCasares Owned by:
Milestone: Priority: normal
Component: General Keywords:
Cc:

Description

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"?

Change History (2)

#1 @JavierCasares
2 years ago

  • Type changed from enhancement to defect

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.
    

#2 @JavierCasares
2 years ago

  • Resolution set to invalid
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.