• base64 is a method of representing data in a binary format over text protocols. During encoding, text values are converted to binary values 0-63. Each value is stored as an ASCII character based on a conversion chart. 

  • Typically, base64 is used to transmit binary information, such as images, over transfer methods that use text, such as HTTP. 
    
    

    NOTE: base64 is not an effective method of encryption.

  • For more information on base64, see https://en.wikipedia.org/wiki/Base64.

Column reference example:

Output: Decodes the base64 values from the mySource column into text. 

String literal example:

Output: Decodes the input value to the following text: Hello, World. . 

column_string

Name of the column or string constant to be converted.

• Missing string or column values generate missing string results.
• String constants must be quoted ('Hello, World').
• Multiple columns and wildcards are not supported.

Example - base64 encoding and decoding