Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

TO_BASE64

Returns the argument str converted to base-64 encoding. If the argument is not a string, it is converted to a string before the encoding takes place. Returns NULL if the argument is NULL.

Syntax

TO_BASE64 (str)

Arguments

  • str: any string - if str is not a string, it will be converted before the encoding

Return Type

Binary string

Examples

SELECT TO_BASE64('abracadabra');
+--------------------------+
| TO_BASE64('abracadabra') |
+--------------------------+
| YWJyYWNhZGFicmE=         |
+--------------------------+