topic Re: Code set Conversion issue even after changing character encoding to UTF8 in Talend Studio

Code set Conversion issue even after changing character encoding to UTF8

SJ3 — Sat, 16 Nov 2024 00:53:04 GMT

Hi,

My job is moving data from Informix to tlogrow component and even after fixing the character encoding settings, I am still getting code set conversion error.

There are international characters in one of the columns. Is there any other way to handle this issue? Should I change something on the informix side?

Thanks!

Re: Code set Conversion issue even after changing character encoding to UTF8

SJ3 — Thu, 31 Dec 2020 21:26:44 GMT

I have checked where it is failing. It has data like this:

"State/province code 佛罗里达 is greater than the maximum allowed length of 3"

So in this case the talend tInformixInput component cannot even read this data no matter what output I choose. Has anyone faced this issue before?

Thanks,

Re: Code set Conversion issue even after changing character encoding to UTF8

Anonymous — Mon, 04 Jan 2021 04:03:11 GMT

Hello,

It seems to be a limitation of informix jdbc driver.

Have you tried to add charSet=windows-1250 in Advanced Settings -> Additional Jdbc parameters to see if it works?

Best regards

Sabrina

Re: Code set Conversion issue even after changing character encoding to UTF8

SJ3 — Wed, 06 Jan 2021 15:35:28 GMT

Hi Sabrina,

I tried this. But it didn't work. Is there any other thing which I can try?

Re: Code set Conversion issue even after changing character encoding to UTF8

Anonymous — Thu, 07 Jan 2021 04:40:39 GMT

Hello,

Informix Error Code -23103 Code-set conversion function failed due to an illegal sequence or invalid value.

Illegal or invalid characters occur in the character string. The program could not execute the code-set conversion on the characters that this string contains. Re-examine the input string for illegal or invalid characters and re-execute the program.

Is it possible to change Chinese character into English?

Best regards

Sabrina

Re: Code set Conversion issue even after changing character encoding to UTF8

SJ3 — Wed, 13 Jan 2021 22:55:34 GMT

Hi Sabrina,

I am reading it from an informix table. How can I change the chinese characters? Do you Know?

Thanks!

Re: Code set Conversion issue even after changing character encoding to UTF8

Anonymous — Wed, 20 Jan 2021 08:41:39 GMT

Hello,

I will make an investigation and consult to my manager on your issue and then come back to you as soon as possible.

Best regards

Sabrina