topic Re: [resolved] Foreign language special characters handling. in Talend Studio

[resolved] Foreign language special characters handling.

Anonymous — Sat, 16 Nov 2024 13:14:29 GMT

I am expiriencing a problem with loading foreign language data (Mexican) from Excel into MySQL.
My original file has this string: ' MEGA CHEDRAUI ACAPULCO Calzada Pié de la cuesta No 239 Col.'
I created Excel metadata in UTF-8 format, however it seems that is not handling characters properly. When I at the data in Preview mode, I see that string is corrupted: ' MEGA CHEDRAUI ACAPULCO Calzada Pi de la cuesta No 239 Col.'
Direct insert into a table works fine - I get expected results. MySQL table is created with UTF8 charset.
Please explain how to handle international data properly.

Re: [resolved] Foreign language special characters handling.

Anonymous — Fri, 22 Oct 2010 14:26:59 GMT

Did you try to use another encoding like "ISO-8859-15" in your EXCEL input component and use the UTF-8 on your MYSQLOUTPUT.
Normally JAVA will handle the conversion between the source and the target.
It might be interesting to test it.
Best regards.

Re: [resolved] Foreign language special characters handling.

Anonymous — Fri, 22 Oct 2010 15:27:14 GMT

This post may help:
https://community.talend.com/t5/Design-and-Development/resolved-problem-with-tMysqlOutput-and-Encoding/td-p/73824

Re: [resolved] Foreign language special characters handling.

Anonymous — Fri, 22 Oct 2010 18:54:05 GMT

@cantoine
I tried your suggestion - it worked. But it is so counterintuitive!?
I made sure every setting to be set to UTF8 and it turns out there is no need to do that. Weird... Seems like usability bug.
Anyways, thank you!
@John.
Thank you for pointing to this topic. It didn't resolve this issue but helped me to reveal and fix another one - my server level encoding was not UTF8.
Peter.

Re: [resolved] Foreign language special characters handling.

_AnonymousUser — Mon, 19 Sep 2016 13:25:24 GMT

Hello, friends!
If you strive to master several foreign languages at once, this source is indispensable to visit, follow and find out awesome effective techniques to learn languages and achieve quick results