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.