Oracle 设置客户端字符集

Setting the NLS_LANG Environment Variable for Oracle Databases

SELECT NLS_LANGUAGE || '_' || NLS_TERRITORY || '.' ||
       NLS_NCHAR_CHARACTERSET AS NLS_LANG
  FROM V$NLS_PARAMETERS
PIVOT(MAX(VALUE)
   FOR PARAMETER IN('NLS_LANGUAGE' AS NLS_LANGUAGE,
                    'NLS_TERRITORY' AS NLS_TERRITORY,
                    'NLS_NCHAR_CHARACTERSET' AS NLS_NCHAR_CHARACTERSET));
变量名:LANG

变量值:zh_CN.GBK

变量名:NLS_LANG

变量值:SIMPLIFIED CHINESE_CHINA.ZHS16GBK

https://docs.oracle.com/cd/E12102_01/books/AnyInstAdm784/AnyInstAdmPreInstall18.html

posted @ 2022-04-02 21:40  ChasingDreams  阅读(141)  评论(0编辑  收藏  举报