The fun of incompatible MySQL collations

Importing a MySQL 5.7 dump into an older 5.5 DB brought up an error:

Unknown collation: 'utf8mb4_unicode_520_ci'

Turns out the simple fix for this is a find/replace to

utf8_unicode_ci


Related:
https://poststatus.com/the-trojan-emoji/

Share your love
Kieron Howard
Kieron Howard
Articles: 53

Leave a Reply

Your email address will not be published. Required fields are marked *