sqlite3_collation_needed(), sqlite3_collation_needed16()

To avoid having to register all collation sequences before a database can be used, a single callback function may be registered with the database connection to be invoked whenever an undefined collation sequence is required. If the function is registered ... 

sqlite3_vtab_collation()

 ... If the constraint comes from a WHERE clause expression that contains a COLLATE operator, then the name of the collation specified by that COLLATE operator is returned. If there is no COLLATE operator, but the column that is the subject ... 

1. Overview The UINT collating sequences is a loadable extension for SQLite that implements a new collating sequence that compares text containing unsigned integers in numeric order. The UINT collating sequence is not a standard part of SQLite. It must be loaded ... 

sqlite3_create_collation(), sqlite3_create_collation_v2(), sqlite3_create_collation16()

These functions add, remove, or modify a collation associated with the database connection specified as the first argument. The name of the collation is a UTF-8 string for sqlite3_create_collation() and sqlite3_create_collation_v2() and a UTF-16 string in native byte ... 

 ... This is useful when the definition of a collation sequence has changed, or when there are indexes on expressions involving a function whose definition has changed. If the REINDEX keyword is not followed by a collation-sequence or database object ... 

7.1. Assigning Collating Sequences from SQL Every column of every table has an associated collating function. If no collating function is explicitly defined, then the collating function defaults to BINARY. The COLLATE clause of the column definition is used to define alternative collating functions for a ... 

 ... Collations The COLLATE clause optionally following each column name or expression defines a collating sequence used for text entries in that column. The default collating sequence is the collating sequence defined for that column in the CREATE TABLE statement. Or ... 

 ... The BINARY collating sequence works well for English text. For other languages or locales, alternative collating sequences may be preferred. The decision of which collating sequence to use is controlled by the COLLATE clause in SQL. A COLLATE clause can ... 

 ... Tables, indexes, triggers, and views in unlimited quantity Up to 32K columns in a table and unlimited rows Multi-column indexes Indexes can use DESC and COLLATE Partial indexes Indexes On Expressions Clustered indexes Covering indexes CHECK, UNIQUE, NOT NULL ... 

 ... The load_extension() function will fail if the extension attempts to modify or delete an SQL function or collating sequence. The extension can add new functions or collating sequences, but cannot modify or delete existing functions or collating sequences because those ...