oracle sql字符乱码,解决sqlplus字符集乱码的问题：

解决sqlplus字符集乱码的问题：

现象：

[oracle@racdb ~]$ locale

LANG=C

LC_CTYPE="C"

LC_NUMERIC="C"

LC_TIME="C"

LC_COLLATE="C"

LC_MONETARY="C"

LC_MESSAGES="C"

LC_PAPER="C"

LC_NAME="C"

LC_ADDRESS="C"

LC_TELEPHONE="C"

LC_MEASUREMENT="C"

LC_IDENTIFICATION="C"

LC_ALL=

数据库的字符：

SQL> select * from V$NLS_PARAMETERS;

PARAMETER

----------------------------------------------------------------

VALUE

----------------------------------------------------------------

NLS_LANGUAGE

SIMPLIFIED CHINESE

NLS_TERRITORY

CHINA

NLS_CURRENCY

￥

PARAMETER

----------------------------------------------------------------

VALUE

----------------------------------------------------------------

NLS_ISO_CURRENCY

CHINA

NLS_NUMERIC_CHARACTERS

.,

NLS_CALENDAR

GREGORIAN

PARAMETER

----------------------------------------------------------------

VALUE

----------------------------------------------------------------

NLS_DATE_FORMAT

DD-MON-YYYY HH24:MI:SS

NLS_DATE_LANGUAGE

SIMPLIFIED CHINESE

NLS_CHARACTERSET

ZHS16GBK

PARAMETER

----------------------------------------------------------------

VALUE

----------------------------------------------------------------

NLS_SORT

BINARY

NLS_TIME_FORMAT

HH.MI.SSXFF AM

NLS_TIMESTAMP_FORMAT

DD-MON-RR HH.MI.SSXFF AM

PARAMETER

----------------------------------------------------------------

VALUE

----------------------------------------------------------------

NLS_TIME_TZ_FORMAT

HH.MI.SSXFF AM TZR

NLS_TIMESTAMP_TZ_FORMAT

DD-MON-RR HH.MI.SSXFF AM TZR

NLS_DUAL_CURRENCY

￥

PARAMETER

----------------------------------------------------------------

VALUE

----------------------------------------------------------------

NLS_NCHAR_CHARACTERSET

AL16UTF16

NLS_COMP

BINARY

NLS_LENGTH_SEMANTICS

BYTE

PARAMETER

----------------------------------------------------------------

VALUE

----------------------------------------------------------------

NLS_NCHAR_CONV_EXCP

FALSE

已选择19行。

数据库的字符为：

NLS_CHARACTERSET

ZHS16GBK

用sqlplus进去以后，出象如下的乱码：

[oracle@racdb ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on ??Υ 12? 17 15:33:34 2010

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

l???:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,

Data Mining, Oracle Database Vault and Real Application Testing options

为了解决这一问题：

要在操作系统的.bash_profile文件里加入如下的环境变量：

export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

再用sqlplus进入后得如下：

[oracle@racdb ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期五 12月 17 15:34:18 2010

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

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,

Data Mining, Oracle Database Vault and Real Application Testing options

问题解决。