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, 276🔥, 0💬
Popular Posts:
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...