unicode SQL Text support

[tkdsong]

Hello.

How I can send query with unicode SQL Text.
For example:

OraQuery1.SQL.Text='
SELECT (unicode text - '한글') FROM table WHERE "compname"=:compname;

Where SELECT () is widestring.

If it`s not possible, what tricks I can use??

and, you said "ODAC does not support using Unicode strings in the SQL property of ODAC components."
Would you this support is not plain?

[Plash]

The SQL property of TOraQuery should contain text in the character set that is set in the NLS_LANG parameter from the Windows registry or environment variable.
If the character set in the NLS_LANG parameter is the same as your Windows non-Unicode character set, and '한글' characters are present in the Windows non-Unicode character set, you can use these characters in the SQL property.

We'll consider possibility to support Unicode in the SQL property in either of the next ODAC versions.

[BenSteiner]

Hello Devart Team,

will you implement the unicode support for the sql.text property or not?
I still tried the version 8 of odac and it is not working there.

Sincerely
Benjamin Steiner

[AlexP]

Hello,

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

Code: Select all

uses ..., OraCall;
....
  OCIUnicode := true;
  OraSession1.Connect;
  OraQuery1.SQL.Text := 'SELECT  ''한글'' FROM DUAl';
  OraQuery1.Open;

[BenSteiner]

Hello,

i will try this.

Thank you for your Help.

[BenSteiner]

It works

[AlexP]

hello,

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