Omar

Nofl

IT Consultant


Welcome to my blog.

Here you’ll find some of my website & my latest news, tutorials and general information.

Unknown collation: ‘utf8mb4_unicode_ci’

February 29, 2016Omar Nofl0 Comments

Error:
#1273 – Unknown collation: ‘utf8mb4_unicode_ci’

Reason:
Importing a database exported from new SQL server to and old SQL server.

Best Solution:
Upgrading SQL server is the best solution.

Alternative Solution:
If you don’t have control over hosting, so:

From phpMyAdmin
1) Click the “Export” tab for the database
2) Click the “Custom” radio button
3) Go the section titled “Format-specific options” and change the dropdown for “Database system or older MySQL server to maximize output compatibility with:” from NONE to MYSQL40.
4) Scroll to the bottom and click “GO”.

Another Solution:
Change “utf8mb4_unicode_ci” to “utf8_unicode_ci” but may cause issue in content encoding.

 

Cheers!


Leave a Reply

Time limit is exhausted. Please reload the CAPTCHA.