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

Last modified: February 27, 2023

Was this article helpful?