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, 260🔥, 0💬
Popular Posts:
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...