Entering Characters as HEX Numbers in MySQL

Q

How To Enter Characters as HEX Numbers in MySQL?

✍: FYIcenter.com

A

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

 

Introduction to SQL Basics in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 204👍, 0💬