Convert hex to raw, load to DB

We have a file with a hex datatype that has special characters when converted. Trying to use talend to convert this to raw and then load to a postgres database. 
We are using tMap to call a routine which uses the hex data column as the input similar to this post.
Running into issues trying to then load to database. Wondering if this a talend issue (known that they've said they don't support hex conversions) or a database issue.
Get the error message on the insert where it seems the insert statement can't read some of the special characters.
Any advice appreciated. 
1 REPLY
Four Stars

Re: Convert hex to raw, load to DB

We have a file with a hex datatype that has special characters when converted. Trying to use talend to convert this to raw and then load to a postgres database. 
We are using tMap to call a routine which uses the hex data column as the input similar to this post.
Running into issues trying to then load to database. Wondering if this a talend issue (known that they've said they don't support hex conversions) or a database issue.
Get the error message on the insert where it seems the insert statement can't read some of the special characters.
Any advice appreciated. 

if you write to a character field in postgres: pg does not allow 0x00 !!! you Need to replace this first or write into varbinary field.
HTH
PS: see the postgreslog for detailed errormessages or switch off batchmode in the component to see what really happens