Magento Expert Forum - Improve your Magento experience
-
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-127...i-ci-in-mysql/
View more threads in the same category:
-
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks