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

[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!

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.

[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.

[JamesInform]

Thanks Alex.

That helped a lot!

[AlexP]

You are welcome. Feel free to contact us if you have any further questions.