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時間365日のサポートをご提供します。

電話サポート（24 時間365日対応）

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

この記事はお役に立ちましたか？

この記事はお役に立ちましたか？