I've some data stored in Japanese language in SQL Server 2005 database using nvarchar datatype.
When I execute store procedure in SQL Server, it's showing japanese character properly in SQL server. However, when I'm trying to display data in crystal report 8.5, it's showing ????? character.
I've tried to change font to 'Arial Unicode MS (Japanese)', MS Gothic, MS UI Gothic, MS Mincho (Japanese) as per the search result available in google. But not had any luck. Can anyone please help me out for this?
Software/Hardware used: Crystal Report 8.5, Sql server 2005, VB 6