Page 1 of 1

OCIUnicode / UnicodeEnvironment / UseUnicode => What's the difference?

Posted: Thu 29 Jan 2015 13:46
by JamesInform
Hi,

I have been rushing through your forum and documentation but could not get an answer on that.

Just for your information: I am using Delphi XE7 and connect to an Oracle 12c configured using unicode nsl charset ALU32UTF8 (varchar2 fields with Char as the length semantic).

So please explain in detail how to use these three unicode setting! :idea:

1. OCIUnicode => Global variable which can be set in source code only.
2. UseUnicode which is an option in the TOraSession.
3. UnicodeEnvirnment which also is an option in the TOraSession.

UnicodeEnvironment isn't even mentioned in your documentation center. :shock:

Re: OCIUnicode / UnicodeEnvironment / UseUnicode => What's the difference?

Posted: Fri 30 Jan 2015 09:48
by AlexP
Hello,

OCIUnicode is an obsolete variable and it was kept for backward compatibility. In the new versions, you should use the UseUnicode and UnicodeEnvironment options.

If the UnicodeEnvirnment option is set to True, the query text will be passed to the server in the UniCode encoding, not depending on the client charset.

Re: OCIUnicode / UnicodeEnvironment / UseUnicode => What's the difference?

Posted: Fri 30 Jan 2015 14:01
by JamesInform
Thanks Alex.

That helped a lot! :!:

Re: OCIUnicode / UnicodeEnvironment / UseUnicode => What's the difference?

Posted: Tue 03 Feb 2015 07:42
by AlexP
You are welcome. Feel free to contact us if you have any further questions.