Planet MySQL

Displaying posts with tag: MySQL character set and collation (reset)

Nov

2024

MySQL 8 utf8mb4_0900_ai_ci collation confusion

Posted by Kedar Vaijanapurkar on Mon 18 Nov 2024 07:45 UTC
Tags:

Technical, mariadb, mysql upgrade, MySQL, utf8mb4_general_ci, MySQL 8, utf8mb4_0900_ai_ci, upgrade mysql 8, alter database collation, change collation MySQL, character set MySQL, character set utf8mb4, database collation settings, default collation MySQL, MySQL 8 collation default, MySQL 8 upgrade collation, MySQL 8 upgrade issues, MySQL character set and collation, MySQL Collation, MySQL collation behavior, MySQL collation comparison, MySQL database collation, MySQL utf8mb4, MySQL utf8mb4 default collation, utf8mb4 collation, utf8mb4_0900_ai_ci vs utf8mb4_general_ci

Recently I was asked a question: Why am I getting utf8mb4_0900_ai_ci as the default collation in MySQL 8, despite setting the server to use utf8mb4_general_ci? With the upgrade to MySQL…

The post MySQL 8 utf8mb4_0900_ai_ci collation confusion first appeared on Change Is Inevitable.

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links