设置SecureCRT 能显示中文

最新推荐文章于 2024-07-22 16:19:33 发布

huangliang0703

最新推荐文章于 2024-07-22 16:19:33 发布

阅读量3.5k

点赞数 1

分类专栏： sql*plus

本文链接：https://blog.csdn.net/huangliang0703/article/details/50205549

版权

sql*plus 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

1、数据库中有一张表：灵通_TRADE_ARCHIVE，但是中文在sqlplus 里面显示乱码

12:46:00 sys@MOUNTAIN>select owner, table_name from dba_tables where table_name like '%TRADE_ARCHIVE';

OWNER                          TABLE_NAME
------------------------------ ------------------------------
BI                             ??_TRADE_ARCHIVE

2、查看数据库中的字符集：

 12:46:40 sys@MOUNTAIN>select * from nls_database_parameters;

PARAMETER                      VALUE
------------------------------ --------------------------------------------------------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               ZHS16GBK
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION              11.2.0.3.0

3、配置NLS_LANG，与数据库中的相对应

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

4、将secureCRT 的字符集配置为默认

5、再次查看，显示正常

12:51:57 sys@MOUNTAIN>select owner, table_name from dba_tables where table_name like '%TRADE_ARCHIVE';

OWNER                          TABLE_NAME
------------------------------ ------------------------------
BI                             灵通_TRADE_ARCHIVE