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

Following are the two approaches with the help of which we can enter characters 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 character string.

Example

mysql> Select X'5152545678';
+---------------+
| X'5152545678' |
+---------------+
| QRTVx         |
+---------------+
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 character string.

Example

mysql> Select 0x5152545678;
+--------------+
| 0x5152545678 |
+--------------+
| QRTVx        |
+--------------+
1 row in set (0.00 sec)

mkotla

Updated on: 22-Jun-2020

759 Views

Kickstart Your Career

Get certified by completing the course

Get Started