Mail adapter to read attachment in different language

[former_member194677]

Hi Experts,

I am working on PI 7.0 and my requirement to read excel attachment, I am using custom java mdoule and it is working fine if the excel file values are in english.

New requirement is  that excel sheet can come in different language(country language like chinese). when tried to execute the scenario with same module. "?" question mark are coming in XML tag as value instead of  real value.

waiting for you valuable inputs.

Thanks

Santosh

[former_member184681]

Hi Santosh,

We cannot really help you a lot, since you say the adapter module is your custom development. This problem doesn't seem solvable with use of standard PI features. All I can say for sure is that you should change the way you read the attachment in your module - you need to take the XML data encoding into consideration.

Regards,

Greg

[former_member194677]

Hi Greg,

Thanks for the response.

Reading the attachment for the languages is the issue related to encoding.

Hi All,

Please let me know if anybody faced this issue earlier or resolved this issue.

Thanks

Santosh

[former_member194677]

Hi Greg,

I have tried all the unicodes but the same result. I want to read japanese language in excel sheet.

But returns question marks where ever japanese character.

Hi Experts,

Please let me know if you have any inputs or piece of code that i can use for encoding.

Thanks