Sorry I use a tPostgresqlInput to access my table. My query returns just one blob (one column and one row). So, in the schema, I have just one column (type=byte and db type=BYTEA). I join the tPostgresql to a tFileOutputDelimeted in which the output schema has one row with the type byte. When I execute the job, the size of the output file is X2 rather the size of bytea field. I have the same jobs with a tDB2Input or a tMysqlInput and they are OK. I think, it's because of the representation of bytea type and how talend reads it. I don't know if I must change my query, choose another java type in my schema or something else. thanks
If I understood you correctly you want to get the content as String. I would check what you get if you setup the schema column to the data type String (with the dbType VARCHAR). I would bet you will get the correct content.