topic Re: Encoding fails when running the job in the Cloud in Talend Studio

Encoding fails when running the job in the Cloud

jotomren1 — Sat, 16 Nov 2024 04:38:45 GMT

Hi all,

we are reading data from a MS-SQL database, processing it and store the resulting data in Vertica database

Running the job in Studio on my laptop works OK, but when we run the job in the Cloud the strings containing Scandinavian (ø, æ å etc) characters fails

I have added characterEncoding=utf8&characterSetResult=utf8&useUnicode=true as additional parameters on the db connectors, but this does not help

Thank you

Re: Encoding fails when running the job in the Cloud

Anonymous — Mon, 30 Sep 2019 05:49:23 GMT

Hello,

We have redirected your issue to our cloud experts and PMs and then come back to you as soon as we can.

Best regards

Sabrina

Re: Encoding fails when running the job in the Cloud

Anonymous — Mon, 30 Sep 2019 09:21:22 GMT

Hello,

If I'm following correctly you're executing the same job from your Studio local instance (not executing on a Remote Engine?), and there it works fine, no issue with character encoding ?

And then you publish the job to cloud and run the same job (on a Remote Engine or Cloud Engine?) and in this case there is character corruption?

Please state explicitly where it runs locally and in the cloud.

Also what do you mean by 'the strings containing Scandinavian character fails ?

Isn't it possible to avoid using strings having Scandinavian characters if there are in password/connection URL ?

Regards,

Nicolas

Re: Encoding fails when running the job in the Cloud

Anonymous — Fri, 12 Jun 2020 13:43:30 GMT

Hello

Any update on this issue ?

I have a similar problem.

The goal of my job is to request an API, and insert the values in a Microsoft SQL Server table.
When I run my job from Talend studio, I have the "Women's Development Programme" value inserted correctly.
The apostrophe appears well, no problem.

So I publish my job on the cloud, I run it from the TMC, and there I get "Womenâ€™s Development Programme". So it seems that the special characters are badly encoded.

I guess there's something to configure in the TMC maybe.

I ran my job from Talend studio again, and this time the encoding is correct and I get "Women's Development Programme".

Thank you for your help

Regards

Vincent