tAzureSynapseInput with special characters

[Burgo]

Hi everyone,

i have the following example data in a SQL table:

{àèéìòù}

and then following piece of code:

 

If i run my job with Talend i have the same data, but if i run my job via scheduled task or cmd i have the following:

 

There is something i can do to replace them?

Thanks

[Anonymous]

Hello,

Please make sure that the Studio run with the java property "-Dfile.encoding=UTF-8" in .ini file.

It will handle correctly Non English characters and the .bat is created to deal with the java to be used by Studio.

Best regards

Sabrina

[Burgo]

Hi Sabrina,

thanks for the reply.

In TOS_ESB-win-x86_64.ini file i've already that line:

 

I've tried adding the same line in .bat and this is the result running it:

 

Thanks.

[Anonymous]

Hello,

Could you also try to solve the problem by editing the job *.bat file in a notepad and adding -Dfile.encoding=utf8 after the java word?

Feel free to let us know if this solution works?

Best regards

Sabrina

[Burgo]

Hi Sabrina,

i've already tried, like you see in my previous post, and the final result is this:

 

Thanks.

[Anonymous]

Hello,

Does it work in .bat file when using tfileinputXXX component with special characters instead of tAzureSynapseInput?

Best regards

Sabrina

[Burgo]

Hi Sabrina,

thanks for the reply.

With tFileInputDelimited i've the exact same behaviour: 

 

1) Run from Talend --> OK: 

 

2) Run from cmd without adding -Dfile.encoding=utf8 --> KO:

 

3) run from cmd adding -Dfile.encoding=utf8 --> KO:

 

 

Thanks.

[Anonymous]

Hello,

In Talend studio, please go to: "File -> edit project properties -> build -> shell -> bat" and then you have to add this line "-Dfile.encoding=utf-8" after "java" like shown in the attached file. This option will start the CMD with UTF-8 encoding.

[Burgo]

Hi Sabrina,

done like you said but same behaviour (like editing .bat directly) again:

 

 

Thanks.

[Anonymous]

Hello,

Have you tried to use utf-8-BOM?

For more information about Unicode character encoding, please have a look at this documentation

https://www.w3.org/International/articles/definitions-characters/

Hope it will help.

Best regards

Sabrina