Is utf8mb4_0900_ai_ci a suitable collation for general use in MySQL 8.0.30?
P粉431220279
P粉431220279 2024-01-10 16:47:01
0
1
453

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?


P粉431220279
P粉431220279

reply all(1)
P粉161939752

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.

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!