Skip to main content
Version: Latest-3.2

hex_decode_binary

Description​

Decodes a hex encoded string to a binary.

This function is supported from v3.0.

Syntax​

hex_decode_binary(str);

Parameters​

str: the string to convert. The supported data type is VARCHAR.

An empty binary is returned if any of the following situations occur:

  • The length of the string is 0 or the number of characters in the string is an odd number.
  • The string contains characters other than [0-9], [a-z], and [A-Z].

Return value​

Returns a value of the VARBINARY type.

Examples​

mysql> select hex(hex_decode_binary(hex("Hello StarRocks")));
+------------------------------------------------+
| hex(hex_decode_binary(hex('Hello StarRocks'))) |
+------------------------------------------------+
| 48656C6C6F2053746172526F636B73                 |
+------------------------------------------------+

mysql> select hex_decode_binary(NULL);
+--------------------------------------------------+
| hex_decode_binary(NULL)                          |
+--------------------------------------------------+
| NULL                                             |
+--------------------------------------------------+

Keywords​

HEX_DECODE_BINARY