Mysql UNHEX
From w3cyberlearnings
Contents |
MySQL UNHEX Function
This function converts hexadecimal string to the character represented. This function is the opposite of HEX() function. ASCII Standard or ASCII for additional detail related to the hexcimal number representation.
Syntax UNHEX
- Str: a given string
UNHEX(Str);
Example 1
mysql> SELECT UNHEX('40');
+-------------+
| UNHEX('40') |
+-------------+
| @ |
+-------------+
1 row in set (0.00 sec)
Example 2
mysql> SELECT UNHEX('476F6F64');
+-------------------+
| UNHEX('476F6F64') |
+-------------------+
| Good |
+-------------------+
1 row in set (0.00 sec)
