Name
sqlite3_value — A database value
Description
The sqlite3_value
structure
holds a database value. The structure contains the value as well
as the type information. A value might hold an integer or
floating-point number, a BLOB, a text value in one of many
different UTF encodings, or a NULL. Values are used as the
parameters to SQL function implementations. They can also be
extracted from statement results.
Value structures come in two types:
protected and
unprotected. Protected values can
safely undergo standalone type conversion, while unprotected
values cannot. SQL function parameters are protected, and can be passed to
any form of sqlite3_value_xxx()
. Values extracted from
sqlite3_column_value()
are not unprotected. They can safely be passed to sqlite3_
bind_
value()
or sqlite3_
result_
value()
, but they cannot be passed to
sqlite3_
value_
xxx()
. To extract a native C datatype from a
statement, use one of the other sqlite3_
column_
xxx()
functions.
The sqlite3_value
structure
is opaque, and an application should never access any of the
data fields directly.
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.