BASE64DECODE function

BASE64DECODE is a function that manipulates CHARACTER strings that are base64-encoded, and returns a BLOB string that contains the base64-decoded version of the source string.

Syntax

Read syntax diagramSkip visual syntax diagramBASE64DECODE( SourceExpression )

BASE64DECODE returns a BLOB string containing a base64-decoded representation of the source string. The source string can only be of the CHARACTER data type. If SourceExpression is NULL, the result is NULL. If the source string does not contain valid base64 data, SQSTATE 'S22018' exception is produced.

Examples

For examples of usage see the BASE64ENCODE function.