On 03/17/2016 07:29 PM, Torleif Haug?deg?rd wrote: Torleif,
> Now the resultat was this one; > > Exception: > ------------------------------------------------------------------------------------------ > 2.1 Date : Thu, 17 Mar 2016 18:27:00 +0100 > 2.2 Address : 00AA83F5 > 2.3 Module Name : SQLiteExpertPers.exe - (The complete administration > tool for SQLite) > 2.4 Module Version: 3.5.92.2512 > 2.5 Type : ESQLiteException > 2.6 Message : no such collation sequence:_RMNOCASE > . > SQL Statement: > ---------------------------------------------------------------- > . > SELECT given FROM NameTable ORDER BY given. > Unfortunately i'm not familiar with SQLite Expert, however > 2.6 Message : no such collation sequence:_RMNOCASE Collation provided by nunicode SQLite extension is called NU800_NOCASE (or NU800 for case-sensitive collation), that name is need to be used if you want nunicode to handle "COLLATE" expressions. Here is documentation on nunicode SQLite extension: https://bitbucket.org/alekseyt/nunicode#markdown-header-sqlite3-extension with some usage examples.
