Binary string type varbinary is different from string type varchar.

Function Description
Concatenation operator (||) Concatenates strings. The result of a || b is ab.
length(binary) → bigint Returns the length of a binary string in bytes.
concat(binary1, ..., binaryN) → varbinary Returns the concatenation of binary1, ..., binaryN. This function provides the same functionality as the SQL-standard concatenation operator (||).
to_base64(binary) → varchar Encodes a binary string into a Base64 encoded string representation.
from_base64(string) → varbinary Decodes a binary string from a Base64 encoded string.
to_base64url(binary) → varchar Encodes a binary string into a Base64 encoded string representation by using the URL safe alphabet.
from_base64url(string) → varbinary Decodes a binary string from a Base64 encoded string by using the URL safe alphabet.
to_hex(binary) → varchar Encodes a binary string into a hexadecimal string representation.
from_hex(string) → varbinary Decodes a binary string from a hexadecimal encoded string.
to_big_endian_64(bigint) → varbinary Encodes a bigint value in 64-bit two's complement big endian format.
from_big_endian_64(binary) → bigint Decodes a bigint value from a 64-bit two's complement big endian binary string.
md5(binary) → varbinary Computes the MD5 hash of a binary string.
sha1(binary) → varbinary Computes the SHA1 hash of a binary string.
sha256(binary) → varbinary Computes the SHA256 hash of a binary string.
sha512(binary) → varbinary Computes the SHA512 hash of a binary string.
xxhash64(binary) → varbinary Computes the xxhash64 hash of a binary string.