Collections:
Entering Characters as HEX Numbers in MySQL
How To Enter Characters as HEX Numbers in MySQL?
✍: FYIcenter.com
If you want to enter characters as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (0x). A HEX number string will be automatically converted into a character string, if the expression context is a string. Here are some good examples:
SELECT X'313233' FROM DUAL; 123 SELECT 0x414243 FROM DUAL; ABC SELECT 0x46594963656E7465722E636F6D FROM DUAL; FYIcenter.com
⇒ Entering Numeric Values as HEX Numbers in MySQL
⇐ Entering Numeric Values in MySQL
2018-03-31, 1757🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...