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()



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/sqlite/core-functions-hex.php