Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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.
|
|
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 indexed using BINARY collating sequence, or if
case_sensitive_like mode is disabled ...
|
|
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 61.63 ms.