[wp-trac] [WordPress Trac] #38036: Add support for the utf8mb4_0900_ai_ci collation

[WordPress Trac]

#38036: Add support for the utf8mb4_0900_ai_ci collation
-------------------------+-----------------------------
 Reporter:  pento        |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Future Release
Component:  Database     |     Version:
 Severity:  normal       |  Resolution:
 Keywords:               |     Focuses:
-------------------------+-----------------------------

Comment (by iisti):

 I guess WordPress still doesn't support the MySQL 8 default
 utf8mb4_0900_ai_ci

 MySQL Server version: 8.0.32 Source distribution

 Defaults are when creating with command **CREATE DATABASE testdb;**
 {{{
 | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
 +----------------------------+------------------------+
 | utf8mb4                    | utf8mb4_0900_ai_ci     |
 +----------------------------+------------------------+
 }}}

 So I guess one needs to create the database for WP with the command below
 in MySQL 8 to configure the character set and collate porperly.

 {{{
 CREATE DATABASE testdb02 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 }}}

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