MySQL Tutorial/String Functions/UNHEX

HEX(UNHEX("1267"));

   <source lang="sql">

mysql> mysql> mysql> SELECT HEX(UNHEX("1267")); +--------------------+ | HEX(UNHEX("1267")) | +--------------------+ | 1267 | +--------------------+ 1 row in set (0.02 sec)</source>

UNHEX("GG");

   <source lang="sql">

mysql> mysql> mysql> SELECT UNHEX("GG"); +-------------+ | UNHEX("GG") | +-------------+ | NULL | +-------------+ 1 row in set (0.00 sec) mysql></source>

UNHEX(HEX("string"));

   <source lang="sql">

mysql> mysql> SELECT UNHEX(HEX("string")); +----------------------+ | UNHEX(HEX("string")) | +----------------------+ | string | +----------------------+ 1 row in set (0.00 sec) mysql></source>

UNHEX(str) interprets each pair of hexadecimal digits as a number and converts it to the character

The resulting characters are returned as a binary string.

Performs the inverse operation of HEX(str).

   <source lang="sql">

mysql> SELECT UNHEX("4D7953514C"); +---------------------+ | UNHEX("4D7953514C") | +---------------------+ | MySQL | +---------------------+ 1 row in set (0.00 sec) mysql></source>