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.
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
