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, 264🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...