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?
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.
Highlighted
One Star

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

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog