DECODE

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Decodes binary data from a textual representation.

1decode(<string>, <format>)

• <string>: The encoded string to decode.
• <format>: The encoding format of the string (base64, hex, or escape).

Returns bytea (binary data) decoded from the textual representation.

Decode a base64-encoded string.

1SELECT decode('MTIzXDAwMFwwMDE=', 'base64') AS result;

Returns 123\000\001.

• String Types