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

Question

Used to store and search MySQL data in many different languages, such as indexing website titles for all domain names...

Will the collation work properly using utf8mb4_0900_ai_ci? I found that this is what MySQL 8.0.30 switches to when importing data from the old server (MySQL 5.7).

Is
• utf8mb4_0900_ai_ci the default in MySQL 8?
• Is it generally possible to use utf8mb4_0900_ai_ci even if it is not the default?

Answer 1

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.