The solution to the garbled Chinese characters after Oracle executes the SQL script under the Linux system

The solution to the garbled Chinese characters after Oracle executes the SQL script under the Linux system
the
First confirm the character set of Oracle, and execute the statement after logging in to Oracle with sqlplus:
the
[sql]
select userenv('language') from dual;
Return value example: AMERICAN_AMERICA.ZHS16GBK
Modify the NLS_LANG environment variable of Linux, and modify the Linux user specified by Oracle
the
“.base_profile” file, add as follows: www.2cto.com
[sql]
export NLS_LANG=”AMERICAN_AMERICA.ZHS16GBK”
Use the Linux command “source ~/.base_profile” or restart to make the environment variable settings take effect;
The Linux command to view environment variables is “echo $NLS_LANG”.
the
the
Author zzs0829