Collections:
TO_BASE64() - Base64 Encoding
How to encode a byte sequence to a Base64 string using the TO_BASE64() function?
✍: FYIcenter.com
TO_BASE64(bin) is a MySQL built-in function that
encodes a byte sequence to a Base64 string.
For example:
SELECT FROM_BASE64('RllJ'), TO_BASE64('FYI');
-- +---------------------+------------------+
-- | FROM_BASE64('RllJ') | TO_BASE64('FYI') |
-- +---------------------+------------------+
-- | FYI | RllJ |
-- +---------------------+------------------+
SELECT FROM_BASE64('My4xNA=='), TO_BASE64(3.14);
-- +-------------------------+-----------------+
-- | FROM_BASE64('My4xNA==') | TO_BASE64(3.14) |
-- +-------------------------+-----------------+
-- | 3.14 | My4xNA== |
-- +-------------------------+-----------------+
SELECT TO_BASE64('FYI'), TO_BASE64(X'465949'), X'465949';
-- +------------------+----------------------+-----------+
-- | TO_BASE64('FYI') | TO_BASE64(X'465949') | X'465949' |
-- +------------------+----------------------+-----------+
-- | RllJ | RllJ | FYI |
-- +------------------+----------------------+-----------+
Reference information of the TO_BASE64() function:
TO_BASE64(bin): b64 Converts the binary argument to base-64 encoded form and returns the result as a character string with the connection character set and collation. The result is NULL if the argument is NULL. Arguments, return value and availability: bin: Required. The binary sequence. b64: Return value. The Base64 string. Available since MySQL 5.7.
Related MySQL functions:
⇐ SUBSTRING_INDEX() - Substring in Delimited String
2023-11-18, 1164🔥, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...