Oracle V$NLS_PARAMETER与NLS_DATABASE_PARAMETERS的区别
博客首页 » Oracle V$NLS_PARAMETER与NLS_DATABASE_PARAMETERS的区别
发布于 18 Dec 2013 00:33
标签 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.htm2. 查看 NLS_LANG 的方法
Windows使用:echo %NLS_LANG%
如:
E:/>echo %NLS_LANG%
AMERICAN_AMERICA.ZHS16GBKUnix使用:
env|grep NLS_LANG
如:
/opt/oracle>env|grep NLS_LANG
NLS_LANG=AMERICAN_CHINA.ZHS16GBKWindows客户端设置,可以在注册表中更改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:
- 常用中文字符集
set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
- 常用unicode字符集
set NLS_LANG=american_america.AL32UTF8
可以通过修改注册表键值永久设置
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMExx/NLS_LANGUnix:
- 常用unicode字符集
export NLS_LANG=american_america.AL32UTF8
- 常用中文字符集
export NLS_LANG="Simplified Chinese_china".ZHS16GBK
可以编辑 bash_profile 文件进行永久设置
vi .bash_profile
NLS_LANG="Simplified Chinese_china".ZHS16GBK export NLS_LANG
- 使 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_CURRENCY ￥ NLS_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_CURRENCY ￥ NLS_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_CURRENCY ￥ NLS_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_CURRENCY ￥ NLS_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的区别
这篇文章对你有帮助吗，投个票吧？
留下你的评论