base64_decode

Decodes a Base64 encoded string back into its original character representation.

  • Parameters:

    • p_string (str) – The Base64 encoded string to be decoded.

    • p_concatenated (bool) – If True, the function handles multiple concatenated encoded strings within the input.

  • returns: str – The original decoded string.

Examples

Basic decoding

1select base64_decode('YTtiIGMgw7wgw58=') as decoded;

Encoding and decoding in one step

1select
2    base64_encode('a;b c ü ß') as encoded,
3    base64_decode(base64_encode('a;b c ü ß')) as decoded;