[Oracle Collation] ORA-12705 (character set issues)

[Oracle Collation] ORA-12705 (character set issues)

?

. years 5 Month One Day

18:11

[Oracle collation ]ora-12705 ( Character Set issues )

Description: This content is work to use to the knowledge point collation, comes from the work and the network. ?

code in Oracle9 the test.

?

Different environments

DB Server same

AP Server same

AP Server on the DOTNET the same version--all . NET 3.5sp1

Building the same environment

The client is not the same, my computer is loaded with 10.2.0 . the AP server is 9.2.0

Test again

appear ORA-12705 Error

about the ORA-12705

The first kind of explanation

ORA-12705 Language Set Error

in the regedit of the \hkey_local_machine\software\oracle found under Nls_lang The machine code can be deleted Work

appear ORA-12705 error message, the reason is Nls_lang in the regedit The machine code value is NA

The code for the language, I installed it on my own computer. Oracle Client and then removed from the legacy.

so as long as the regedit of the \hkey_local_machine\software\oracle found under Nls_lang The machine code can be deleted Work

The second explanation

add an item to the environment variable: Nls_lang, values: simplified Chinese_china. ZHS16GBK

100% to solve your problem

The third explanation

Oracle Instant Client ORA-12705 Error

question : use oracle Instant Client appears ora-12705:cannot access NLS data files or invalid environment specified error.

if it is windows platform, registration table \hkey_local_machine\software\oracle find key nls_lang, This key is from oracle Standard client Installation creation NA ora-12705 error. The workaround is to rename the nls_lang

Linux If the environment variable Nls_lang value is NA causes a ORA-12705 Error, The workaround is to delete this variable , as in /home/oracle1/.profile

Export nls_lang= "Simplified_china. ZHS16GBK "

to comment out .

Find out the above phenomenon

Modify Nls_lang

instead American_america. Zht16big5, such as.

Oracle 9i setting

Oracle 10g setting

Learning materials

1? http://space.itpub.net/8475224/viewspace-692675

2? Http://blog.chinabyte.com/a/500815.html

One's life should be spent like this: when he looks back on the past, not because of wasting time and remorse, nor because of mediocrity and shame.

?

from < http://www.cnblogs.com/htht66/archive/2012/01/29/2330991.html >

?

was created using Microsoft OneNote 2013.

Null

[Oracle Collation] ORA-12705 (character set issues)