tencent cloud

Cloud Log Service

Binary String Function

Download
포커스 모드
폰트 크기
마지막 업데이트 시간: 2026-06-05 13:11:22
This document introduces the basic syntax and examples of binary string functions.
The binary string type varbinary is different from the string type varchar.
Statement
Description
Concatenation function ||
The result of a || b is ab.

length
(binary) → bigint
Returns a binary length.

concat
(binary1, …, binaryN) → varbinary
Concatenates binary strings. This function provides the same functionality as ||.

to_base64
(binary) → varchar
Converts a binary string into a base64 string.

from_base64
(string) → varbinary
Converts a base64 string into a binary string.

to_base64url
(binary) → varchar
Converts a binary string into a base64 string with a URL safe alphabet.

from_base64url
(string) → varbinary
Converts a base64 string with a URL safe alphabet into a binary string.
t
o_hex
(binary) → varchar
Converts a binary string into a hexadecimal string.
f
rom_hex
(string) → varbinary
Converts a hexadecimal string into a binary string.
t
o_big_endian_64
(bigint) → varbinary
Converts a bigint number into a big endian binary string.

from_big_endian_64
(binary) → bigint
Converts a big endian binary string into a number.

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.


도움말 및 지원

문제 해결에 도움이 되었나요?

피드백