Small. Fast. Reliable.
Choose any three.
Choose any three.
|
STRICT Tables
(stricttables.html)
2. STRICT Tables
... work the same.
FOREIGN KEY constraints work the same.
UNIQUE constraints work the same.
DEFAULT clauses work the same.
COLLATE clauses work the same.
Generated columns work the same.
ON CONFLICT clauses work the same.
Indexes work the same.
AUTOINCREMENT ...
|
|
SQLite Older News
(oldnews.html)
... But a pointer to the collating function
was also being cached within expressions. If an expression was part of the
schema and contained a cached collating function, it would point to the
collating function in the database connection that originally ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
1. Overview
... The types and default collation sequences attached to each column
must be the same for all component tables.
All component tables must have the same PRIMARY KEY declaration (if any).
A swarmvtab table has the same schema as each of ...
|
|
Distinctive Features Of SQLite
(different.html)
... And SQLite defines APIs which allow the user to add new
SQL functions
and collating sequences.
This page last modified on 2024-05-08 11:54:12 UTC
|
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
8. Extending SQLite
... sqlite3_create_collation()
sqlite3_create_function()
sqlite3_create_module()
sqlite3_vfs_register()
The sqlite3_create_collation() interface is used to create new
collating sequences for sorting text.
The sqlite3_create_module() interface is used to register new
virtual table implementations.
The sqlite3_vfs_register() interface creates new VFSes.
The sqlite3_create_function() interface creates new SQL ...
|
|
The SQLite Bytecode Engine
(opcode.html)
2.2. Instruction Format
... P4 may be a 32-bit signed integer, a 64-bit signed integer, a
64-bit floating point value, a string literal, a Blob literal,
a pointer to a collating sequence comparison function, or a
pointer to the implementation of ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... The SQLITE_OK_LOAD_PERMANENTLY return code is useful to
loadable extensions that register new VFSes, for example.
(257) SQLITE_ERROR_MISSING_COLLSEQ
The SQLITE_ERROR_MISSING_COLLSEQ result code means that an SQL
statement could not be prepared because a collating sequence named
in that SQL statement could ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... The application can overload the built-in NOCASE collating
sequence (using sqlite3_create_collation()) and the built-in
like(), upper(), and lower() functions
(using sqlite3_create_function()).
The SQLite source code includes an "ICU" extension that does
these overloads. Or, developers can write their ...
|
|
Command Line Shell For SQLite
(cli.html)
18. Miscellaneous Extension Features
... the UINT collating sequence which treats
unsigned integers embedded in text according to
their value, along with other text, for ordering;
decimal arithmetic as provided by the decimal extension;
the generate_series() table-valued function;
the base64() and base85() functions which ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA collation_list
PRAGMA collation_list;
Return a list of the collating sequences defined for the current
database connection.
|
Page generated by FTS5 in about 64.77 ms.