Oracle client Character Set settings

Programmers often need to connect to the database to talk about the oracle database client and server Character Set consistency problem, which can solve Chinese garbled characters, other character garbled problems mainly refer to in sqlplus, I do not test other similar toad/plsql statements, but I feel that as long as the character set is consistent, there will be no gibberish issues. My testing environment: win7 64bit, oracle11g 32bit client, oracle Server: oracle 10.2.0.1.0; www.2cto.com 1. first method to view server Character Set: select userenv ('langue') from dual second method: select * from NLS_DATABASE_PARAMETERS assume that the server Character Set queried is AMERICAN_AMERICA.US7ASCII 2. the first method to set the client Character Set: regedit-> HKEY_LOCAL _ MACHINE-> SOFTWARE-> ORACLE-> key_javaslient11g_home1-> NLS_LANG: Back up the key value of NLS_LANG (to prevent errors) and then change it to AMERICAN_AMERICA.US7ASCII (consistent character set with the database) www.2cto.com is applicable in most cases. Method 2: Modify the environment variable my computer-> right-click-> properties-> advanced system-> advanced-> environment variable-> New User variable new user variable name: the value of the NLS_LANG variable is AMSERICAN_AMERICA.US7ASCII (consistent with the database query). It is suitable for multiple installations to delete the key-value pairs of oracle nodes in the registry. No tests are performed for those that have not deleted the registry, we recommend that you use the first method. If anyone can test it, we recommend sharing it. Author: yylp521