Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

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). mysql> SELECT UNHEX('4D7953514C'); +---------------------+ | UNHEX('4D7953514C') | +---------------------+ | MySQL               | +---------------------+ 1 row in set (0.00 sec) mysql>