How to set OCI Unicode environment use in 9.2.5?

[MarkF]

It looks like the OraCall.OCIUnicode setting is no longer used (there's a note in the code about it being deprecated.) What's the new way to turn OCIUnicode on?

-Mark Ford
Benthic Software

[AlexP]

Hello,

This option is obsolete and left for backward compatibility. Now you should use the TOraSession.Options.UnicodeEnvironment property.

[MarkF]

That was the first thing I tried but it doesn't appear to be hooked up. You can test it by running a query that has a unicode literal in it or by just putting a breakpoint in procedure TOCIEnvironment.Init and observing that the UnicodeEnv variable is never True (in my testing.)

-Mark
Benthic Software

[AlexP]

Hello,

Thank you for the information. We have reproduced and fixed the problem. This fix will be included to the next ODAC version. For the time being, to solve the problem, you should make the following changes in the TOraSession.GetOCIConnection method, the Ora.pas module:

After the line

Code: Select all

ConnectionParameters.UseUnicode := Options.UseUnicode;

add

Code: Select all

ConnectionParameters.UnicodeEnvironment := Options.UnicodeEnvironment;

And after

Code: Select all

Result.SetProp(prUseUnicode, Options.UseUnicode);

add

Code: Select all

Result.SetProp(prUnicodeEnvironment, Options.UnicodeEnvironment);

[MarkF]

Thank you, that fixed the issue.

-Mark
Benthic Software

[AlexP]

Hello,

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

[RoniLev]

Hi there
I have the same problem.
I this problem solved in the last version on download page?

Oracle Data Access Components Standard 9.2.7 25-Feb-2014

Regards
Roni

[AlexP]

This problem is already fixed. Please download the latest ODAC version 9.2.7

[angmar]

I have upgraded odac to 9.2.7 but this problem is going on for my project.
I could use turkish chars in sql text like "select 'öçşiğü' from dual" without problem.
After I passed to 9.2.5, I could not use these chars in sql correctly.
My code uncludes these lines:

Code: Select all

    myTOraSession.Options.UseUnicode := True;
    myTOraSession.Options.Charset := 'UTF8'
    OCIUnicode := True;

Also when I enable unicodeenvironment, I can not connect to oracle. I get a kind of chinese error
How I can I solve this ?

[AlexP]

The OCIUnicode variable must be set before creating a TOraSession instance.

[angmar]

OCIUnicode := True;
this code does not work whereever I write, I could not see turkish chars in sql in grid.
I am not glad for 9.2.7 version.
Unicodenvironment = true; does not work too.
It was working in previous versions and new solutions do not solve my problem.
Where am I wrong ?
when I downgrade to 9.1.4 and my problem is solved

[AlexP]

Please send me results of the following queries:

Code: Select all

SELECT USERENV ('language') from dual; 

SELECT * FROM V$NLS_PARAMETERS;