Error :: invalid byte sequence for encoding "UTF8": 0x81"

One Star

Error :: invalid byte sequence for encoding "UTF8": 0x81"

Hi ,
We are loading the data into Greenplum by our talend job using some external files.
We are getting " Due to "invalid byte sequence for encoding "UTF8": 0x81"" this error ?
Can someone please tell me where we are going wrong ?
What we have to modify ? any setting ?
One Star

Re: Error :: invalid byte sequence for encoding "UTF8": 0x81"

Any help on this please?
Highlighted
Seventeen Stars

Re: Error :: invalid byte sequence for encoding "UTF8": 0x81"

There are 2 possibilities:
1. your file contains at first byte a byte which clarifies which char set the file has and this byte is wrong
2. you read a file with a component set to UTF and received a byte which cannot be part of a UTF-8 encoding.
At first you have to ask the people how create your files and get certain about the charset.
One Star

Re: Error :: invalid byte sequence for encoding "UTF8": 0x81"

Hi Jlolling ,
Thanks for your response . We will check for these two points

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now