Blog

Thursday, 14 February 2019 21:40

Unknown collation: ‘utf8mb4_unicode_520_ci'

Written by 
Rate this item
(0 votes)

The following error is found when trying to migrate the MySQL database from one server to another: 

Unknown collation: ‘utf8mb4_unicode_520_ci’

-----------------------------

User can solve this by finding

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

in the .sql file, and swapping it with

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

Read 971 times