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. |