{ “title”: “TO_BASE64_BINARY”, “language”: “en”, “description”: “The TOBASE64BINARY function converts the input binary string into Base64 encoding format.” }

Description

The TO_BASE64_BINARY function converts the input binary string into Base64 encoding format. Base64 encoding converts arbitrary binary data into a string composed of 64 characters.

Syntax

TO_BASE64_BINARY(<bin>)

Parameters

ParameterDescription
<bin>The binary to be Base64 encoded. Type: VARBINARY

Return Value

Returns VARCHAR type, representing the Base64 encoded string.

Special cases:

  • If input is NULL, returns NULL
  • If input is an empty VARBINARY (zero bytes), returns an empty string

Examples

  1. Single character encoding
SELECT to_base64_binary(x'12');

+-------------------------+
| to_base64_binary(x'12') |
+-------------------------+
| Eg==                    |
+-------------------------+
  1. Multiple character encoding
SELECT to_base64_binary(x'234AAA');

+-----------------------------+
| to_base64_binary(x'234AAA') |
+-----------------------------+
| I0qq                        |
+-----------------------------+