Floating Point Numbers
(floatingpoint.html)
2.2.6. The decimal collating sequence
The decimal extension provides the "decimal" collating sequence
that compares decimal text strings in numeric order.
This page last modified on 2025-05-31 13:08:22 UTC
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.21. The collate method
This method registers new text collating sequences. There are
two arguments: the name of the collating sequence and the name of a
TCL procedure that implements a comparison function for the collating
sequence.
For example, the following code implements a ...
|
sqldiff.exe: Database Difference Utility
(sqldiff.html)
1. Usage
... This can be used to add application-defined
collating sequences that are required by the schema.
--primarykey
Use the schema-defined PRIMARY KEY instead of the rowid to
pair rows in the source and destination database. (See additional
explanation below ...
|
Database File Format
(fileformat.html)
2.2. Record Sort Order
... Additional application-specific collating functions can be added to
SQLite using the sqlite3_create_collation() interface.
The default collating function for all strings is BINARY.
Alternative collating functions for table columns can be specified in the
CREATE TABLE statement using the COLLATE ...
|
Invalid UTF Policy
(invalidutf.html)
1.1. Invalid UTF will never cause memory errors
... If an application adds new application-defined SQL functions or
virtual tables or collating sequences or other extensions, and a
database contains invalid UTF, then invalid UTF might get passed
into those extensions. If the invalid UTF causes one of ...
|
The RBU Extension
(rbu.html)
3.2. RBU Vacuum C/C++ Programming
... Any custom collation sequences used by indexes within the database
being vacuumed are registered with both of the database handles returned
by the sqlite3rbu_db() function.
Function sqlite3rbu_step() is called on the RBU handle until either
the RBU vacuum is finished ...
|
Run-Time Loadable Extensions
(loadext.html)
1. Overview
SQLite has the ability to load extensions (including new
application-defined SQL functions,
collating sequences, virtual tables, and VFSes) at run-time.
This feature allows the code for extensions to be developed and
tested separately from the application and then ...
|
SQLite Foreign Key Support
(foreignkeys.html)
3. Required and Suggested Database Indexes
... If the parent key columns have a UNIQUE index,
then that index must use the collation sequences that are specified
in the CREATE TABLE statement for the parent table.
For example,
CREATE TABLE parent(a PRIMARY KEY, b UNIQUE, c ...
|
The SQLite Query Optimizer Overview
(optoverview.html)
5. The LIKE Optimization
... For the GLOB operator, the column must be indexed using the
built-in BINARY collating sequence.
For the LIKE operator, if case_sensitive_like mode is enabled then
the column must be indexed using the built-in BINARY collating sequence,
or if ...
|
The DBSTAT Virtual Table
(dbstat.html)
2. The "path" column of the dbstat virtual table
... in overflow chain
'/1c2/000+000002' // Third page in overflow chain
If the paths are sorted using the BINARY collation sequence, then
the overflow pages associated with a cell will appear earlier in the
sort-order than its child page ...
|
Page generated by FTS5 in about 55.32 ms.