Is utf8mb4_0900_ai_ci a suitable collation for general use in MySQL 8.0.30?

Question

For storing and searching MySQL data in many different languages, such as indexing website titles for all domain names... Will using the utf8mb4_0900_ai_ci collation work fine? I found that this is what MySQL8.0.30 switches to when importing data from the old server (MySQL5.7). Is utf8mb4_0900_ai_ci the default value in MySQL8? Is it generally possible to use utf8mb4_0900_ai_ci even if it's not the default?

P粉161939752 · Answer

Yes, the default value in MySQL 8.0 is utf8mb4_0900_ai_ci. You can check the default system settings yourself by consulting the manual, for example: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_collation_server

Yes, this is a good collation to use in MySQL 8.0. That's what I would choose. It includes the latest changes to the UTF standard available in MySQL.