MySQL | TO_BASE64 method
Start your free 7-days trial now!
MySQL's TO_BASE64(~) method converts the input string to base64 and returns it as a character string.
base64 is a method to encode binary data using ASCII characters. As ASCII characters are available in most character sets, this means there is a low chance of data corruption. Each base64 digit represents 6 bits of data. Therefore, 3 bytes (24 bits) can be represented using 4 base64 digits.
There are a few rules followed by TO_BASE64(~):
Encoding for alphabet value 62 is
'+'Encoding for alphabet value 63 is
'/'Output is in groups of 4 printable characters. If the last group is incomplete, it will be padded with
'='character.Newline is added after every 76 characters of encoded output.
Parameters
1. str | string
The string to be converted to base64.
Return value
A character string of the input string converted to base64.
Examples
Basic usage
To convert 'Apple' to a base64 encoded string:
SELECT TO_BASE64('Apple');
+--------------------+| TO_BASE64('Apple') |+--------------------+| QXBwbGU= |+--------------------+
Numeric argument
Non-string arguments are automatically converted to a string first before conversion to base64:
SELECT TO_BASE64(30), TO_BASE64('30');
+---------------+-----------------+| TO_BASE64(30) | TO_BASE64('30') |+---------------+-----------------+| MzA= | MzA= |+---------------+-----------------+
Note that the returned base64 string is the same whether we provide 30 or '30' as input.
NULL argument
NULL argument returns NULL:
SELECT TO_BASE64(NULL);
+-----------------+| TO_BASE64(NULL) |+-----------------+| NULL |+-----------------+
