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

Contact Us

Contact us

181-3619-1160

Online consultation: QQ交谈

E-mail: [email protected]

Working hours: Monday to Friday, 9:00-17:30, holidays off

Follow wechat
Scan wechat and follow us

Scan wechat and follow us

Follow Weibo
Back to top
首页
微信
电话
搜索