Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Unlock-Notify API
(unlock_notify.html)
... Otherwise, the
** system may become deadlocked.
*/
int sqlite3_blocking_prepare_v2(
sqlite3 *db, /* Database handle. */
const char *zSql, /* UTF-8 encoded SQL statement. */
int nSql, /* Length of zSql in bytes. */
sqlite3_stmt **ppStmt, /* OUT: A pointer to the prepared statement */
const char **pz /* OUT ...
|
|
Implementation Limits For SQLite
(limits.html)
... During part of SQLite's INSERT and SELECT processing, the complete
content of each row in the database is encoded as a single BLOB.
So the SQLITE_MAX_LENGTH parameter also determines the maximum
number of bytes in a row.
The maximum ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... The filename will be UTF-8 encoded. The flags argument will be
SQLITE_ACCESS_EXISTS to check for the existence of the file,
SQLITE_ACCESS_READWRITE to check to see if the file is both readable
and writable, or SQLITE_ACCESS_READ to check to see ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... SQLITE_OMIT_UTF16
This macro is used to omit support for UTF16 text encoding. When this is
defined all API functions that return or accept UTF16 encoded text are
unavailable. These functions can be identified by the fact that they end
with ...
|
|
Command Line Shell For SQLite
(cli.html)
22.5. The --no-utf8 and --utf8 command-line options
On the Windows platform, when the console is used for input or output,
translation is required between character encoding available from or sent to
the console and the CLI's internal, UTF-8 text representation. Past versions
of the CLI ...
|
|
SQLite FTS5 Extension
(fts5.html)
9.2.4. Segment B-Tree Format
... For
example, if the offset list is to contain offsets 0, 10, 15 and 16, it
is encoded by packing the following values, encoded as varints, end to
end:
2, 12, 7, 3
For each column other than column 0 ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.13. The function method
... dbcmd function
sql-name
?options?
script
The following example creates a new SQL function named "hex" that converts
its numeric argument in to a hexadecimal encoded string:
db function hex {format 0x ...
|
|
JSON Functions And Operators
(json1.html)
3.8. The JSON BLOB Input Bug
... But in the
actual implementation, the input would be accepted as long
as the BLOB content was a valid JSON string in the text encoding of
the database.
This JSON BLOB input bug was accidentally fixed when the JSON routines ...
|
|
SQLite Older News
(oldnews.html)
... The file format for version 3.3.0 has changed slightly to support
descending indices and
a more efficient encoding of boolean values. SQLite 3.3.0 will read and
write legacy databases created with any prior version of SQLite ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.3.1. Inputs
... If column usage information is needed by the
xFilter method, then the required bits must be encoded into either
the output idxNum field or idxStr content.
2.3.1.1. LIKE, GLOB, REGEXP, and MATCH functions
For the LIKE, GLOB ...
|
Page generated by FTS5 in about 49.08 ms.