Functions/Text & patterns/from_hex
Text & patterns Scalar

from_hex()

Converts a value from hexadecimal representation to a blob.

Alias of unhex()

Arguments & returns

from_hex(value)

Scalar
Overload link value Returns
#01 VARCHAR BLOB

Example

from_hex example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Catalog examples

SELECT
  unhex('2A');