MySQL8 TO_BASE64() Functions – String Functions

by · Published · Updated

MySQL TO_BASE64() Functions: Syntax

TO_BASE64 ( string );

MySQL TO_BASE64() Functions: Description

TO_BASE64() functions convert the string parameter value to base-64 encoded form and return the result as a character string with the connection character set and collation.

If the parameter is not a string, it is converted to a string before the conversion takes place.

We can decode the TO_BASE64 strings with FROM_BASE64() function.

There are many base-64 encoding schemes. Below rules are used by TO_BASE64() and FROM_BASE64() for encoding and decoding:

  • The encoding for alphabet value 62 is ‘+’.
  • The encoding for alphabet value 63 is ‘/’.
  • The encoded output consists of groups of 4 printable characters. Every 3 bytes of the input data are encoded using 4 characters. If the last group is incomplete, it is padded with ‘=’ characters to a length of 4.
  • A newline is added after every 76 characters of encoded output to divide the long output into multiple lines. See example 3.
  • Decoding recognizes and ignores newline, carriage return, tab, and space.
Note : The result is NULL if the argument is NULL. See example 1.

MySQL TO_BASE64() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|30%|55%” colalign=”left|left|left”]
Name, Required /Optional, Description
string, Required, The input string.
[/table]

MySQL TO_BASE64() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Returns,
NULL, if the argument is NULL.
String, after converting the input parameter value to base-64 encoded form.
[/table]

MySQL TO_BASE64() Functions: Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 5.0
[/table]

MySQL TO_BASE64() Functions: Example 1

mysql> SELECT TO_BASE64(NULL);
+-----------------+
| TO_BASE64(NULL) |
+-----------------+
| NULL            |
+-----------------+
1 row in set (0.06 sec)

MySQL TO_BASE64() Functions: Example 2

mysql> SELECT TO_BASE64('tutorialmines');
+----------------------------+
| TO_BASE64('tutorialmines') |
+----------------------------+
| dHV0b3JpYWxtaW5lcw==       |
+----------------------------+
1 row in set (0.00 sec)

A newline is added after each 76 characters of encoded output to divide long output into multiple lines.

mysql> SELECT TO_BASE64(' Welocme to my site for tutorials you will find tuts of web techs, mobile extra') as 'NEW LINE EXAMPLE';
+---------------------------------------------------------------------------------------------------------------+
| NEW LINE EXAMPLE                                                                                              |
+---------------------------------------------------------------------------------------------------------------+
| IFdlbG9jbWUgdG8gbXkgc2l0ZSBmb3IgdHV0b3JpYWxzIHlvdSB3aWxsIGZpbmQgdHV0cyBvZiB3
ZWIgdGVjaHMsIG1vYmlsZSBleHRyYQ== |
+---------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

See all MySQL String functions MySQL 8 String Functions.

Related articles : FROM_BASE64(),  ELT(), CONCAT(), CONCAT_WS() ,LOWER(), UPPER(), LTRIM(), RTRIM().

PHP Related articles : CONVERT_UUENCODE(), CONVERT_UUDECODE(), QUOTED_PRINTABLE_ENCODE(), QUOTED_PRINTABLE_DECODE(), PHP STRING FUNCTIONS().

You may also like...