Collections:
FROM_BASE64() - Base64 Decoding
How to decode a Base64 string using the FROM_BASE64() function?
✍: FYIcenter.com
FROM_BASE64(str) is a MySQL built-in function that
decodes 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== |
-- +-------------------------+-----------------+
Reference information of the FROM_BASE64() function:
FROM_BASE64(str): bin Takes a string encoded with the base-64 encoded rules used by TO_BASE64() and returns the decoded result as a binary string. Arguments, return value and availability: str: Required. The input Base64 string. bin: Return value. The decoded bytes. Available since MySQL 5.7.
Related MySQL functions:
⇒ HEX() - Calculate HEX representation
⇐ FIND_IN_SET() - Find Substring in List String
2023-11-18, 1387🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...