Categories:

String & Binary Functions (Encoding/Decoding)

# HEX_ENCODE¶

Encodes the input using hexadecimal (also ‘hex’ or ‘base16’) encoding. The result is comprised of 16 different symbols: The numbers ‘0’ to ‘9’ as well as the letters ‘A’ to ‘F’ (or ‘a’ to ‘f’, see below).

## Syntax¶

HEX_ENCODE(<input> [, <case>])


## Arguments¶

Required:

input

A binary or string expression to be encoded.

Optional:

case

This optional boolean argument controls the case of the letters (‘A’, ‘B’, ‘C’, ‘D’, ‘E’ and ‘F’) used in the encoding. The default value is 1 and indicates that uppercase letters are used. The value 0 indicates that lowercase letters are used. All other values are illegal and result in an error.

## Returns¶

This returns a string that contains only hexadecimal digits.

## Examples¶

Encode a string:

SELECT HEX_ENCODE('Snowflake');

-------------------------+
HEX_ENCODE('SNOWFLAKE') |
-------------------------+
536E6F77666C616B65      |
-------------------------+


Encode a string using lowercase letters:

SELECT HEX_ENCODE('Snowflake',0);

---------------------------+
HEX_ENCODE('SNOWFLAKE',0) |
---------------------------+
536e6f77666c616b65        |
---------------------------+