centos操作系统sqlplus中文显示问号

原创

已于 2022-11-03 10:22:05 修改 · 615 阅读

标签

#linux #centos #oracle

收录于

于 2022-10-30 19:46:37 首次发布

本文介绍了在CentOS操作系统中，当使用sqlplus时遇到中文显示为问号的问题及其解决方案。通过设置环境变量NLS_LANG为'SIMPLIFIED CHINESE_CHINA.AL32UTF8'，然后在.bash_profile文件中添加该设置并重新加载配置，成功解决了SQL*Plus显示中文字符的问题。

[oracle@192 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Oct 30 19:14:35 2022
Version 19.3.0.0.0

???:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8

SQL> exit
? Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0 ??
[oracle@192 ~]$ vi ~/.bash_profile
添加下面语句到最后
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
[oracle@192 ~]$ cat ~/.bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$