Data Decode not working as expected Postgres

[Anonymous]

Im using the below update statement to decode a value in column .

update table set col =substring(decode(decode(col,'escape')::text,'hex')::varchar,1,25)

it works fine when i run it in pgadmin/dbeaver or any client tools.. but the same is not working when running via talend tpostgresrow component.

In Client tools:

sample values: select substring(decode(decode('2342354354','escape')::text,'hex')::varchar,1,25)

Op: "#B5CT"

in talend 

op : "\x2342354354"

[fdenis]

23 = #
54 = T
from hex to acsii
so tis' working but the driver used to connect postgres do not translate response as acsii.
check your driver/db configuration or use TEXT(x) data type or convert result to ascii or utf8 char.
good luck