Documentation

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!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

New in InfluxDB 3.4

Key enhancements in InfluxDB 3.4 and the InfluxDB 3 Explorer 1.2.

See the Blog Post

InfluxDB 3.4 is now available for both Core and Enterprise, which introduces offline token generation for use in automated deployments and configurable license type selection that lets you bypass the interactive license prompt. InfluxDB 3 Explorer 1.2 is also available, which includes InfluxDB cache management and other new features.

For more information, check out: