Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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)
23.3. 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)
... 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 ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... in the table affected by the change; and
*pzTab is set to point to a nul-terminated utf-8 encoded string containing
the name of the table affected by the current change. The buffer remains
valid until either sqlite3changeset_next() is ...
|
|
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 ...
|
|
The SQLite Bytecode Engine
(opcode.html)
2.6. Self-Altering Code
... Another example is the String8 opcode which converts its P4
operand from UTF-8 into the correct database string encoding, then
converts itself into a String opcode.
|
Page generated by FTS5 in about 45.53 ms.