MySQL8 FROM_BASE64() Functions – String Functions

by · Published · Updated

MySQL FROM_BASE64() Functions: Syntax

FROM_BASE64 ( string );

MySQL FROM_BASE64() Functions: Description

FROM_BASE64() functions decode a string encoded with the base-64 encoding rules used by TO_BASE64() and return the decoded result as a binary string.

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

Below are the details about the encoding and decoding rules. 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. Each 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 each 76 characters of encoded output to divide 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 FROM_BASE64() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|30%|55%” colalign=”left|left|left”]
Name, Required /Optional, Description
string, Required, The input string is string encoded with the base-64 encoded rules used by TO_BASE64() .
[/table]

MySQL FROM_BASE64() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Returns,
NULL, if the argument is NULL or not a valid base-64 string. See Example 1 and 2.
Binary string, returns the decoded result as a binary string.
[/table]

MySQL FROM_BASE64() Functions: Available from

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

MySQL FROM_BASE64() Functions: Example 1

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

MySQL FROM_BASE64() Functions: Example 2

mysql> SELECT FROM_BASE64('x0fnjjf');
+------------------------+
| FROM_BASE64('x0fnjjf') |
+------------------------+
| NULL                   |
+------------------------+
1 row in set (0.00 sec)

MySQL FROM_BASE64() Functions: Example 3

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

See all MySQL String functions MySQL 8 String Functions.

Related articles : TO_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...