SingleStore DB

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=         |
+--------------------------+