Skip to main content
Version: Latest-3.3

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