https://community.qlik.com/t5/Talend-Studio/Convert-hex-to-raw-load-to-DB/m-p/2338472#M106702 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.&nbsp;<BR />We are using tMap to call a routine which uses the hex data column as the input similar to this post. <BR />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.<BR />Get the error message on the insert where it seems the insert statement can't read some of the special characters.<BR />Any advice appreciated.&nbsp; Tue, 26 Jul 2016 14:45:44 GMT Anonymous 2016-07-26T14:45:44Z https://community.qlik.com/t5/Talend-Studio/Convert-hex-to-raw-load-to-DB/m-p/2338472#M106702 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.&nbsp;<BR />We are using tMap to call a routine which uses the hex data column as the input similar to this post. <BR />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.<BR />Get the error message on the insert where it seems the insert statement can't read some of the special characters.<BR />Any advice appreciated.&nbsp; Tue, 26 Jul 2016 14:45:44 GMT https://community.qlik.com/t5/Talend-Studio/Convert-hex-to-raw-load-to-DB/m-p/2338472#M106702 Anonymous 2016-07-26T14:45:44Z https://community.qlik.com/t5/Talend-Studio/Convert-hex-to-raw-load-to-DB/m-p/2338473#M106703 <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>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.&nbsp;<BR />We are using tMap to call a routine which uses the hex data column as the input similar to this post. <BR />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.<BR />Get the error message on the insert where it seems the insert statement can't read some of the special characters.<BR />Any advice appreciated.&nbsp;</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />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. <BR />HTH <BR />PS: see the postgreslog for detailed errormessages or switch off batchmode in the component to see what really happens Tue, 26 Jul 2016 16:45:41 GMT https://community.qlik.com/t5/Talend-Studio/Convert-hex-to-raw-load-to-DB/m-p/2338473#M106703 Anonymous 2016-07-26T16:45:41Z