HEX

Converts a value into a hexadecimal string representation.

This function corresponds to the hex(X) function in SQLite. It interprets its argument X and returns its value as a hexadecimal string.

• If the argument is a BLOB, it returns a hexadecimal rendering of the BLOB content.

• If the argument is a TEXT string, it treats it as a BLOB and returns the hexadecimal rendering.

• If the argument is a number (INTEGER or REAL), it's cast to an INTEGER and its 64-bit big-endian representation is returned as a hexadecimal string.

• If the argument is NULL, the result is NULL.

Example

// For a BLOB column: SELECT hex(data) FROM Files
// For a number: SELECT hex(12345) -> '0000000000003039'
select(HEX(MyTable.someColumn)).from(MyTable)

Parameters

See also