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
Related functions
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
Related functions
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB Clustered and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.