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 https://community.talend.com/. We look forward to hearing from you there!



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

jfaza
Member
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? 

Offline

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

xdshi
Talend Team


xdshi said:

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

Hi,
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.
Best regards
Sabrina


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

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy