topic Re: How to retain foreign characters in Talend Studio

How to retain foreign characters

JM39 — Tue, 06 Oct 2020 15:42:57 GMT

Hello

I have some data with names and addresses etc. I'm having trouble with some non english names. For example:

ARMANDO BAUTISTA GARCÍA

The data is given to me in excel format which I save as a .csv as the input file.

On the input file I have the encoding in advanced settings set to UTF-8.

I have also checked 'Allow specific characters (UTF8,...) for columns of schemas.

On the output file I have the encoding in advanced settings set to UTF-8 (also .csv)

But my output file is showing the name as this:

ARMANDO BAUTISTA GARCï¿½A - when I open it in excel

ARMANDO BAUTISTA GARC�A - when I open it in notepad

I want the output to show the same as the input, i.e. to retain the character as it is :

ARMANDO BAUTISTA GARCÍA

Any idea where I'm going wrong? Attached some screen shots. TIA.

pakapi_ — Tue, 06 Oct 2020 18:49:29 GMT

please, open your input csv file in notepad++ and paste here detected encoding. It's on the right-bottom side of application: Maybe it's not UTF-8 ?

JM39 — Wed, 07 Oct 2020 08:52:18 GMT

Thanks for the reply. It definitely is UTF-8.

JM39 — Wed, 07 Oct 2020 08:52:55 GMT

JM39 — Tue, 20 Oct 2020 16:49:34 GMT

I managed to resolve this. I put a tChangeFileEncoding before my main job and that seemed to work