ENCODE

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Encodes binary data into a textual representation.

1encode(<data>, <format>)

• <data>: The binary data to encode.
• <format>: The format to use when encoding the string (base64, hex, or escape).

Returns a text value that contains the encoded representation.

• The escape format converts zero bytes and high-bit-set bytes to octal sequences.

Encode binary data to base64.

1SELECT encode('123\000\001', 'base64') AS result;

Returns 'MTIzXDAwMFwwMDE='.

• String Types