decode()

Converts blob to VARCHAR. Fails if blob is not valid UTF-8.

Arguments & returns

Scalar

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

SELECT decode('\xC3\xBC'::BLOB);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT decode('\xA0'::BLOB, 'replace');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT decode('\xA0'::BLOB, 'ignore');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

DECODE(x, 'utf-8')

In DuckDB

DECODE(x)

FROM_UTF8(x)

In DuckDB

DECODE(x)

SELECT BASE64_DECODE_STRING('U25vd2ZsYWtl')

In DuckDB

SELECT DECODE(FROM_BASE64('U25vd2ZsYWtl'))