SQLite hex

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

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.

  1. SELECT hex(67);  
hex(67)
----------
3637