ORACLE无法正确显示中文字符，急，急

Question

我在WIN2000平台和WINNT4.0（PACK4）下都试过，都不行，请问你是怎么设置的。谢谢！

Answer 1

我是NT4,我只是改了machine>software>oracle>home1下的nls_lang:American_America.zhs16cgb231280
其它都没改,还是simle....

Answer 2

如果你的机器安装BDE,试着调整BDE的环境设置

Answer 3

呵呵，你肯定是将oracle跟oem装到两个oracle_home下，然后只改了oracle的nls_lang，没改oem的:)

Answer 4

用sql登陆数据库,执行下列语句select * from v$nls_parameters 查询语种.客户端必须与服务器端语种一致,插入的数据才不是乱码.否则需要更改客户端的注册表语种信息

Answer 5

to blueSQu:
我是设置过了BDE，但却不知道怎么设置才是对的。
to cxgtommy:
你前面说对了，可后面我改了也没用。
to leader2000:
我试试。在此先谢谢各位。送上迟到的新年祝福：新年快乐！

Answer 6

to leader2000:
现将执行结果显示如下：
{select * from v$nls_parameters;
未改注册表则执行结果：PARAMETER                                                        VALUE
---------------------------------------------------------------------------------------------------------------------------- 
NLS_LANGUAGE                                                     AMERICAN
NLS_TERRITORY                                                    AMERICA
NLS_CURRENCY                                                     $
NLS_ISO_CURRENCY                                                 AMERICA
NLS_NUMERIC_CHARACTERS                                           .,
NLS_CALENDAR                                                     GREGORIAN
NLS_DATE_FORMAT                                                  DD-MON-YY
NLS_DATE_LANGUAGE                                                AMERICAN
NLS_CHARACTERSET                                                 ZHS16GBK
NLS_SORT                                                         BINARY
NLS_TIME_FORMAT                                                  HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT                                             DD-MON-YY HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT                                               HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT                                          DD-MON-YY HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY                                                $
NLS_NCHAR_CHARACTERSET                                           ZHS16GBK
NLS_COMP
改了注册表则执行结果：
PARAMETER                                                        VALUE
--------------------------------------------------------------------------------------------------------------------------
NLS_LANGUAGE                                                     SIMPLIFIED CHINESE
NLS_TERRITORY         CHINA
NLS_CURRENCY                                                     RMB
NLS_ISO_CURRENCY                                                 CHINA
NLS_NUMERIC_CHARACTERS                                           .,
NLS_CALENDAR                                                     GREGORIAN
NLS_DATE_FORMAT                                                  DD-MON-YY
NLS_DATE_LANGUAGE                                                SIMPLIFIED CHINESE
NLS_CHARACTERSET                                                 ZHS16GBK
NLS_SORT                                                         BINARY
NLS_TIME_FORMAT                                                  HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT                                             DD-MON-YY HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT                                               HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT                                          DD-MON-YY HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY                                                RMB
NLS_NCHAR_CHARACTERSET                                           ZHS16GBK
NLS_COMP
}这里改注册表即改注册表ORACLE目录下的NLS—LANG键值。

Answer 7

{select * from sys.props$;
如果改注册表则执行结果：
NAME                               VALUE$                                          COMMENT$
----------------------------------------------------------------------------------------------------------------------
DICT.BASE                          2                                               dictionary base tables version #
NLS_LANGUAGE                       AMERICAN                                        Language
NLS_TERRITORY                      AMERICA                                         Territory
NLS_CURRENCY                       $                                               Local currency
NLS_ISO_CURRENCY                   AMERICA                                         ISO currency
NLS_NUMERIC_CHARACTERS             .,                                              Numeric characters
NLS_CHARACTERSET                   ZHS16GBK                                        Character set
NLS_CALENDAR                       GREGORIAN                                       Calendar system
NLS_DATE_FORMAT                    DD-MON-YY                                       Date format
NLS_DATE_LANGUAGE                  AMERICAN                                        Date language
NLS_SORT                           BINARY                                          Linguistic definition
NLS_TIME_FORMAT                    HH.MI.SSXFF AM                                  Time format
NLS_TIMESTAMP_FORMAT               DD-MON-YY HH.MI.SSXFF AM                        Time stamp format
NLS_TIME_TZ_FORMAT                 HH.MI.SSXFF AM TZH:TZM                          Time with timezone format
NLS_TIMESTAMP_TZ_FORMAT            DD-MON-YY HH.MI.SSXFF AM TZH:TZM                Timestamp with timezone format
NLS_DUAL_CURRENCY                  $                                               Dual currency symbol
NLS_COMP
NLS comparison
NLS_NCHAR_CHARACTERSET             ZHS16GBK                                        NCHAR Character set
NLS_RDBMS_VERSION                  8.1.5.0.0                                       RDBMS version for NLS parameters
GLOBAL_DB_NAME                     ORACLE                                          Global database name
EXPORT_VIEWS_VERSION               7                                               Export views revision #如果不改注册表则结果：
NAME                           VALUE$                                          COMMENT$
------------------------------------------------------------------------------------------------------------------------ 
DICT.BASE                      2                                               dictionary base tables version #
NLS_LANGUAGE                   AMERICAN                                        Language
NLS_TERRITORY                  AMERICA                                         Territory
NLS_CURRENCY                   $                                               Local currency
NLS_ISO_CURRENCY               AMERICA                                         ISO currency
NLS_NUMERIC_CHARACTERS         .,                                              Numeric characters
NLS_CHARACTERSET               ZHS16GBK                                        Character set
NLS_CALENDAR                   GREGORIAN                                       Calendar system
NLS_DATE_FORMAT                DD-MON-YY                                       Date format
NLS_DATE_LANGUAGE              AMERICAN                                        Date language
NLS_SORT                       BINARY                                          Linguistic definition
NLS_TIME_FORMAT                HH.MI.SSXFF AM                                  Time format
NLS_TIMESTAMP_FORMAT           DD-MON-YY HH.MI.SSXFF AM                        Time stamp format
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZH:TZM                          Time with timezone format
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-YY HH.MI.SSXFF AM TZH:TZM                Timestamp with timezone format
NLS_DUAL_CURRENCY              $                                               Dual currency symbol
NLS_COMP                                                                                                                     NLS comparison
NLS_NCHAR_CHARACTERSET         ZHS16GBK                                        NCHAR Character set
NLS_RDBMS_VERSION              8.1.5.0.0                                       RDBMS version for NLS parameters
GLOBAL_DB_NAME                 ORACLE                                          Global database name
EXPORT_VIEWS_VERSION           7                                               Export views revision #21 rows selected.
}这里改注册表即改注册表ORACLE目录下的NLS—LANG键值。

Answer 8

对上面的更正，那个NLS comparison应该另起一行，而且和NLS_COMP一样没有后两项。

Answer 9

这个问题在ORACLE中应该比较常见，请各位有此经历的出手相助一把。

Answer 10

我也遇到过字符集问题，不过我只把客户端注册表的NLS_LANGUAGE设为和服务器端一致就可以了。如果你的服务器端和客户端的ORACLE版本一样，那就应该没什么问题。

Answer 11

把字符集改为US7ASCII，客户端也是。另外，对字符集更改后，数据库的数据要作更新，否则显示依然是乱码。