File Content conversion issue

[former_member200386]

Dear Experts,

We are receiving a fixed length file which contains both English and Chinese letters . We are facing the issue while converting the Chinese characters.

We are maintaining the file type as "TEXT"  encoding as "UTF-8".

Here is the example.

Source file :

000124151CRAIG                                        OPRAY                                                                                     34070PI   AUS ( English Characters)

002272309                                             高峰                                                                                    28220LC   CHN (Chinese Characters)

<DETAIL>

  <EMP_ID>000124151</EMP_ID>

  <First_Name>CRAIG</First_Name>

  <Last_Name>OPRAY</Last_Name>

  <P_A_Dealer_Code>34070</P_A_Dealer_Code>

  <Sub_dealer_Code>PI</Sub_dealer_Code>

  <Country>AUS</Country>

  </DETAIL>

<DETAIL>

  <EMP_ID>002272309</EMP_ID>

  <First_Name></First_Name>

  <Last_Name>高峰                                                                                    2822</Last_Name>

  <P_A_Dealer_Code>0LC</P_A_Dealer_Code>

  <Sub_dealer_Code>CHN</Sub_dealer_Code>

  </DETAIL>

Thanks,

Pavan T

[former_member186851 · Accepted solution]

Hello Pavan,

Try with the below encodings

ISO-2022-CN and ISO-2022-CN-EXT

and   高峰 is last name value?

[former_member200386 · Accepted solution]

Hi Raghu,

Thnaks for the quick help, ISO-2022-CN  is working for me, Now the problem is i am able to convert the English and Chinese characters correctly. In my source file i am getting THAI, VIetnam chracaters also , Is there any way , We can add multiple encoding types in comm channel level?

Thanks,

Pavan T

[former_member186851 · Accepted solution]

Hello Pavan,

Try "iso-8859-1" endcoding and check if its working.

[former_member200386]

Hi Raghu,

Thanks for the quick help. I will try the java mapping and let you know the result. I am closing the thread.

[former_member186851]

Sure Pavan..Glad to hear.

[former_member200386]

Hi Raghu,

I tried ""iso-8859-1" "  English characters are coming correct , But all Chinese, Vietnam & Thai characters are coming as junk. Is there any way to fix this issue.

[former_member186851]

Hello Pavan,

I doubt such an encoding is available.

Check the below link might be helpful