Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Floating Point Numbers
(floatingpoint.html)
2.1.3. The ieee754_from_blob() and ieee754_to_blob() functions
The ieee754_to_blob(F) SQL function converts the floating point number F
into an 8-byte BLOB that is the big-endian binary64 encoding of that number.
The ieee754_from_blob(B) function goes the other way, converting an 8-byte
blob into ...
|
|
C API: Obtaining SQL Values
(c3ref/value_blob.html)
sqlite3_value_blob(), sqlite3_value_double(), sqlite3_value_int(), sqlite3_value_int64(), sqlite3_value_pointer(), sqlite3_value_text ...
... The returned value is one of SQLITE_INTEGER,
SQLITE_FLOAT, SQLITE_TEXT, SQLITE_BLOB, or SQLITE_NULL.
Other interfaces might change the datatype for an sqlite3_value object.
For example, if the datatype is initially SQLITE_INTEGER and
sqlite3_value_text(V) is called to extract a text value ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... SQLite understands the column type
of "VARCHAR(N)" to be the same as "TEXT", regardless of the value
of N.
(10) Does SQLite support a BLOB type?
SQLite allows you to store BLOB data in any
column, even columns that ...
|
|
C API: The pre-update hook.
(c3ref/preupdate_blobwrite.html)
sqlite3_preupdate_hook(), sqlite3_preupdate_old(), sqlite3_preupdate_count(), sqlite3_preupdate_depth(), sqlite3_preupdate_new(), sqlite3_preupdate_blobwrite()
... When the sqlite3_blob_write() API is used to update a blob column,
the pre-update hook is invoked with SQLITE_DELETE. This is because the
in this case the new values are not available. In this case, when a
callback made with ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... BLOB values
are rendered using SQL-standard hexadecimal BLOB notation. The
use of the quote() function ensures that the SQL statements used to
undo and redo are always safe from SQL injection.
Automatic Creation Of Triggers
Triggers such as the ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... New changeset iterator handle */
int nChangeset, /* Size of changeset blob in bytes */
void *pChangeset /* Pointer to blob containing changeset */
);
int sqlite3changeset_start_v2(
sqlite3_changeset_iter **pp, /* OUT: New changeset iterator handle */
int nChangeset, /* Size of changeset blob in bytes */
void *pChangeset, /* Pointer to ...
|
|
Compile-time Options
(compile.html)
2. Recommended Compile-time Options
... Historically, SQLite has allowed BLOB operands to the LIKE and GLOB
operators. But having a BLOB as an operand of LIKE or GLOB complicates
and slows the LIKE optimization. When this option is set, it means that
the LIKE and ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
4.1. Computing and controlling parameters M and n
... If the database
does contain large strings or BLOBs, they should be read using
incremental BLOB I/O and rows that contain the
large strings or BLOBs should never be update by any means other
than incremental BLOB I/O ...
|
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
6. Binding Parameters and Reusing Prepared Statements
... SQLite allows a parameter wherever a string literal,
blob literal, numeric constant, or NULL is allowed
in queries or data modification statements. (DQL or DML)
(Parameters may not be used for column or table names,
or as values for constraints ...
|
|
Built-in Aggregate Functions
(lang_aggfunc.html)
... String and BLOB values that do not look like numbers are
interpreted as 0.
The result of avg() is always a floating point value whenever
there is at least one non-NULL input even if all
inputs are integers. The ...
|
Page generated by FTS5 in about 63.41 ms.