When the Flow extracts data from the source and creates CSV files, the columns with the CLOB (
LONGTEXT, etc.) data types can be converted to the binary string encoded using base64 algorithm. The encoded strings looks like the following:
H4sIAAAAAAAAAAXByxGCMBAAUC6WEwL5YPBiKZmwLLIMbJhkHc. If encoding is enabled the Etlworks Integrator also automatically encodes nested datasets.
If you want the Etlworks Integrator to encode CLOB fields and nested datasets enable option
Encode CLOB fields using Base64 when creating or modifying CSV format.
Keep this option disabled if you want the Etlworks Integrator to preserve the original string value like in the source, when configuring the CSV Format. This option is disabled by default.