How to solve ORACLE garbled characters

When using sqlplus to connect to the oracle database, there are always ???? The main reason is that the language settings of the server and the client are different.

In the Japanese environment, the server side is set to JA16SJIS, and the above phenomenon occurs when the client is not set.

Set the environment variable

[Csh]

Setenv NLS_LANG American_Japan.JA16SJIS

[Bash]

Export NLS_LANG = American_Japan.JA16SJIS

The corresponding Chinese code can be found in the list of East Asian languages in the previous article.

Oracle 10g

[Csh]

Setenv RA_NLS10 $ ORACLE_HOME/nls/data

[Bash]

Export ORA_NLS10 = $ ORACLE_HOME/nls/data

Oracle 9i

[Csh]

Setenv ORA_NLS33 $ ORACLE_HOME/ocommon/nls/data

[Bash]

Export ORA_NLS33 = $ ORACLE_HOME/ocommon/nls/data