Skip to Content
-2

mail with Excel attachement containing japanese characters

Hi Experts,

I am sending PR info as mail with Excel file as attachment. The Excel file contains Japanese characters and while viewing the data, the characters do not appear as we see in the system. I am using HR_KR_STRING_TO_XSTRING to convert from text to hexadecimal using code page 4110 and then SCMS_XSTRING_TO_BINARY to convert to binary and sending the data as an Excel attachment in the mail.

Thanks and Regards,

Aditya

Add comment
10|10000 characters needed characters exceeded

  • PR? (purchase requisition?)

    code page 4110? (not everybody knows that it's UTF-8)

    Please provide a screen capture and the original correct text ("The Excel file contains Japanese characters and while viewing the data, the characters do not appear as we see in the system")

  • Hi ,

    Thanks for the quick reply.

    Please find attached the screenshot. Yes i have used 4110 as it has universal character set support. Does it make a difference ?

    Regards,

    Aditya

    japanese.png (3.4 kB)
  • It "makes a difference" by precisely describing the issue to the community, that's all I meant :)

    If your Excel file is a CSV format, then you should use UTF-16LE (code page 4103) with a BOM. It will be compatible with all Excel versions. Anyway, maybe it won't solve your issue, if you convert incorrectly the characters.

    Where are the Japanese characters in SAP? It's all Junk characters. How can we know where the issue is?

    Please attach the corresponding piece of code.

  • Get RSS Feed

0 Answers