oracle 编码问题 讨论解决

AL32utf8和utf8字符集有什么区别和联系？

http://www.oracle.com.cn/viewthread.php?tid=68527

Al32UTF8 支持更高版本的Unicode(3.1),
而且, AL32UTF8只支持9i以及更高版本的数据库
UTF8既可以作为数据库字符集,也可以作为国家字符集(9i)
AL32UTF8只能作为数据库字符集

 

 

 

oracle 客户端执行select * from nls_database_parameters

 

winxp下执行结果

PARAMETERVALUENLS_LANGUAGESIMPLIFIED CHINESENLS_TERRITORYCHINANLS_CURRENCY?NLS_ISO_CURRENCYCHINANLS_NUMERIC_CHARACTERS.,NLS_CHARACTERSETAL32UTF8NLS_CALENDARGREGORIANNLS_DATE_FORMATDD-MON-RRNLS_DATE_LANGUAGESIMPLIFIED CHINESENLS_SORTBINARYNLS_TIME_FORMATHH.MI.SSXFF AMNLS_TIMESTAMP_FORMATDD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMATHH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY?NLS_COMPBINARYNLS_LENGTH_SEMANTICSBYTENLS_NCHAR_CONV_EXCPFALSENLS_NCHAR_CHARACTERSETUTF8NLS_RDBMS_VERSION10.2.0.1.0

 

问题解决中。。。。待续

 

Linux Ubuntu客户端下：

 

PARAMETERVALUENLS_LANGUAGEAMERICANNLS_TERRITORYAMERICANLS_CURRENCY$NLS_ISO_CURRENCYAMERICANLS_NUMERIC_CHARACTERS.,NLS_CALENDARGREGORIANNLS_DATE_FORMATDD-MON-RRNLS_DATE_LANGUAGEAMERICANNLS_CHARACTERSETAL32UTF8NLS_SORTBINARYNLS_TIME_FORMATHH.MI.SSXFF AMNLS_TIMESTAMP_FORMATDD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMATHH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY$NLS_NCHAR_CHARACTERSETUTF8NLS_COMPBINARYNLS_LENGTH_SEMANTICSBYTENLS_NCHAR_CONV_EXCPFALSE