Name
hex() — Dump BLOB as hexadecimal
Common Usage
hex( data
)
Description
The hex()
function converts a BLOB value into a
hexadecimal text representation. The parameter data
is assumed to be a BLOB. If
it is not a BLOB, it will be converted into one. The returned
text value will contain two hexadecimal characters for each byte
in the BLOB.
Be careful about using hex()
with large BLOBs. The
UTF-8 text representation is twice as big as the original BLOB
value, and the UTF-16 representation is four times as
large.
See Also
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.