topic Re: [resolved] BYTEA in Talend Studio

[resolved] BYTEA

WEBER1 — Thu, 18 Sep 2014 16:28:40 GMT

hello,
I have a postgresql table with bytea.
I want to get a file with my field bytea but I don't know how to unescape my field with talend so the size of my flied is X2.
thanks

Re: [resolved] BYTEA

Anonymous — Fri, 19 Sep 2014 10:31:20 GMT

It is hard for me to understand what do you mean and whats your problem. Perhaps you spend some more sentences to explain your issue a bit deeper.
http://www.postgresql.org/docs/9.0/static/datatype-binary.html

Re: [resolved] BYTEA

WEBER1 — Fri, 19 Sep 2014 13:12:26 GMT

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

Re: [resolved] BYTEA

Anonymous — Fri, 19 Sep 2014 20:26:08 GMT

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.

Re: [resolved] BYTEA

WEBER1 — Mon, 22 Sep 2014 14:17:43 GMT

I find.
It is not a talend problem.
It's a conf postgresql problem (we must have bytea_output = 'escape' in postgresql.conf)
It could be closed.

Re: [resolved] BYTEA

Anonymous — Mon, 22 Sep 2014 14:29:47 GMT

You can mark it at resolved