Turkish char problem in TOraQuery sql text

[angmar]

Hi,
I develope software by using Delphi XE3 and ODAC 9.1.4.
I use a sql string like "select 'Yüksek' from dual" in TOraQuery dataset.
Unfortunately dataset gives me the result with char problem for "ü" letter. It is seen as question mark. However, I don't have any problem with datas that come from database. I mean if 'Yüksek' word is a data in database, it is seen correct.
I want to use all the chars in my project, not only Turkish chars and I set UseUnicode property of TOraSession.
Do you have any idea ?
Thanks.

[AlexP]

Hello,

To make such query work, you should set the UseUnicode option and OCIUnicode (declared in OraCall) to True

Code: Select all

SELECT ALL
uses ..., OraCall;
....
OCIUnicode := true;
OraSession1.Options.UseUnicode := True;
OraSession1.Connect;

[angmar]

Thanks you very much.
The problem has been solved.

[AlexP]

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.