How can we enter numeric values as Hexadecimal (HEX) number in MySQL statement?
Following are the two approaches with the help of which we can enter numeric values as a Hexadecimal number −
By prefix ‘X’
In this approach we need to quote hexadecimal numbers within single quotes with a prefix of X. Then HEX number string will be automatically converted into a number based on the expression context.
Example
mysql> Select X'5152545678'+ 10;
+-------------------+
| X'5152545678'+ 10 |
+-------------------+
| 349273609858 |
+-------------------+
1 row in set (0.00 sec)
By prefix 0x
In this approach, we need to write hexadecimal numbers without any quotes with a prefix of 0x. Then HEX number string will be automatically converted into a numerical value based on the expression context.
Example
mysql> Select 0x5152545678+10;
+-----------------+
| 0x5152545678+10 |
+-----------------+
| 349273609858 |
+-----------------+
1 row in set (0.00 sec)
Published on 22-Feb-2018 12:17:07
