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