UNHEX()¶
Function description¶
The UNHEX() function is used to convert a hexadecimal string to the corresponding binary string. For the NULL parameter, this function returns NULL.
Function Syntax¶
> UNHEX(str)
Parameter definition¶
Parameters |
Description |
|---|---|
str |
Required parameters. Must be a legal hexadecimal value. |
Example¶
mysql> SELECT UNHEX('4d6174726978204f726967696e');
+------------------------------------------+
| unhex(4d6174726978204f726967696e) |
+------------------------------------------+
| Matrix Origin |
+------------------------------------------+
1 row in set (0.00 sec)
mysql> select unhex(NULL);
+-----------------+
| unhex(null) |
+-----------------+
| NULL |
+-----------------+
1 row in set (0.00 sec)