You are not logged in.

Unanswered posts

Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at We look forward to hearing from you there!

#1 2017-04-05 16:52:15

26 posts

jfaza said:

ERROR: invalid byte sequence for encoding "UTF8": 0x00

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? 


#2 2017-04-07 03:43:43

Talend Team

xdshi said:

Re: ERROR: invalid byte sequence for encoding "UTF8": 0x00

Postgesql does not supports zero in characters. 
Could you please take a look at this post: … g-utf8-0x0?
You can use tMap to replace "\\x00" in expression.
Best regards

What we can do is to make sure that Talend will be your best choice!


Board footer

Talend Contributor Agreement - Talend Website Privacy Policy