Tutorial Gateway

MySQL UNHEX Function

by

MySQL UNHEX function is one of the String Function which is used to convert the Hexadecimal number into the bytes represented by the Number. The return value of this function is a binary string.

We can call this as an inverse of HEX() function. In this article, we will show you, How to use this string UNHEX in MySQL with example.

MySQL UNHEX Syntax

The basic syntax of the UNHEX Function in MySQL is as shown below:

SELECT HEX(String_Value);

The characters that we specify as an UNHEX argument must represent a legal hexadecimal digits such as 0 to 9, A to F and a to f. If you provide any of the non hexadecimal digit, this function returns NULL.

MySQL Un-Hexadecimal Function Example

The UnHexadecimal Function in MySQL converts the Hexadecimal digits to a string. The following query shows you multiple ways to use this UNHEX function.

SELECT UNHEX('4D7953514C');

SELECT UNHEX('5475746F7269616C2047617465776179');

SELECT UNHEX('48656C6C6F');

OUTPUT

MySQL UNHEX Function 1

Let me take another example.

SELECT UNHEX('31303030');

SELECT UNHEX('31303040');

SELECT UNHEX('31302040');

OUTPUT

MySQL UNHEX Function 2

Thank You for Visiting Our Blog