FireDAC.Phys.SQLite.TFDSQLiteCollation

From RAD Studio API Documentation
Jump to: navigation, search

FireDAC.Phys.SQLite.TFDSQLiteServiceFireDAC.Phys.TFDPhysDriverServiceFireDAC.Stan.Intf.TFDComponentSystem.Classes.TComponentSystem.Classes.TPersistentSystem.TObjectTFDSQLiteCollation

Delphi

TFDSQLiteCollation = class (TFDSQLiteService)

C++

class PASCALIMPLEMENTATION TFDSQLiteCollation : public TFDSQLiteService

Properties

Type Visibility Source Unit Parent
class public
FireDAC.Phys.SQLite.pas
FireDAC.Phys.SQLite.hpp
FireDAC.Phys.SQLite FireDAC.Phys.SQLite

Description

The class implementing a custom SQLite collation.

Use the TFDSQLiteCollation to register a custom SQLite collation. A registered collation then may be used in any place in a SQL command where a collation may be specified.

For example: 

  SELECT * FROM "Employees" ORDER BY LastName COLLATE UTF16NoCase

Each collation must have a unique name specified by CollationName and one of the three kinds of collation specified as the additional properties:

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

See Also