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

Published on 22-Feb-2018 07:46:18

• Related Questions & Answers
• How can we enter numeric values as Hexadecimal (HEX) number in MySQL statement?
• How can we enter characters as a BINARY number in MySQL statement?
• How can we enter numerical values as a BINARY number in MySQL statement?
• How can we enter BOOLEAN values in MySQL statement?
• How can we escape special characters in MySQL statement?
• In MySQL, how we can write Multiple-line statement?
• How can we use SIGNAL statement with MySQL triggers?
• How can we specify default values in MySQL INSERT statement?
• How can we use MySQL SELECT statement to count number of rows in a table?
• How can we run a MySQL statement without termination semicolon?
• How can we use a MySQL subquery with INSERT statement?
• Can we return query results in same order as the values in MySQL `IN(…)` statement?
• How can we update any value in MySQL view as we can update the values in MySQL table?
• Convert hex string to number in MySQL?
• Can we use WHERE clause inside MySQL CASE statement?