3617
MariaDBWARNINGCriticalCompatibilityHIGH confidence
Deprecated collation found in dump file
Production Risk
Low — Warning only during import; functionality is preserved for now.
How to reproduce
trigger — this will error
trigger — this will error
ALTER TABLE t CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
expected output
Warning 3617: Deprecated collation 'utf8mb4_unicode_520_ci' found in dump.
Fix
Migrate to supported collation
Migrate to supported collation
ALTER TABLE t CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
Why this works
Updates to a current, non-deprecated utf8mb4 collation.
What not to do
✕
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 3617 ER_WARN_DEPRECATED_COLLATION_IN_DUMP
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev