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, 1794🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...