The binary string type varbinary is different from the string type varchar.

Statement Description
Connection function || The result of a || b  is ab.
length(binary) → bigint Returns the length in binary.
concat(binary1, …, binaryN) → varbinary Connect the binary strings, which is equivalent to ||.
to_base64(binary) → varchar Convert a binary string to a Base64 string.
from_base64(string) → varbinary Convert a Base64 string to a binary string.
to_base64url(binary) → varchar Convert a string to a URL-safe Base64 string.
from_base64url(string) → varbinary  Convert a URL-safe Base64 string to a binary string.
to_hex(binary) → varchar  Convert a binary string to a hexadecimal string.
from_hex(string) → varbinary Convert a hexadecimal string to a binary string.
to_big_endian_64(bigint) → varbinary Convert a number to a binary string in big endian mode.
from_big_endian_64(binary) → bigint Convert a binary string in big endian mode to a number.
md5(binary) → varbinary Calculate the MD5 value of a binary string.
sha1(binary) → varbinary Calculate the SHA1 value of a binary string.
sha256(binary) → varbinary Calculate the SHA256 hash value of a binary string.
sha512(binary) → varbinary Calculate the SHA512 value of a binary string.
xxhash64(binary) → varbinary Calculate the xxhash64 value of a binary string.