All Products
Search
Document Center

Binary functions and operators

Last Updated: Jan 15, 2019

length(binary) → bigint

Returns the binary length in bytes.

to_base64(binary) → varchar

Encodes binary into a base64 string.

from_base64(string) → varbinary

Decodes binary data from the base64 encoded string.

to_base64url(binary) → varchar

Encodes binary into a base64 string with URL safe alphabet.

from_base64url(string) → varbinary

Decodes binary data from the base64 encoded string with URL safe characters.

to_hex(binary) → varchar

Encodes binary into a hex string.

from_hex(string) → varbinary

Decodes binary data from a hex encoded string.

to_big_endian_64(bigint) → varbinary

Encodes bigint into a 64-bit two’s complement big endian format.

from_big_endian_64(binary) → bigint

Decodes bigint value from a 64-bit two’s complement big endian binary.

md5(binary) → varbinary

Computes the md5 hash of binary.

sha1(binary) → varbinary

Computes the sha1 hash of binary.

sha256(binary) → varbinary

Computes the sha256 hash of binary.

sha512(binary) → varbinary

Computes the sha512 hash of binary.

xxhash64(binary) → varbinary

Computes the xxhash64 hash of binary.