Oracle V$NLS_PARAMETER与NLS_DATABASE_PARAMETERS的区别

博客首页 » Oracle V$NLS_PARAMETER与NLS_DATABASE_PARAMETERS的区别

发布于 22 Jun 2014 15:21
标签 blog
在Oracle中,语言区域和字符集设置NLS是一个经常碰到的问题。在Oracle的数据字典和动态视图中,有如下的View。其中V$NLS_PARAMETER与NLS_DATABASE_PARAMETERS最为接近,本文讨论二者的差别。
v$nls_parameters
v$nls_valid_values
nls_database_parameters
nls_instance_parameters
nls_session_parameters

Oracle中提供了强大灵活的NLS的设置,依次是环境变量中的LANG(Linux)/注册表(Windows)> 环境变量NLS_LANG > 以及altser session set NLS_LANGUAGE=来设定的。

而设定的结果会反映到Oracle的动态视图中。

设定NLS的方法

eygle的这篇文章很好,只是无法转载
http://www.eygle.com/special/NLS_CHARACTER_SET_04.htm

wzy0623在他的专栏里有这篇文章,描述得也不错
http://blog.csdn.net/wzy0623/article/details/1683337

Oracle 客户端 NLS_LANG 的设置

1. NLS_LANG 参数组成
NLS_LANG参数由以下部分组成:
NLS_LANG=<Language>_<Territory>.<Clients Characterset>

NLS_LANG各部分含义如下:

LANGUAGE指定:
-Oracle消息使用的语言
-日期中月份和日显示

TERRITORY指定
-货币和数字格式
-地区和计算星期及日期的习惯

CHARACTERSET:
-控制客户端应用程序使用的字符集
通常设置或者等于客户端(如Windows)代码页
或者对于unicode应用设置为UTF8

在Windows上查看当前系统的代码页可以使用chcp命令:
E:/>chcp
活动的代码页: 936

代码页936也就是中文字符集 GBK,在Microsoft的官方站点上,我们可以遭到关于936代码页的具体编码规则,请参考以下链接:
http://www.microsoft.com/globaldev/reference/dbcs/936.htm

2. 查看 NLS_LANG 的方法
Windows使用:

echo %NLS_LANG%
如:
E:/>echo %NLS_LANG%
AMERICAN_AMERICA.ZHS16GBK

Unix使用:

env|grep NLS_LANG
如:
/opt/oracle>env|grep NLS_LANG
NLS_LANG=AMERICAN_CHINA.ZHS16GBK

Windows客户端设置,可以在注册表中更改NLS_LANG,具体键值位于:
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMExx/
xx指存在多个ORACLE_HOME时系统编号。

3. 查看数据库当前字符集参数设置
SELECT * FROM v$nls_parameters;

4. 查看数据库可用字符集参数设置
SELECT * FROM v$nls_valid_values;

5. 客户端 NLS_LANG 的设置方法
Windows:

  1. 常用中文字符集

set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

  1. 常用unicode字符集

set NLS_LANG=american_america.AL32UTF8
可以通过修改注册表键值永久设置
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMExx/NLS_LANG

Unix:

  1. 常用unicode字符集

export NLS_LANG=american_america.AL32UTF8

  1. 常用中文字符集

export NLS_LANG="Simplified Chinese_china".ZHS16GBK
可以编辑 bash_profile 文件进行永久设置
vi .bash_profile
NLS_LANG="Simplified Chinese_china".ZHS16GBK export NLS_LANG

  1. 使 bash_profile 设置生效

source .bash_profile

几个View的描述

关于这几个View,DataKW在他的Blog中有如下描述

v$nls_parameters和nls_database_parameters

http://blog.itpub.net/27573546/viewspace-762308

实际数据库是使用v$nls_parameters 中的设置

select * from v$nls_parameters;
select * from v$nls_valid_values;
select * from nls_database_parameters;
select * from nls_instance_parameters;
select * from nls_session_parameters;
  • 数据库服务器字符集select * from nls_database_parameters,其来源于props$,是表示数据库的字符集。
  • 客户端字符集环境select * from nls_instance_parameters,其来源于v$parameter,表示客户端的字符集的设置,可能是参数文件,环境变量或者是注册表会话字符集环境
  • select * from nls_session_parameters,其来源于v$nls_parameters,表示会话自己的设置,可能是会话的环境变量或者是alter session完成,如果会话没有特殊的设置,将与nls_instance_parameters一致。

客户端的字符集要求与服务器一致,才能正确显示数据库的非ascii字符。如果多个设置存在的时候,alter session>环境变量>注册表>参数文件字符集要求一致,但是语言设置却可以不同,语言设置建议用英文。如字符集是zhs16gbk,则nls_lang可以是american_america.zhs16gbk。

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 
Connected as btupayprod
 
SQL> set pages 1000
SQL> 
SQL> select * from v$nls_parameters;
 
PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_LANGUAGE                                                     SIMPLIFIED CHINESE
NLS_TERRITORY                                                    CHINA
NLS_CURRENCYNLS_ISO_CURRENCY                                                 CHINA
NLS_NUMERIC_CHARACTERS                                           .,
NLS_CALENDAR                                                     GREGORIAN
NLS_DATE_FORMAT                                                  DD-MON-RR
NLS_DATE_LANGUAGE                                                SIMPLIFIED CHINESE
NLS_CHARACTERSET                                                 UTF8
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_CURRENCYNLS_NCHAR_CHARACTERSET                                           UTF8
NLS_COMP                                                         BINARY
NLS_LENGTH_SEMANTICS                                             BYTE
NLS_NCHAR_CONV_EXCP                                              FALSE
 
19 rows selected
 
SQL> select * from nls_database_parameters;
 
PARAMETER                      VALUE
------------------------------ --------------------------------------------------------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               UTF8
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         UTF8
NLS_RDBMS_VERSION              10.2.0.4.0
 
20 rows selected
SQL> select * from nls_instance_parameters;
 
PARAMETER                                                                        VALUE
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
NLS_LANGUAGE                                                                     AMERICAN
NLS_TERRITORY                                                                    AMERICA
NLS_SORT                                                                         
NLS_DATE_LANGUAGE                                                                
NLS_DATE_FORMAT                                                                  
NLS_CURRENCY                                                                     
NLS_NUMERIC_CHARACTERS                                                           
NLS_ISO_CURRENCY                                                                 
NLS_CALENDAR                                                                     
NLS_TIME_FORMAT                                                                  
NLS_TIMESTAMP_FORMAT                                                             
NLS_TIME_TZ_FORMAT                                                               
NLS_TIMESTAMP_TZ_FORMAT                                                          
NLS_DUAL_CURRENCY                                                                
NLS_COMP                                                                         
NLS_LENGTH_SEMANTICS                                                             BYTE
NLS_NCHAR_CONV_EXCP                                                              FALSE
 
17 rows selected
SQL> select * from nls_session_parameters;
 
PARAMETER                                                                        VALUE
-------------------------------------------------------------------------------- --------------------------------------------------------------------------------
NLS_LANGUAGE                                                                     SIMPLIFIED CHINESE
NLS_TERRITORY                                                                    CHINA
NLS_CURRENCYNLS_ISO_CURRENCY                                                                 CHINA
NLS_NUMERIC_CHARACTERS                                                           .,
NLS_CALENDAR                                                                     GREGORIAN
NLS_DATE_FORMAT                                                                  DD-MON-RR
NLS_DATE_LANGUAGE                                                                SIMPLIFIED CHINESE
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_CURRENCYNLS_COMP                                                                         BINARY
NLS_LENGTH_SEMANTICS                                                             BYTE
NLS_NCHAR_CONV_EXCP                                                              FALSE
 
17 rows selected
 
SQL>
 
SQL> select * from v$nls_valid_values;
 
PARAMETER                                                        VALUE                                                            ISDEPRECATED
---------------------------------------------------------------- ---------------------------------------------------------------- ------------
LANGUAGE                                                         AMERICAN                                                         FALSE
LANGUAGE                                                         GERMAN                                                           FALSE
LANGUAGE                                                         FRENCH                                                           FALSE
LANGUAGE                                                         CANADIAN FRENCH                                                  FALSE
LANGUAGE                                                         SPANISH                                                          FALSE
LANGUAGE                                                         ITALIAN                                                          FALSE
LANGUAGE                                                         DUTCH                                                            FALSE
LANGUAGE                                                         SWEDISH                                                          FALSE
LANGUAGE                                                         NORWEGIAN                                                        FALSE
LANGUAGE                                                         DANISH                                                           FALSE
LANGUAGE                                                         FINNISH                                                          FALSE
LANGUAGE                                                         ICELANDIC                                                        FALSE
LANGUAGE                                                         GREEK                                                            FALSE
LANGUAGE                                                         PORTUGUESE                                                       FALSE
LANGUAGE                                                         TURKISH                                                          FALSE
LANGUAGE                                                         BRAZILIAN PORTUGUESE                                             FALSE
LANGUAGE                                                         MEXICAN SPANISH                                                  FALSE
LANGUAGE                                                         RUSSIAN                                                          FALSE
LANGUAGE                                                         POLISH                                                           FALSE
LANGUAGE                                                         HUNGARIAN                                                        FALSE
LANGUAGE                                                         CZECH                                                            FALSE
LANGUAGE                                                         LITHUANIAN                                                       FALSE
LANGUAGE                                                         SLOVAK                                                           FALSE
LANGUAGE                                                         CATALAN                                                          FALSE
LANGUAGE                                                         BULGARIAN                                                        FALSE
LANGUAGE                                                         ROMANIAN                                                         FALSE
LANGUAGE                                                         SLOVENIAN                                                        FALSE
LANGUAGE                                                         HEBREW                                                           FALSE
LANGUAGE                                                         EGYPTIAN                                                         FALSE
LANGUAGE                                                         CROATIAN                                                         FALSE
LANGUAGE                                                         ARABIC                                                           FALSE
LANGUAGE                                                         THAI                                                             FALSE
LANGUAGE                                                         JAPANESE                                                         FALSE
LANGUAGE                                                         KOREAN                                                           FALSE
LANGUAGE                                                         SIMPLIFIED CHINESE                                               FALSE
LANGUAGE                                                         TRADITIONAL CHINESE                                              FALSE
LANGUAGE                                                         ENGLISH                                                          FALSE
LANGUAGE                                                         LATIN AMERICAN SPANISH                                           FALSE
LANGUAGE                                                         UKRAINIAN                                                        FALSE
LANGUAGE                                                         ESTONIAN                                                         FALSE
LANGUAGE                                                         GERMAN DIN                                                       FALSE
LANGUAGE                                                         MALAY                                                            FALSE
LANGUAGE                                                         VIETNAMESE                                                       FALSE
LANGUAGE                                                         BENGALI                                                          TRUE
LANGUAGE                                                         LATVIAN                                                          FALSE
LANGUAGE                                                         INDONESIAN                                                       FALSE
LANGUAGE                                                         HINDI                                                            FALSE
LANGUAGE                                                         TAMIL                                                            FALSE
LANGUAGE                                                         KANNADA                                                          FALSE
LANGUAGE                                                         TELUGU                                                           FALSE
LANGUAGE                                                         ORIYA                                                            FALSE
LANGUAGE                                                         MALAYALAM                                                        FALSE
LANGUAGE                                                         ASSAMESE                                                         FALSE
LANGUAGE                                                         GUJARATI                                                         FALSE
LANGUAGE                                                         MARATHI                                                          FALSE
LANGUAGE                                                         PUNJABI                                                          FALSE
LANGUAGE                                                         BANGLA                                                           FALSE
LANGUAGE                                                         AZERBAIJANI                                                      FALSE
LANGUAGE                                                         MACEDONIAN                                                       FALSE
LANGUAGE                                                         CYRILLIC SERBIAN                                                 FALSE
LANGUAGE                                                         LATIN SERBIAN                                                    FALSE
LANGUAGE                                                         CYRILLIC UZBEK                                                   FALSE
LANGUAGE                                                         LATIN UZBEK                                                      FALSE
LANGUAGE                                                         CYRILLIC KAZAKH                                                  FALSE
LANGUAGE                                                         ALBANIAN                                                         FALSE
TERRITORY                                                        AMERICA                                                          FALSE
TERRITORY                                                        UNITED KINGDOM                                                   FALSE
TERRITORY                                                        GERMANY                                                          FALSE
TERRITORY                                                        FRANCE                                                           FALSE
TERRITORY                                                        CANADA                                                           FALSE
TERRITORY                                                        SPAIN                                                            FALSE
TERRITORY                                                        ITALY                                                            FALSE
TERRITORY                                                        THE NETHERLANDS                                                  FALSE
TERRITORY                                                        SWEDEN                                                           FALSE
TERRITORY                                                        NORWAY                                                           FALSE
TERRITORY                                                        DENMARK                                                          FALSE
TERRITORY                                                        FINLAND                                                          FALSE
TERRITORY                                                        ICELAND                                                          FALSE
TERRITORY                                                        GREECE                                                           FALSE
TERRITORY                                                        PORTUGAL                                                         FALSE
TERRITORY                                                        TURKEY                                                           FALSE
TERRITORY                                                        BRAZIL                                                           FALSE
TERRITORY                                                        MEXICO                                                           FALSE
TERRITORY                                                        CIS                                                              TRUE
TERRITORY                                                        CROATIA                                                          FALSE
TERRITORY                                                        POLAND                                                           FALSE
TERRITORY                                                        HUNGARY                                                          FALSE
TERRITORY                                                        CZECHOSLOVAKIA                                                   TRUE
TERRITORY                                                        LITHUANIA                                                        FALSE
TERRITORY                                                        ISRAEL                                                           FALSE
TERRITORY                                                        BULGARIA                                                         FALSE
TERRITORY                                                        ALGERIA                                                          FALSE
TERRITORY                                                        BAHRAIN                                                          FALSE
TERRITORY                                                        CATALONIA                                                        FALSE
TERRITORY                                                        EGYPT                                                            FALSE
TERRITORY                                                        IRAQ                                                             FALSE
TERRITORY                                                        JORDAN                                                           FALSE
TERRITORY                                                        KUWAIT                                                           FALSE
TERRITORY                                                        LEBANON                                                          FALSE
TERRITORY                                                        LIBYA                                                            FALSE
TERRITORY                                                        MOROCCO                                                          FALSE
TERRITORY                                                        MAURITANIA                                                       FALSE
TERRITORY                                                        OMAN                                                             FALSE
TERRITORY                                                        QATAR                                                            FALSE
TERRITORY                                                        ROMANIA                                                          FALSE
TERRITORY                                                        SAUDI ARABIA                                                     FALSE
TERRITORY                                                        SOMALIA                                                          FALSE
TERRITORY                                                        SYRIA                                                            FALSE
TERRITORY                                                        DJIBOUTI                                                         FALSE
TERRITORY                                                        SLOVENIA                                                         FALSE
TERRITORY                                                        TUNISIA                                                          FALSE
TERRITORY                                                        YEMEN                                                            FALSE
TERRITORY                                                        SUDAN                                                            FALSE
TERRITORY                                                        SWITZERLAND                                                      FALSE
TERRITORY                                                        AUSTRIA                                                          FALSE
TERRITORY                                                        UNITED ARAB EMIRATES                                             FALSE
TERRITORY                                                        THAILAND                                                         FALSE
TERRITORY                                                        CHINA                                                            FALSE
TERRITORY                                                        HONG KONG                                                        FALSE
TERRITORY                                                        JAPAN                                                            FALSE
TERRITORY                                                        KOREA                                                            FALSE
TERRITORY                                                        TAIWAN                                                           FALSE
TERRITORY                                                        CZECH REPUBLIC                                                   FALSE
TERRITORY                                                        SLOVAKIA                                                         FALSE
TERRITORY                                                        UKRAINE                                                          FALSE
TERRITORY                                                        ESTONIA                                                          FALSE
TERRITORY                                                        MALAYSIA                                                         FALSE
TERRITORY                                                        BANGLADESH                                                       FALSE
TERRITORY                                                        LATVIA                                                           FALSE
TERRITORY                                                        VIETNAM                                                          FALSE
TERRITORY                                                        INDONESIA                                                        FALSE
TERRITORY                                                        CYPRUS                                                           FALSE
TERRITORY                                                        AUSTRALIA                                                        FALSE
TERRITORY                                                        KAZAKHSTAN                                                       FALSE
TERRITORY                                                        UZBEKISTAN                                                       FALSE
TERRITORY                                                        SINGAPORE                                                        FALSE
TERRITORY                                                        SOUTH AFRICA                                                     FALSE
TERRITORY                                                        IRELAND                                                          FALSE
TERRITORY                                                        BELGIUM                                                          FALSE
TERRITORY                                                        LUXEMBOURG                                                       FALSE
TERRITORY                                                        NEW ZEALAND                                                      FALSE
TERRITORY                                                        INDIA                                                            FALSE
TERRITORY                                                        CHILE                                                            FALSE
TERRITORY                                                        COLOMBIA                                                         FALSE
TERRITORY                                                        COSTA RICA                                                       FALSE
TERRITORY                                                        EL SALVADOR                                                      FALSE
TERRITORY                                                        GUATEMALA                                                        FALSE
TERRITORY                                                        NICARAGUA                                                        FALSE
TERRITORY                                                        PANAMA                                                           FALSE
TERRITORY                                                        PERU                                                             FALSE
TERRITORY                                                        PUERTO RICO                                                      FALSE
TERRITORY                                                        VENEZUELA                                                        FALSE
TERRITORY                                                        YUGOSLAVIA                                                       TRUE
TERRITORY                                                        MACEDONIA                                                        TRUE
TERRITORY                                                        RUSSIA                                                           FALSE
TERRITORY                                                        AZERBAIJAN                                                       FALSE
TERRITORY                                                        FYR MACEDONIA                                                    FALSE
TERRITORY                                                        SERBIA AND MONTENEGRO                                            FALSE
TERRITORY                                                        ARGENTINA                                                        FALSE
TERRITORY                                                        ECUADOR                                                          FALSE
TERRITORY                                                        PHILIPPINES                                                      FALSE
TERRITORY                                                        ALBANIA                                                          FALSE
CHARACTERSET                                                     US7ASCII                                                         FALSE
CHARACTERSET                                                     WE8DEC                                                           FALSE
CHARACTERSET                                                     WE8HP                                                            FALSE
CHARACTERSET                                                     US8PC437                                                         FALSE
CHARACTERSET                                                     WE8EBCDIC37                                                      FALSE
CHARACTERSET                                                     WE8EBCDIC500                                                     FALSE
CHARACTERSET                                                     WE8EBCDIC1140                                                    FALSE
CHARACTERSET                                                     WE8EBCDIC285                                                     FALSE
CHARACTERSET                                                     WE8EBCDIC1146                                                    FALSE
CHARACTERSET                                                     WE8PC850                                                         FALSE
CHARACTERSET                                                     D7DEC                                                            FALSE
CHARACTERSET                                                     F7DEC                                                            FALSE
CHARACTERSET                                                     S7DEC                                                            FALSE
CHARACTERSET                                                     E7DEC                                                            FALSE
CHARACTERSET                                                     SF7ASCII                                                         FALSE
CHARACTERSET                                                     NDK7DEC                                                          FALSE
CHARACTERSET                                                     I7DEC                                                            FALSE
CHARACTERSET                                                     NL7DEC                                                           FALSE
CHARACTERSET                                                     CH7DEC                                                           FALSE
CHARACTERSET                                                     YUG7ASCII                                                        FALSE
CHARACTERSET                                                     SF7DEC                                                           FALSE
CHARACTERSET                                                     TR7DEC                                                           FALSE
CHARACTERSET                                                     IW7IS960                                                         FALSE
CHARACTERSET                                                     IN8ISCII                                                         FALSE
CHARACTERSET                                                     WE8EBCDIC1148                                                    FALSE
CHARACTERSET                                                     WE8PC858                                                         FALSE
CHARACTERSET                                                     WE8ISO8859P1                                                     FALSE
CHARACTERSET                                                     EE8ISO8859P2                                                     FALSE
CHARACTERSET                                                     SE8ISO8859P3                                                     FALSE
CHARACTERSET                                                     NEE8ISO8859P4                                                    FALSE
CHARACTERSET                                                     CL8ISO8859P5                                                     FALSE
CHARACTERSET                                                     AR8ISO8859P6                                                     FALSE
CHARACTERSET                                                     EL8ISO8859P7                                                     FALSE
CHARACTERSET                                                     IW8ISO8859P8                                                     FALSE
CHARACTERSET                                                     WE8ISO8859P9                                                     FALSE
CHARACTERSET                                                     NE8ISO8859P10                                                    FALSE
CHARACTERSET                                                     TH8TISASCII                                                      FALSE
CHARACTERSET                                                     TH8TISEBCDIC                                                     FALSE
CHARACTERSET                                                     BN8BSCII                                                         FALSE
CHARACTERSET                                                     VN8VN3                                                           FALSE
CHARACTERSET                                                     VN8MSWIN1258                                                     FALSE
CHARACTERSET                                                     WE8ISO8859P15                                                    FALSE
CHARACTERSET                                                     BLT8ISO8859P13                                                   FALSE
CHARACTERSET                                                     CEL8ISO8859P14                                                   FALSE
CHARACTERSET                                                     CL8ISOIR111                                                      FALSE
CHARACTERSET                                                     WE8NEXTSTEP                                                      FALSE
CHARACTERSET                                                     CL8KOI8U                                                         FALSE
CHARACTERSET                                                     AZ8ISO8859P9E                                                    FALSE
CHARACTERSET                                                     AR8ASMO708PLUS                                                   FALSE
CHARACTERSET                                                     AR8EBCDICX                                                       FALSE
CHARACTERSET                                                     AR8XBASIC                                                        FALSE
CHARACTERSET                                                     EL8DEC                                                           FALSE
CHARACTERSET                                                     TR8DEC                                                           FALSE
CHARACTERSET                                                     WE8EBCDIC37C                                                     FALSE
CHARACTERSET                                                     WE8EBCDIC500C                                                    FALSE
CHARACTERSET                                                     IW8EBCDIC424                                                     FALSE
CHARACTERSET                                                     TR8EBCDIC1026                                                    FALSE
CHARACTERSET                                                     WE8EBCDIC871                                                     FALSE
CHARACTERSET                                                     WE8EBCDIC284                                                     FALSE
CHARACTERSET                                                     WE8EBCDIC1047                                                    FALSE
CHARACTERSET                                                     WE8EBCDIC1140C                                                   FALSE
CHARACTERSET                                                     WE8EBCDIC1145                                                    FALSE
CHARACTERSET                                                     WE8EBCDIC1148C                                                   FALSE
CHARACTERSET                                                     WE8EBCDIC1047E                                                   FALSE
CHARACTERSET                                                     WE8EBCDIC924                                                     FALSE
CHARACTERSET                                                     EEC8EUROASCI                                                     FALSE
CHARACTERSET                                                     EEC8EUROPA3                                                      FALSE
CHARACTERSET                                                     LA8PASSPORT                                                      FALSE
CHARACTERSET                                                     BG8PC437S                                                        FALSE
CHARACTERSET                                                     EE8PC852                                                         FALSE
CHARACTERSET                                                     RU8PC866                                                         FALSE
CHARACTERSET                                                     RU8BESTA                                                         FALSE
CHARACTERSET                                                     IW8PC1507                                                        FALSE
CHARACTERSET                                                     RU8PC855                                                         FALSE
CHARACTERSET                                                     TR8PC857                                                         FALSE
CHARACTERSET                                                     CL8MACCYRILLIC                                                   FALSE
CHARACTERSET                                                     CL8MACCYRILLICS                                                  FALSE
CHARACTERSET                                                     WE8PC860                                                         FALSE
CHARACTERSET                                                     IS8PC861                                                         FALSE
CHARACTERSET                                                     EE8MACCES                                                        FALSE
CHARACTERSET                                                     EE8MACCROATIANS                                                  FALSE
CHARACTERSET                                                     TR8MACTURKISHS                                                   FALSE
CHARACTERSET                                                     IS8MACICELANDICS                                                 FALSE
CHARACTERSET                                                     EL8MACGREEKS                                                     FALSE
CHARACTERSET                                                     IW8MACHEBREWS                                                    FALSE
CHARACTERSET                                                     EE8MSWIN1250                                                     FALSE
CHARACTERSET                                                     CL8MSWIN1251                                                     FALSE
CHARACTERSET                                                     ET8MSWIN923                                                      FALSE
CHARACTERSET                                                     BG8MSWIN                                                         FALSE
CHARACTERSET                                                     EL8MSWIN1253                                                     FALSE
CHARACTERSET                                                     IW8MSWIN1255                                                     FALSE
CHARACTERSET                                                     LT8MSWIN921                                                      FALSE
CHARACTERSET                                                     TR8MSWIN1254                                                     FALSE
CHARACTERSET                                                     WE8MSWIN1252                                                     FALSE
CHARACTERSET                                                     BLT8MSWIN1257                                                    FALSE
CHARACTERSET                                                     D8EBCDIC273                                                      FALSE
CHARACTERSET                                                     I8EBCDIC280                                                      FALSE
CHARACTERSET                                                     DK8EBCDIC277                                                     FALSE
CHARACTERSET                                                     S8EBCDIC278                                                      FALSE
CHARACTERSET                                                     EE8EBCDIC870                                                     FALSE
CHARACTERSET                                                     CL8EBCDIC1025                                                    FALSE
CHARACTERSET                                                     F8EBCDIC297                                                      FALSE
CHARACTERSET                                                     IW8EBCDIC1086                                                    FALSE
CHARACTERSET                                                     CL8EBCDIC1025X                                                   FALSE
CHARACTERSET                                                     D8EBCDIC1141                                                     FALSE
CHARACTERSET                                                     N8PC865                                                          FALSE
CHARACTERSET                                                     BLT8CP921                                                        FALSE
CHARACTERSET                                                     LV8PC1117                                                        FALSE
CHARACTERSET                                                     LV8PC8LR                                                         FALSE
CHARACTERSET                                                     BLT8EBCDIC1112                                                   FALSE
CHARACTERSET                                                     LV8RST104090                                                     FALSE
CHARACTERSET                                                     CL8KOI8R                                                         FALSE
CHARACTERSET                                                     BLT8PC775                                                        FALSE
CHARACTERSET                                                     DK8EBCDIC1142                                                    FALSE
CHARACTERSET                                                     S8EBCDIC1143                                                     FALSE
CHARACTERSET                                                     I8EBCDIC1144                                                     FALSE
CHARACTERSET                                                     F7SIEMENS9780X                                                   FALSE
CHARACTERSET                                                     E7SIEMENS9780X                                                   FALSE
CHARACTERSET                                                     S7SIEMENS9780X                                                   FALSE
CHARACTERSET                                                     DK7SIEMENS9780X                                                  FALSE
CHARACTERSET                                                     N7SIEMENS9780X                                                   FALSE
CHARACTERSET                                                     I7SIEMENS9780X                                                   FALSE
CHARACTERSET                                                     D7SIEMENS9780X                                                   FALSE
CHARACTERSET                                                     F8EBCDIC1147                                                     FALSE
CHARACTERSET                                                     WE8GCOS7                                                         FALSE
CHARACTERSET                                                     EL8GCOS7                                                         FALSE
CHARACTERSET                                                     US8BS2000                                                        FALSE
CHARACTERSET                                                     D8BS2000                                                         FALSE
CHARACTERSET                                                     F8BS2000                                                         FALSE
CHARACTERSET                                                     E8BS2000                                                         FALSE
CHARACTERSET                                                     DK8BS2000                                                        FALSE
CHARACTERSET                                                     S8BS2000                                                         FALSE
CHARACTERSET                                                     WE8BS2000E                                                       FALSE
CHARACTERSET                                                     WE8BS2000                                                        FALSE
CHARACTERSET                                                     EE8BS2000                                                        FALSE
CHARACTERSET                                                     CE8BS2000                                                        FALSE
CHARACTERSET                                                     CL8BS2000                                                        FALSE
CHARACTERSET                                                     WE8BS2000L5                                                      FALSE
CHARACTERSET                                                     WE8DG                                                            FALSE
CHARACTERSET                                                     WE8NCR4970                                                       FALSE
CHARACTERSET                                                     WE8ROMAN8                                                        FALSE
CHARACTERSET                                                     EE8MACCE                                                         FALSE
CHARACTERSET                                                     EE8MACCROATIAN                                                   FALSE
CHARACTERSET                                                     TR8MACTURKISH                                                    FALSE
CHARACTERSET                                                     IS8MACICELANDIC                                                  FALSE
CHARACTERSET                                                     EL8MACGREEK                                                      FALSE
CHARACTERSET                                                     IW8MACHEBREW                                                     FALSE
CHARACTERSET                                                     US8ICL                                                           FALSE
CHARACTERSET                                                     WE8ICL                                                           FALSE
CHARACTERSET                                                     WE8ISOICLUK                                                      FALSE
CHARACTERSET                                                     EE8EBCDIC870C                                                    FALSE
CHARACTERSET                                                     EL8EBCDIC875S                                                    TRUE
CHARACTERSET                                                     TR8EBCDIC1026S                                                   FALSE
CHARACTERSET                                                     BLT8EBCDIC1112S                                                  FALSE
CHARACTERSET                                                     IW8EBCDIC424S                                                    FALSE
CHARACTERSET                                                     EE8EBCDIC870S                                                    FALSE
CHARACTERSET                                                     CL8EBCDIC1025S                                                   FALSE
CHARACTERSET                                                     TH8TISEBCDICS                                                    FALSE
CHARACTERSET                                                     AR8EBCDIC420S                                                    FALSE
CHARACTERSET                                                     CL8EBCDIC1025C                                                   FALSE
CHARACTERSET                                                     CL8EBCDIC1025R                                                   FALSE
CHARACTERSET                                                     EL8EBCDIC875R                                                    FALSE
CHARACTERSET                                                     CL8EBCDIC1158                                                    FALSE
CHARACTERSET                                                     CL8EBCDIC1158R                                                   FALSE
CHARACTERSET                                                     EL8EBCDIC423R                                                    FALSE
CHARACTERSET                                                     WE8MACROMAN8                                                     FALSE
CHARACTERSET                                                     WE8MACROMAN8S                                                    FALSE
CHARACTERSET                                                     TH8MACTHAI                                                       FALSE
CHARACTERSET                                                     TH8MACTHAIS                                                      FALSE
CHARACTERSET                                                     HU8CWI2                                                          FALSE
CHARACTERSET                                                     EL8PC437S                                                        FALSE
CHARACTERSET                                                     EL8EBCDIC875                                                     FALSE
CHARACTERSET                                                     EL8PC737                                                         FALSE
CHARACTERSET                                                     LT8PC772                                                         FALSE
CHARACTERSET                                                     LT8PC774                                                         FALSE
CHARACTERSET                                                     EL8PC869                                                         FALSE
CHARACTERSET                                                     EL8PC851                                                         FALSE
CHARACTERSET                                                     CDN8PC863                                                        FALSE
CHARACTERSET                                                     HU8ABMOD                                                         FALSE
CHARACTERSET                                                     AR8ASMO8X                                                        FALSE
CHARACTERSET                                                     AR8NAFITHA711T                                                   FALSE
CHARACTERSET                                                     AR8SAKHR707T                                                     FALSE
CHARACTERSET                                                     AR8MUSSAD768T                                                    FALSE
CHARACTERSET                                                     AR8ADOS710T                                                      FALSE
CHARACTERSET                                                     AR8ADOS720T                                                      FALSE
CHARACTERSET                                                     AR8APTEC715T                                                     FALSE
CHARACTERSET                                                     AR8NAFITHA721T                                                   FALSE
CHARACTERSET                                                     AR8HPARABIC8T                                                    FALSE
CHARACTERSET                                                     AR8NAFITHA711                                                    FALSE
CHARACTERSET                                                     AR8SAKHR707                                                      FALSE
CHARACTERSET                                                     AR8MUSSAD768                                                     FALSE
CHARACTERSET                                                     AR8ADOS710                                                       FALSE
CHARACTERSET                                                     AR8ADOS720                                                       FALSE
CHARACTERSET                                                     AR8APTEC715                                                      FALSE
CHARACTERSET                                                     AR8MSWIN1256                                                     FALSE
CHARACTERSET                                                     AR8NAFITHA721                                                    FALSE
CHARACTERSET                                                     AR8SAKHR706                                                      FALSE
CHARACTERSET                                                     AR8ARABICMAC                                                     FALSE
CHARACTERSET                                                     AR8ARABICMACS                                                    FALSE
CHARACTERSET                                                     AR8ARABICMACT                                                    FALSE
CHARACTERSET                                                     LA8ISO6937                                                       FALSE
CHARACTERSET                                                     JA16VMS                                                          FALSE
CHARACTERSET                                                     JA16EUC                                                          FALSE
CHARACTERSET                                                     JA16EUCYEN                                                       FALSE
CHARACTERSET                                                     JA16SJIS                                                         FALSE
CHARACTERSET                                                     JA16DBCS                                                         FALSE
CHARACTERSET                                                     JA16SJISYEN                                                      FALSE
CHARACTERSET                                                     JA16EBCDIC930                                                    FALSE
CHARACTERSET                                                     JA16MACSJIS                                                      FALSE
CHARACTERSET                                                     JA16EUCTILDE                                                     FALSE
CHARACTERSET                                                     JA16SJISTILDE                                                    FALSE
CHARACTERSET                                                     KO16KSC5601                                                      FALSE
CHARACTERSET                                                     KO16DBCS                                                         FALSE
CHARACTERSET                                                     KO16KSCCS                                                        FALSE
CHARACTERSET                                                     KO16MSWIN949                                                     FALSE
CHARACTERSET                                                     ZHS16CGB231280                                                   FALSE
CHARACTERSET                                                     ZHS16MACCGB231280                                                FALSE
CHARACTERSET                                                     ZHS16GBK                                                         FALSE
CHARACTERSET                                                     ZHS16DBCS                                                        FALSE
CHARACTERSET                                                     ZHS32GB18030                                                     FALSE
CHARACTERSET                                                     ZHT32EUC                                                         FALSE
CHARACTERSET                                                     ZHT32SOPS                                                        FALSE
CHARACTERSET                                                     ZHT16DBT                                                         FALSE
CHARACTERSET                                                     ZHT32TRIS                                                        FALSE
CHARACTERSET                                                     ZHT16DBCS                                                        FALSE
CHARACTERSET                                                     ZHT16BIG5                                                        FALSE
CHARACTERSET                                                     ZHT16CCDC                                                        FALSE
CHARACTERSET                                                     ZHT16MSWIN950                                                    FALSE
CHARACTERSET                                                     ZHT16HKSCS                                                       FALSE
CHARACTERSET                                                     AL24UTFFSS                                                       TRUE
CHARACTERSET                                                     UTF8                                                             FALSE
CHARACTERSET                                                     UTFE                                                             FALSE
CHARACTERSET                                                     AL32UTF8                                                         FALSE
CHARACTERSET                                                     ZHT16HKSCS31                                                     FALSE
CHARACTERSET                                                     JA16EUCFIXED                                                     TRUE
CHARACTERSET                                                     JA16SJISFIXED                                                    TRUE
CHARACTERSET                                                     JA16DBCSFIXED                                                    TRUE
CHARACTERSET                                                     KO16KSC5601FIXED                                                 TRUE
CHARACTERSET                                                     KO16DBCSFIXED                                                    TRUE
CHARACTERSET                                                     ZHS16CGB231280FIXED                                              TRUE
CHARACTERSET                                                     ZHS16GBKFIXED                                                    TRUE
CHARACTERSET                                                     ZHS16DBCSFIXED                                                   TRUE
CHARACTERSET                                                     ZHT32EUCFIXED                                                    TRUE
CHARACTERSET                                                     ZHT32TRISFIXED                                                   TRUE
CHARACTERSET                                                     ZHT16DBCSFIXED                                                   TRUE
CHARACTERSET                                                     ZHT16BIG5FIXED                                                   TRUE
CHARACTERSET                                                     AL16UTF16                                                        FALSE
SORT                                                             BINARY                                                           FALSE
SORT                                                             WEST_EUROPEAN                                                    FALSE
SORT                                                             XWEST_EUROPEAN                                                   FALSE
SORT                                                             GERMAN                                                           FALSE
SORT                                                             XGERMAN                                                          FALSE
SORT                                                             DANISH                                                           FALSE
SORT                                                             XDANISH                                                          FALSE
SORT                                                             SPANISH                                                          FALSE
SORT                                                             XSPANISH                                                         FALSE
SORT                                                             GERMAN_DIN                                                       FALSE
SORT                                                             XGERMAN_DIN                                                      FALSE
SORT                                                             FINNISH                                                          FALSE
SORT                                                             FRENCH                                                           FALSE
SORT                                                             NORWEGIAN                                                        FALSE
SORT                                                             SWEDISH                                                          FALSE
SORT                                                             ITALIAN                                                          FALSE
SORT                                                             ICELANDIC                                                        FALSE
SORT                                                             DUTCH                                                            FALSE
SORT                                                             XDUTCH                                                           FALSE
SORT                                                             SWISS                                                            FALSE
SORT                                                             XSWISS                                                           FALSE
SORT                                                             ARABIC                                                           FALSE
SORT                                                             HUNGARIAN                                                        FALSE
SORT                                                             XHUNGARIAN                                                       FALSE
SORT                                                             GREEK                                                            FALSE
SORT                                                             CZECH                                                            FALSE
SORT                                                             XCZECH                                                           FALSE
SORT                                                             POLISH                                                           FALSE
SORT                                                             SLOVAK                                                           FALSE
SORT                                                             XSLOVAK                                                          FALSE
SORT                                                             LATIN                                                            FALSE
SORT                                                             THAI_DICTIONARY                                                  TRUE
SORT                                                             THAI_TELEPHONE                                                   TRUE
SORT                                                             TURKISH                                                          FALSE
SORT                                                             XTURKISH                                                         FALSE
SORT                                                             RUSSIAN                                                          FALSE
SORT                                                             HEBREW                                                           FALSE
SORT                                                             LITHUANIAN                                                       FALSE
SORT                                                             CROATIAN                                                         FALSE
SORT                                                             XCROATIAN                                                        FALSE
SORT                                                             ROMANIAN                                                         FALSE
SORT                                                             BULGARIAN                                                        FALSE
SORT                                                             CATALAN                                                          FALSE
SORT                                                             XCATALAN                                                         FALSE
SORT                                                             SLOVENIAN                                                        FALSE
SORT                                                             XSLOVENIAN                                                       FALSE
SORT                                                             UKRAINIAN                                                        FALSE
SORT                                                             ESTONIAN                                                         FALSE
SORT                                                             ASCII7                                                           FALSE
SORT                                                             JAPANESE                                                         TRUE
SORT                                                             MALAY                                                            FALSE
SORT                                                             PUNCTUATION                                                      FALSE
SORT                                                             XPUNCTUATION                                                     FALSE
SORT                                                             CANADIAN FRENCH                                                  TRUE
SORT                                                             VIETNAMESE                                                       FALSE
SORT                                                             EEC_EURO                                                         FALSE
SORT                                                             LATVIAN                                                          FALSE
SORT                                                             BENGALI                                                          FALSE
SORT                                                             XFRENCH                                                          FALSE
SORT                                                             INDONESIAN                                                       FALSE
SORT                                                             ARABIC_MATCH                                                     FALSE
SORT                                                             ARABIC_ABJ_SORT                                                  FALSE
SORT                                                             ARABIC_ABJ_MATCH                                                 FALSE
SORT                                                             EEC_EUROPA3                                                      FALSE
SORT                                                             CZECH_PUNCTUATION                                                FALSE
SORT                                                             XCZECH_PUNCTUATION                                               FALSE
SORT                                                             UNICODE_BINARY                                                   FALSE
SORT                                                             EBCDIC                                                           FALSE
SORT                                                             GENERIC_BASELETTER                                               FALSE
SORT                                                             AZERBAIJANI                                                      FALSE
SORT                                                             XAZERBAIJANI                                                     FALSE
SORT                                                             GENERIC_M                                                        FALSE
SORT                                                             SPANISH_M                                                        FALSE
SORT                                                             FRENCH_M                                                         FALSE
SORT                                                             THAI_M                                                           FALSE
SORT                                                             CANADIAN_M                                                       FALSE
SORT                                                             DANISH_M                                                         FALSE
SORT                                                             TCHINESE_RADICAL_M                                               FALSE
SORT                                                             BIG5                                                             FALSE
SORT                                                             HKSCS                                                            FALSE
SORT                                                             TCHINESE_STROKE_M                                                FALSE
SORT                                                             SCHINESE_PINYIN_M                                                FALSE
SORT                                                             SCHINESE_STROKE_M                                                FALSE
SORT                                                             GBK                                                              FALSE
SORT                                                             SCHINESE_RADICAL_M                                               FALSE
SORT                                                             JAPANESE_M                                                       FALSE
SORT                                                             KOREAN_M                                                         FALSE
 
496 rows selected

本页面的文字允许在知识共享 署名-相同方式共享 3.0协议和GNU自由文档许可证下修改和再使用,仅有一个特殊要求,请用链接方式注明文章引用出处及作者。请协助维护作者合法权益。


系列文章

文章列表

  • Oracle V$NLS_PARAMETER与NLS_DATABASE_PARAMETERS的区别

这篇文章对你有帮助吗,投个票吧?

rating: 0+x

留下你的评论

Add a New Comment
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License