With MySQL 8.0, the version of MySQL Database Service aka MDS, the default character set has changed from latin1 to ut8mb4. The default collation is utf8mb4_0900_ai_ci but what does that mean ? and why are the utf8mb4_0900_* the recommended ones ?
Collations like utf8mb4_unicode_520_ci and utf8mb4_0900_ai_ci are based on Unicode Collation Algorithm (UCA). The number in the collation defines the UCA version:
UCA 9.0.0 (recommended)
- example: utf8mb4_0900_ai_ci
UCA 5.2.0 (not recommended, see problems
- example: utf8mb4_unicode_520_ci
The …[Read more]