I received the following error when insert string column from mysql to Postgres.
Some of the rows were fixed when I did trim(both CHAR(0x00) from text) in my sql.
But I am still getting this error for some other rows.
Maybe it has invalid characters in the middle.
How do I get rid of them?
Postgesql does not supports zero in characters.
Could you please take a look at this post:http://stackoverflow.com/questions/1347 … g-utf8-0x0?
You can use tMap to replace "\\x00" in expression.
What we can do is to make sure that Talend will be your best choice!