mail with Excel attachement containing japanese characters

[kjyothiraditya]

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

[kiran_k8]

Aditya,

Just a wild guess.

Did you checked if your PC has got JAPANESE fonts ( you can check in CONTROL PANEL).

Eager to know what could be the possible reason. Do update this thread once you find the right solution.

K.Kiran.

[Sandra_Rossi]

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")

[kjyothiraditya]

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

[Sandra_Rossi]

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.