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, 1689🔥, 0💬
Popular Posts:
What Happens to the Current Transaction If a START TRANSACTION Is Executed in MySQL? If you are in a...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What Happens to an Arithmetic Operation with Two Different Data Types in SQL Server Transact-SQL? Wh...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...