How can we enter numeric values as Hexadecimal (HEX) number in MySQL statement?

MySQLMySQLi Database

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)
raja
Published on 22-Feb-2018 12:17:07
Advertisements