BINARY_ENCODING_E¶

Defines the binary encodings available for the ENCRYPT(), DECRYPT(), and HMAC() functions.

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_UPPER

Hexadecimal with 0..9 = '0'..'9' and 10..15 = 'A'..'F'.

HEX_LOWER

Hexadecimal with 0..9 = '0'..'9' and 10..15 = 'a'..'f'.

HEX_COLONS

Hexadecimal with 0..9 = '0'..'9' and 10..15 = 'A'..'F'; ':' between each hex byte. Matches BLOB_TO_HEX() output format.

HEX

Hexadecmimal: For input, accepts HEX_UPPER, HEX_LOWER, and HEX_COLONS format. For output, produces HEX_LOWER format.

NONE

No encoding: input or output text is raw binary.