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, 3692🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...