• 查看当前Oracle字符集
select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------------------------------------------------------
AMERICAN_AMERICA.AL32UTF8
  • 查询当前终端的NLS_LANG环境变量
echo $NLS_LANG

NLS_LANG为空
  • 设置NLS_LANG环境变量的值为AMERICAN_AMERICA.AL32UTF8
export  NLS_LANG=AMERICAN_AMERICA.AL32UTF8
05-19 12:12