Page 1 of 1
SQLite custom collation
Posted: Sat 02 Oct 2010 20:18
by burdian
Hi,
How can I define my custom collate in Sqlite with UniDAC ?
TIA and best regards
Branko
Posted: Mon 04 Oct 2010 08:10
by AndreyZ
Hello,
You can look at the custom collation defining example here (in the end of the page):
www.devart.com/forums/viewtopic.php?t=18222
Posted: Mon 04 Oct 2010 09:37
by burdian
Hi Andrey
Thank you, but when I want to compile with that code I get error
Code: Select all
[DCC Error] F_Main.pas(85): E2003 Undeclared identifier: 'RegisterCollation'
[DCC Error] F_Main.pas(85): E2003 Undeclared identifier: 'GetCRConnection'
[DCC Error] F_Main.pas(86): E2003 Undeclared identifier: 'SQLITE_UTF8'
[DCC Error] F_Main.pas(86): E2035 Not enough actual parameters
TAI and best regards
Branko
Posted: Mon 04 Oct 2010 13:10
by AlexP
Hello,
The UTF sorting for SQLite databases is avaliable in UniDAC 3.00.0.11 or higher version. If you have an earlier version please download the latest 3.50.0.12 version of UniDAC.
If your version of UniDAC is 3.00.0.11 or higher, please check that you added the LiteClassesUni and LiteCallUni units to the USES section.