Function Reference > Functions > ENC_BASE64
  

ENC_BASE64

Encodes data by converting binary data to string data using Multipurpose Internet Mail Extensions (MIME) encoding. Encode data when you want to store data in a database or file that does not allow binary data. You can also encode data to pass binary data in string format. The encoded data is approximately 33% longer than the original data. It displays as a set of random characters.

Syntax

ENC_BASE64( value )
Argument
Required/
Optional
Description
value
Required
Binary or String datatype. Data that you want to encode.

Return Value

Encoded value.
NULL if the input is a null value.

Example

You want to read messages from an MQSeries source and write the data to a flat file target. You want to include the MQSeries message ID as part of the target data. However, the MsgID field is Binary, and the flat file target does not support binary data. Use ENC_BASE64 to encode the MsgID before Data Integration writes the data to the target.