Is affected by the value of the character set of NLS_LANG?

[UmeTomo]

Hello.

I am Japanses.
I want to use the character of surrogate pairs of unicode.
For example, U+20BB7.

I was AL32UTF8 database character set of Oracle.

I'm doing a test of the DOA, but it is not yet worked out.
So I want you to tell me.
The value of the Character Set of the NLS_LANG environment variable, will affect the DOA?
Its value, will be ignored by DOA?

Win7(x86) SP1
Delphi XE2 + Update2
DOA Ver 4.1.3.5

Oracle 11g (11.2.0.4)
Database CharSet AL32UTF8

InstantClient use
NLS_LANG = Japanese_Japan

Best regards.

 

[Marco Kalter]

If the data is Unicode then the NLS_LANG character set will not affect Direct Oracle Access. The data will be fetched as Unicode strings.

 

[UmeTomo]

The answer you very much.
I understood. :grin:

I try to continue to test.
By the way, DOA Do you support officially characters surrogate pair?

Best regards.

 

[Marco Kalter]

I think it's transparent to Direct Oracle Access. The question is whether Oracle and RAD Studio support it.

 

[UmeTomo]

I was sick from last Friday, reply has become slow. sorry.

The answer you very much.

All right.
For Oracle DB, using SQLDeveloper, surrogate pair handling is confirmed.
For Delphi, I was confirmed that no problem screen display of a VCL component. (This is, NG in D2007)

The operation of including cooperation with DB, it is not been able to test yet.

Thank you.

Best regards.