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

+--------------------------+
| to_base64('abracadabra') |
+--------------------------+
| YWJyYWNhZGFicmE=         |
+--------------------------+
Was this article useful?