SQL binary string functions

Use binary string functions to encode and decode binary string values in SQL queries.

decode

Decode binary data from textual representation in string.

decode(expression, format)

Arguments

  • expression: Expression containing encoded string data. Can be a constant, column, or function, and any combination of string operators.
  • format: Encoding format of the encoded string. Supported formats are:
    • base64
    • hex

encode

encode

Encode binary data into a textual representation.

encode(expression, format)

Arguments

  • expression: Expression containing string or binary data. Can be a constant, column, or function, and any combination of string operators.
  • format: Encoding format to use. Supported formats are:
    • base64
    • hex

decode

View encode query example

Was this page helpful?

Thank you for your feedback!