Showing Japanese text from DB in English locale
Posted: Sun 11 Sep 2005 20:12
Hi,
Our database is Oracle 9.2.0.4 installed on Sun Solaris. Database character set is UTF8.
The database is accessed from a Delphi 7 application using ODAC components 5.50.0.16 (Net option).
I have a report wich contains data from the database fetched using TOraStoredProc component. The data contains Japanses text.
The problem is that when I run the application in English locale, I see question marks instead the Japanese text. But when I am in Japanese locale, tha Japanese data is shown properly. Why?
I tried to change such TOraSession properties as UseUnicode, Charset, CharLengs; tried to change TStringField to TWideStringField etc.
Never mind which values I set to different properties, I always see proper Japanese text in Japanese locale and I always see question marks in English locale.
The data is shown in DB Grid. I tried both TCRDBGrid and TTntDBGrid - the same result. The grid font is MS UI Gothic (SHIFT_JIS character set).
What should I do in order to see correct Japanese text in English locale as well?
Thanks,
Yevgeny
Our database is Oracle 9.2.0.4 installed on Sun Solaris. Database character set is UTF8.
The database is accessed from a Delphi 7 application using ODAC components 5.50.0.16 (Net option).
I have a report wich contains data from the database fetched using TOraStoredProc component. The data contains Japanses text.
The problem is that when I run the application in English locale, I see question marks instead the Japanese text. But when I am in Japanese locale, tha Japanese data is shown properly. Why?
I tried to change such TOraSession properties as UseUnicode, Charset, CharLengs; tried to change TStringField to TWideStringField etc.
Never mind which values I set to different properties, I always see proper Japanese text in Japanese locale and I always see question marks in English locale.
The data is shown in DB Grid. I tried both TCRDBGrid and TTntDBGrid - the same result. The grid font is MS UI Gothic (SHIFT_JIS character set).
What should I do in order to see correct Japanese text in English locale as well?
Thanks,
Yevgeny