When the flow extracts data from the database and creates CSV files the columns with the CLOB (TEXT, LONGTEXT, etc.) data types are converted to the binary string which looks like the following:
Integrator also automatically encodes nested datasets.
If you want integrator to preserve the original string value like in the source, when configuring the CSV format, disable Encode CLOB fields using Base64. This option is enabled by default.