Oracle nchar cx_oracle

Nls_characterset = zht16mswin950

Nls_nchar_characterset = al16utf16

 

Select, insert nchar should use N 'hangzhou'

Select * From factest where fac_uname = n' Liu Ke '"

Insert into factest values ('20140901', '20160901', n'hangzhou ')

9i has a problem with using N 'shanghai', but there is no problem with over 10 Gbit/s.

 

 

 

In python, the non-Unicode version of cx_oracle Security indicates that nchar encoding is normal.

 

In python, The cx_oracle Security Unicode version nchar encoding bit is not normal.

"Liu Ke" in data statistics"

Will be labeled as "Medical Science"

 

Nls_lang =. utf8

The nls_lang on the client end must be set to utf8. Otherwise, the problem may occur.

Ora_nchar_literal_replace = true

 

 

Server:

Database Character Set: zht16mswin950

Database country character set: al16utf16

Client:

Nls_lang: al32utf8

Environment variable:Ora_nchar_literal_replace = true