Name
quote() — Return the SQL literal representation of a value
Common Usage
quote( value
)
Description
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.
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.