SQLite: no such collation sequence: X
A column or query uses a collation SQLite doesn't know (such as utf8mb4_unicode_ci, or a custom one not registered).
no such collation sequencesqlite3.OperationalError: no such collation sequence: utf8mb4_unicode_ciSQLITE_ERROR: no such collation sequenceno such collation sequence: unicode Meaning
SQLite only has BINARY, NOCASE and RTRIM built in. Remove MySQL-style collations from the schema/queries, use COLLATE NOCASE, or register the collation in your driver (create_collation) before opening the database. A schema created by an app with a custom collation fails in the sqlite CLI.
Common causes
- MySQL collation in SQL/DDL
- Custom collation not registered on this connection
- Opening an app's database in another tool
- ORM migration generated the wrong collation
- ICU collation not compiled in
⚡ Quick fix
- Use
COLLATE NOCASEor BINARY - Register the collation on every connection
- Drop/recreate indexes using the unknown collation
Detailed fix by platform
SQL
CREATE TABLE users (email TEXT COLLATE NOCASE UNIQUE);
How to diagnose
- Collation — Built in?
- Registered — On connection?
- Schema — Uses a custom one?
🔧 Still not fixed?
Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:
Similar errors
Most viewed in SQL
Other ways to find it
Where this error sits
Origin: Data. Errors that are often confused with or caused by this one (click to open):
🧠 Still stuck? Analyze your error
Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.
💬 What worked for others
No tips yet — did something else fix this for you?
Share what worked for you
Tips are checked by an editor before they appear. Links are removed.
Report a correction or suggest an improvement
Last updated 18 Nov 2026