Japanese Character Issue

[Former Member]

We are facing an issue with crystal reports, the Japanese data is displayed in crystal as some unknown garbage values.

While referencing at the backend the data seems fine, it’s in crystal that this values get distorted. As a work around we  tried changing the fonts and changing the preferred viewing local of the report to Japanese but the issue still persists.

The crystal version we are using is SAP BO Crystal Reports 2013 SP 3 Patch 4.

Could you please provide us any insight on the same and guide us if we are missing on anything.

[abhilash_kumar · Accepted solution]

Hi Prasanna,

What database are you connecting to?

If it's Oracle, you need to make sure that the 'NLS Lang' setting (registry) on the machine matches with that of the Server's.

P.S: Try setting the text interpretation to 'HTML' - I've seen that sometimes it resolves such issues.

-Abhilash

[Former Member · Accepted solution]

Hello Abhilash,

I am connecting to Oracle server through OLEDB(ADO). I tried connecting through Oracle server but could not see the required stored procedures, so connecting via OLEDB..

I have tried using HTML interpretation, no luck there.

We have tried the NLS Lang setting as well.

Thanks,

Prasanna

[abhilash_kumar · Accepted solution]

After connecting to the database via 'Oracle Server', right-click the connection > options > type in the Stored Procedure name > refresh the connection > Do you see the SP?

And when you say 'weve tried the NLS Lang setting', do you mean the setting on this machine and the oracle server match?

Do you see the Japanese characters when the query is run via Toad/SQL Developer on this machine?

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I checked for the stored procedure, but could not see it. Is connecting to the database through OLEDB (and not Oracle server) one of the reasons for Japanese characters issue?

We have checked the NLS Lang settings for this machine. We have raised the ticked to check the same with server machine.
Toad shows the correct Japanese values.

Thanks,

Prasanna

[Former Member]

Hi Prasanna,

Please check this document:
How to use different font faces in a diacritical cases in SAP Crystal Reports

Regards,
István