mORMot Open Source

zed

Member

Registered: 2015-02-26

Posts: 108

SQLite3 Collation Extension for mORMot Databases

If you try to work with a mORMot-created database in external applications, you'll likely encounter error like: "no such collation sequence: SYSTEMNOCASE"

This is because mORMot uses custom collations (like SYSTEMNOCASE) by default, which are not available in standard SQLite3 builds.

To fix this, I’ve released a lightweight SQLite3 extension that adds these missing collations, allowing you to open and modify mORMot databases in external tools (like the SQLite CLI or SQLiteStudio) without errors.

Supported Collations: WIN32CASE, WIN32NOCASE, SYSTEMNOCASE, UNICODENOCASE (new in mORMot 2), ISO8601.

Instruction, precompiled binaries and source code are available here: https://github.com/zedxxx/sqlite3-mormot-collate

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 15,069

Website

Re: SQLite3 Collation Extension for mORMot Databases

This is a great addition!

I have added a link to your project in the documentation:
https://github.com/synopse/mORMot2/commit/dfe6f4004

Horbs

Member

Registered: 2014-04-20

Posts: 25

Re: SQLite3 Collation Extension for mORMot Databases

That's a really great solution - thank you so much.