The quote()
function returns a text value that
represents the SQL literal representation of
. Numbers are returned in their string representation
with enough digits to preserve precision. Text values are
returned inside single quotes with any internal single quote
characters properly escaped. BLOBs are returned as hexadecimal
literals. NULLs are returned as the string value
NULL
.
In SQLite v3.6.23.1 and earlier, this
function was used internally by VACUUM
. It is strongly recommended that the
default implementation is not overridden.