Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Base64() SQL Function
(base64.html)
2. Features
... If the argument to base64() is a BLOB, then the return value is TEXT
that is the RFC 4648 encoding
of that BLOB.
If the argument to base64() is base64 TEXT then the return value is
a BLOB that is ...
|
|
C API: Closing A Database Connection
(c3ref/close.html)
sqlite3_close(), sqlite3_close_v2()
... Ideally, applications should finalize all
prepared statements, close all BLOB handles, and
finish all sqlite3_backup objects associated
with the sqlite3 object prior to attempting to close the object.
If the database connection is associated with unfinalized prepared
statements, BLOB handlers ...
|
|
The Base85() SQL Function
(base85.html)
3. Features
The base85() function always takes a single argument that must be TEXT
(for base85-to-binary conversion) or a BLOB (for binary-to-base85 conversion).
If the argument to base85() is a BLOB, then the return value is TEXT
according ...
|
|
C API: Result Values From A Query
(c3ref/column_blob.html)
sqlite3_column_blob(), sqlite3_column_double(), sqlite3_column_int(), sqlite3_column_int64(), sqlite3_column_text(), sqlite3_column_text16 ...
... If the result is a BLOB or a TEXT string, then the sqlite3_column_bytes()
or sqlite3_column_bytes16() interfaces can be used to determine the size
of that BLOB or string.
If the result is a BLOB or UTF-8 string then the ...
|
|
Datatypes In SQLite
(datatype3.html)
3.4. Column Affinity Behavior Example
... DELETE FROM t1;
INSERT INTO t1 VALUES(x'0500', x'0500', x'0500', x'0500', x'0500');
SELECT typeof(t), typeof(nu), typeof(i), typeof(r), typeof(no) FROM t1;
blob|blob|blob|blob|blob
-- NULLs are also unaffected by ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... For BLOB values, length(X) always returns the byte-length of the BLOB.
For string values, length(X) must read the entire string into memory in order
to compute the character length. But for BLOB values, reading the whole string ...
|
|
C API: Binding Values To Prepared Statements
(c3ref/bind_blob.html)
sqlite3_bind_blob(), sqlite3_bind_blob64(), sqlite3_bind_double(), sqlite3_bind_int(), sqlite3_bind_int64(), sqlite3_bind_null ...
... Zeroblobs are intended to serve as placeholders for BLOBs whose
content is later written using
incremental BLOB I/O routines.
A negative value for the zeroblob results in a zero-length BLOB.
The sqlite3_bind_pointer(S,I,P,T,D) routine ...
|
|
NUL Characters In Strings
(nulinstr.html)
3. How To Tell If You Have NUL Characters In Your Strings
If you CAST a string into a BLOB, then the entire length of the
string is shown. For example:
SELECT a, CAST(b AS BLOB) FROM t1;
Gives this result:
1,X'6162630078797a'
In the BLOB output, you can clearly ...
|
|
JSON Functions And Operators
(json1.html)
3.8. The JSON BLOB Input Bug
If a JSON input is a BLOB that is not JSONB and that looks like
text JSON when cast to text, then it is accepted as text JSON.
This is actually a long-standing bug in the original implementation
that ...
|
|
Row Values
(rowvalue.html)
3.4. Update multiple columns of a table based on a query
... UPDATE ftsdocs SET
idxed=1,
name=NULL,
(label,url,mtime) =
(SELECT printf('Check-in [%%.16s] on %%s',blob.uuid,
datetime(event.mtime)),
printf('/timeline?y=ci&c=%%.20s',blob.uuid),
event.mtime
FROM event, blob
WHERE event ...
|
Page generated by FTS5 in about 109.81 ms.