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, 1891🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...