Skip to content

Unknown collation: ‘utf8mb4_unicode_520_ci’

Issue Description

If when trying to import an SQL file, usually from shared hosting (Cargodev) to a hybrid you get the error: “Unknown collation: ‘utf8mb4_unicode_520_ci’

Affected Browsers

  • all

Issue Type

Fixed Code Snippets

Find and replace to the rescue

Find utf8mb4unicode520_ci replace with utf8mb4_unicode_ci
Find utf8mb4_unicode_520_ci replace with utf8mb4_unicode_ci

References

Reference Description

Reference Link

Stackoverflow

Back to Issues List