Skip to contents

DuckDB function decode

Source: R/duckdb-funs.R
decode.Rd

Converts blob to VARCHAR. Invalid UTF-8 is handled based on the error behavior argument. Can be 'strict' (default, fail), 'replace' to replace invalid characters with '?', or 'ignore' to skip invalid characters.

Arguments

blob

BLOB

varchar

VARCHAR

Value

VARCHAR

Overloads

  • decode(blob = BLOB)

  • decode(blob = BLOB, varchar = VARCHAR)

SQL examples

decode('\xC3\xBC'::BLOB)
decode('\xA0'::BLOB, 'replace')
decode('\xA0'::BLOB, 'ignore')

See also

Other blob: encode(), from_base64(), hex(), md5(), md5_number(), octet_length(), or–or, repeat(), sha1(), sha256(), to_base64(), unbin(), unhex()