Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADSQLiteCollation Class
published  TADSQLiteCollation Members  Example 1  Example 2  Classes  See Also  Send Feedback

The class implementing custom SQLite collation.

Group

Classes

Class Hierarchy
uADPhysSQLite_TADSQLiteCollationuADPhysSQLite_TADSQLiteCollationuADPhysSQLite_TADSQLiteCollation
File

uADPhysSQLite

Links
published, TADSQLiteCollation Members, Example 1, Example 2, Classes, See Also
Description

Use the TADSQLiteCollation to register a custom SQLite collation. A registered collation then may be used in any place in SQL command, where a collation may be specified. For example: 

 

SELECT * FROM "Employees" ORDER BY LastName COLLATE UTF16NoCase

 

Each collation must have an unique name specified by CollationName. And one of the three collation kinds specified as the additional properties:

  • CollationKind = scCompareString. The collation will use Win32 / Win64 API CompareStringW. To setup it properties use the Locale and Flags properties.
  • CollationKind = scCustomUTF8. To compare strings application should use OnCompare event, which will receive strings in UTF8 encoding.
  • CollationKind = scCustomUTF16. Similar to scCustomUTF8, but strings will be in UTF16 encoding.

After setting up the collation it must be activated using Active property. To use a collation in a SQLite connection, application must activate the collation before opening a database connection.

Syntax
TADSQLiteCollation = class(TADSQLiteService);
See Also
Example 1
ADSQLiteCollation1.DriverLink := ADPhysSQLiteDriverLink1;
ADSQLiteCollation1.CollationName := 'UTF16NoCase';
ADSQLiteCollation1.CollationKind := scCompareString;
ADSQLiteCollation1.Flags := [sfIgnoreCase];
ADSQLiteCollation1.Active := True;
Example 2

See <AnyDAC>\Samples\DBMS Specific\SQLite\UserCollation

What do you think about this topic? Send feedback!