Bind parameter or result set value for an SQL statement.
SQLite types are mapped to JavaScript types as follows:
SQLite
JavaScript
NULL
null
INTEGER
bigint
REAL
number
TEXT
string
BLOB
ArrayBuffer
SQLite INTEGERs are 64-bit signed integers. Attempting to bind a BigInt
whose magnitude is too great to store in a 64-bit signed integer
representation will result in an error.
JavaScript numbers are always bound to statement parameters as double-
precision floating point values, irrespective of whether or not they have
a fractional component.
Bind parameter or result set value for an SQL statement.
SQLite types are mapped to JavaScript types as follows:
NULLnullINTEGERbigintREALnumberTEXTstringBLOBArrayBufferINTEGERs are 64-bit signed integers. Attempting to bind a BigInt whose magnitude is too great to store in a 64-bit signed integer representation will result in an error.numbers are always bound to statement parameters as double- precision floating point values, irrespective of whether or not they have a fractional component.