unhex()

Converts a value from hexadecimal representation to a blob.

Arguments & returns

Scalar

Overload link	`value`	Returns
#01	`VARCHAR`	`BLOB`

SELECT unhex('2A');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SHA1(x)

In Haybarn

UNHEX(SHA1(x))

SELECT SHA256(x)

In Haybarn

SELECT UNHEX(SHA256(x))

SELECT x'ABCD'

In Haybarn

SELECT UNHEX('ABCD')