SingleStore Managed Service

UNHEX

Converts a hexadecimal representation to the binary equivalent.

Syntax
UNHEX(expression)
Arguments

expression

A hexadecimal expression, in upper or lower case.

Return Type

Binary data.

Examples
SELECT HEX('ohai');
+-------------+
| HEX('ohai') |
+-------------+
| 6F686169    |
+-------------+

SELECT UNHEX('6F686169');
+-------------------+
| UNHEX('6F686169') |
+-------------------+
| ohai              |
+-------------------+