mORMot Open Source

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

sqlite expert complains "no such collation sequence:_SYSTEMNOCASE"

Hi Arnaud,

I'm not sure what's happening, but I think I'd report the phenomenon here:

The GUI tool for Sqlite called Sqlite Expert (http://www.sqliteexpert.com/) had an error:

Error: no such collation sequence:_SYSTEMNOCASE

SQL Statement:
select fieldA,fieldB,fieldC, count(*)
from myTable
group by fieldA,fieldB,fieldC
having count(*) > 1.

Note: sqlite expert is ok with simple sql select statement.

But another called SqliteSpy (http://www.yunqa.de/delphi/doku.php/pro … espy/index) is Ok with the sql query.

What do you think might caused this? I assume sqlite export's sqlite3 engine is too old?

Last edited by edwinsn (2014-06-19 07:41:16)

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,661

Website

Re: sqlite expert complains "no such collation sequence:_SYSTEMNOCASE"

Search for "collation" in the SAD 1.18 pdf, and you will find out that we added an extended collation to SQLite3.
Paragraph "8.2.5. Column collations" page 194 of the current version.

If you use non-default collations (i.e. SYSTEMNOCASE/ISO8601/WIN32CASE/WIN32NOCASE), you may have trouble running requests with "plain default" SQLite3 tools. But you can use our SynDBExplorer safely, since it will declare all the above collations.

Please always search the doc first.

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

Re: sqlite expert complains "no such collation sequence:_SYSTEMNOCASE"

Thanks Arnaud, I did full text search the mORMot source code, but forgot the manual

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.