Collections:
UNHEX() - HEX to String Conversion
How to convert a hexadecimal string to a byte sequence using the UNHEX() function?
✍: FYIcenter.com
UNHEX(in) is a MySQL built-in function that converts a hexadecimal string to a byte sequence. For example:
SELECT UNDEX('465949'), HEX('FYI'); -- +-----------------+------------+ -- | UNHEX('465949') | HEX('FYI') | -- +-----------------+------------+ -- | FYI | 465949 | -- +-----------------+------------+
Reference information of the UNDEX() function:
UNHEX(hex): bytes Interprets each pair of characters in the argument as a hexadecimal number and converts it to the byte represented by the number. The return value is a binary string. Arguments, return value and availability: hex: Required. The hexadecimal string to be converted. bytes: Return value. The converted byte sequence. Available since MySQL 5.7.
Related MySQL functions:
⇒ UPPER() - Convert String to Upper Case
⇐ UCASE() - Synonym for UPPER()
2023-11-13, 231🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...