BASE64_DECODE

Edit online

The BASE64_DECODE scalar function returns a character string that has been Base64 decoded. Base64 encoding is widely used to represent binary data as a string.

Read syntax diagramSkip visual syntax diagramBASE64_DECODE(character-string )
character-string
An expression that returns a character string in CCSID 1208 that is currently Base64 encoded.

The result of the function is a varying length character for bit data string that contains character-string after being Base64 decoded.

Example

  • Decode a binary string that was originally X'1122334455'. The result is the original value.
    VALUES QSYS2.BASE64_DECODE('ESIzRFU=');