Devart Forums

Posted: **Tue 17 Dec 2013 08:37**

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.

Posted: **Tue 17 Dec 2013 09:38**

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;

Posted: **Tue 17 Dec 2013 10:47**

Thanks you very much.
The problem has been solved.

Posted: **Tue 17 Dec 2013 11:18**

Hello,

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

Devart Forums

Turkish char problem in TOraQuery sql text

Turkish char problem in TOraQuery sql text

Re: Turkish char problem in TOraQuery sql text

Re: Turkish char problem in TOraQuery sql text

Re: Turkish char problem in TOraQuery sql text