SQLite custom collation

burdian · Post by **burdian** » Sat 02 Oct 2010 20:18

Hi,

How can I define my custom collate in Sqlite with UniDAC ?

TIA and best regards
Branko

AndreyZ · Post by **AndreyZ** » Mon 04 Oct 2010 08:10

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

burdian · Post by **burdian** » Mon 04 Oct 2010 09:37

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

AlexP · Post by **AlexP** » Mon 04 Oct 2010 13:10

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.