UNHEX() FUNCTION in MySQL

UNHEX() FUNCTION The MySQL UNHEX function is used to convert a hexadecimal value to a string.

Syntax:

UNHEX (value);

Parameters: value: It is used to specify the hexadecimal value to convert.

Example:

mysql> SELECT UNHEX (‘41’);

Output:

‘A’

Explanation: The string for the specified hexadecimal value is returned.

Please follow and like us:
Content Protection by DMCA.com