w3resource

SQLite hex() function

Description

The hex() function interprets its argument as a BLOB and returns a string which is the upper-case hexadecimal rendering of the content of that blob.

Syntax:

hex(X)

Arguments

Name Description
N Integers whose character values (according to the ASCII table) are to be retrieved.

Example: SQLite hex() function

The following SQLite statement returns character values (according to the ASCII table) of the integers 67, 72, 65 and 82.

SELECT hex(67);

Sample Output:

hex(67)
----------
3637

Previous: instr()
Next: last_insert_rowid()