HEX_ENCODE()

All functions > STRING > HEX_ENCODE()

Encodes a string as a contiguous hexadecimal string (two hex digits per byte).

Signatures

Returns: Hex digits only (length is even for non-NULL input)

HEX_ENCODE(string: VARCHAR) → VARCHAR

Notes

• Each input byte becomes two hexadecimal characters (uppercase A–F)
• Returns NULL if the input is NULL (use NULL(VARCHAR); bare NULL fails inference)
• Pair with HEX_DECODE to recover the original string when the hex is valid

See also

• String functions

Examples

SELECT
    f1 := HEX_ENCODE('hello'), -- UTF-8 bytes of ASCII text
    f2 := HEX_ENCODE(''), -- Empty string
    f3 := HEX_ENCODE(NULL(VARCHAR)) -- NULL yields NULL
;