Instagram

About Me

Photo Profile
Meetanshi Architecture Designer

Meetanshi is found based on providing the best Magento Extensions and Customized eCommerce Business Solutions perfected to the users’ needs. Our Happy users make us Happy. Complete satisfaction to our clients is what drives and motivates us to work hard. Read More

Sunday, February 19, 2023

Solved: Error 1273 Unknown Collation utf8mb4_0900_ai_ci in MySQL

 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.



I looked deeper to discover the true problem and discovered that the new database's collation was different from the old one. I'll explain the approach I took to resolve this problem in this post. But first, let's clarify what "Collation" in MySQL means.


For the solution to this error, visit: https://meetanshi.com/blog/error-1273-unknown-collation-utf8mb4-0900-ai-ci-in-mysql/


No comments:
Write comments


Get more of our update !