- 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).
- See also:
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 value0
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 |
---------------------------+