BASE64_DECODE()

Procedural SQL (PSQL) StatementsAggregate Functions

`BASE64_DECODE()`

Decodes a base64 string to binary

Result type

VARBINARY or BLOB

Syntax

BASE64_DECODE (base64_data)

Table 1. `BASE64_DECODE` Function Parameter
Parameter	Description
base64_data	Base64 encoded data, padded with `=` to multiples of 4

BASE64_DECODE decodes a string with base64-encoded data, and returns the decoded value as VARBINARY or BLOB as appropriate for the input.If the length of the type of base64_data is not a multiple of 4, an error is raised at prepare time.If the length of the value of base64_data is not a multiple of 4, an error is raised at execution time.

When the input is not BLOB, the length of the resulting type is calculated as type_length * 3 / 4, where type_length is the maximum length in characters of the input type.

Example of `BASE64_DECODE`

select cast(base64_decode('VGVzdCBiYXNlNjQ=') as varchar(12))
from rdb$database;

CAST
============
Test base64

BASE64_DECODE()

BASE64_DECODE()

Example of BASE64_DECODE

`BASE64_DECODE()`

Example of `BASE64_DECODE`