BINARY_ENCODING_E

Last published : Oct 30, 2026
Defines the binary encodings available for the ENCRYPT(), DECRYPT(), and HMAC() functions.
This topic lists the expressions that are provided by this class.

Enumerations

BASE64
Original PEM base64-encoding: 6 bits (0..63) enocded as one ASCII character: 0..23 = 'A'..'Z', 24..51 = 'a'..'z', 52..61 = '0'..'9', 62 = '+', 63 = '/', '=' = pad byte. Four bytes encoded as three characters. CR/LF every 64 characters.
BASE64URL
URL and Filename safe base64-encoding: same as BASE64 except 62 = '-', 63 = '_' and no CR/LFs. Pad byte? Can be used in URLs without requiring escaping.
HEX
Hexadecmimal: For input, accepts HEX_UPPER, HEX_LOWER, and HEX_COLONS format. For output, produces HEX_LOWER format.
HEX_COLONS
Hexadecimal with 0..9 = '0'..'9' and 10..15 = 'A'..'F'; ':' between each hex byte. Matches BLOB_TO_HEX() output format.
HEX_LOWER
Hexadecimal with 0..9 = '0'..'9' and 10..15 = 'a'..'f'.
HEX_UPPER
Hexadecimal with 0..9 = '0'..'9' and 10..15 = 'A'..'F'.
NONE
No encoding: input or output text is raw binary.