Showing Japanese text from DB in English locale

yevgeny · Post by **yevgeny** » 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

Paul · Post by **Paul** » Mon 12 Sep 2005 08:21

Please check it with the last ODAC build. We fixed similar problem with eastern languages there.
Please compare results of TField.AsString byte to byte with English and Japanese locale. You can determine if it is problem of ODAC of visual components.
Do you have such result with OCI connection? Please write us example of Japanese characters, that you want to add.