Tencent Cloud

Recent Pages

Binary String Function

마지막 업데이트 시간:2024-03-20 11:47:49

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.
to_hex(binary) → varchar 
Converts a binary string into a hexadecimal string.
from_hex(string) → varbinary
Converts a hexadecimal string into a binary string.
to_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.

문의하기

고객의 업무에 전용 서비스를 제공해드립니다.

기술 지원

더 많은 도움이 필요하시면, 티켓을 통해 연락 바랍니다. 티켓 서비스는 연중무휴 24시간 제공됩니다.

연중무휴 24시간 전화 지원

tencent cloud

Recent Pages

Binary String Function

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

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

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.
to_hex(binary) → varchar	Converts a binary string into a hexadecimal string.
from_hex(string) → varbinary	Converts a hexadecimal string into a binary string.
to_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.

tencent cloud

가입하기

로그인

Recent Pages

Binary String Function

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

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