Solved: Error 1273 Unknown Collation utf8mb4_0900_ai_ci in MySQL

Allen-smith20 Feb, 2023Technology

Have you recently encountered the Unknown Collation: utf8mb4_0900_ai_ci in MySQL error? That's because the databases' character sets are incompatible. To find the solution, read this blog post all the way through. I recently used MySQL to manually import a database to a new server. Everything was going well... till unknown collation: 'utf8mb4 0900 ai ci' displayed on my screen.