sql*plus中文乱码

原创

Liujun_Deng 2022-11-03 20:11:28 博主文章分类：Oracle ©著作权

文章标签 sql*plus中文乱码 NLS_LANG AMERICAN_AMERICA.UTF 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者Liujun_Deng的原创作品，请联系作者获取转载授权，否则将追究法律责任

问题描述：sql*plus中文乱码.
系统：oel 7.9
数据库：oracle 19.12
SQL> desc yb_ghij_mdhs;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ??                                                 DATE
 ??ID                                               VARCHAR2(36)
 ??                                                 VARCHAR2(36)
 ??CLOB                                             CLOB
 ??CLOB                                             CLOB
 ID                                        NOT NULL VARCHAR2(36)
 CZIP                                               VARCHAR2(36)
 CZY                                                VARCHAR2(36)
 CZDZ                                               VARCHAR2(36)
 ??                                                 VARCHAR2(4000)
 FHSJ                                               DATE
解决过程：
查数据库字符集.
SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
[oracle@xd1dbadm01 ~]$ echo $NLS_LANG

[oracle@xd1dbadm01 ~]$ export NLS_LANG=AMERICAN_AMERICA.UTF8
[oracle@xd1dbadm01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 3 12:56:24 2022
Version 19.12.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0

SQL> desc yb_ghij_mdhs;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 日期                                               DATE
 号码ID                                             VARCHAR2(36)
 型号                                               VARCHAR2(36)
 传输CLOB                                           CLOB
 接收CLOB                                           CLOB
 ID                                        NOT NULL VARCHAR2(36)
 CZIP                                               VARCHAR2(36)
 CZY                                                VARCHAR2(36)
 CZDZ                                               VARCHAR2(36)
 结果                                               VARCHAR2(4000)
 FHZJ                                               DATE
说明：如上所示，sql*plus中文正常显示.