bad character conversion AS400 CCSID 500

[Anonymous]

Hi,
I have a tAS400Input linked to a tMySqlOutput.
I can't find the correct character set. For example, source character è is read as {.
Source CCSID is 500.
How to set the correct source and target Character set please ?
TOS 3.1
Regards

[_AnonymousUser]

Hi,
We have exactly the same problem. We tried with an IBM JDBC client and it works well, but we can't find out how to get correct results in Talend. We wonder if the jdbc driver for AS400 is up to date in Talend...
So we solved this problem with "replace..." custom code, but it's slow.
We are also interrested in finding a solution.
Regards

[Anonymous]

hi all,
perhaps those tips and trick could help you (it's in french).
I was looking for some clue due to some problem of encoding like you !
++

[Anonymous]

It didn't help us...
Special characters typed in AS400 as "CHAR FOR BYTE" are well converted, but special character typed as "CHAR" in AS400 are not well converted.
We tried some change in windows locales but nothing worked.
If anyone has an idea...
Regards

[Anonymous]

Hi
Did you try to specify String for this specific CHAR ?
And also try to change the encoding type into the Advanced properties component ?
Best regards;

[Anonymous]

Yes, we tried diffrent encoding type in the Advanced properties component.
And the Talend/Java data type is already String.
Regards

[Anonymous]

Hi,
Have you tried "Custom encoding" like CP037 or something like this ?

[Anonymous]

Yes we tried "CP037", "CP500", "CP0500" and it doesn't change anything.
"Modèle" is always transfered as "mod}le".
Regards

[Anonymous]

And it 's strange because the encoding type parameter does not seem to change anything, you can even put "xxxx" as a custom encoding type !

[Anonymous]

no idea ?