AL32utf8和utf8字符集有什么区别和联系?
Al32UTF8 支持更高版本的Unicode(3.1),
而且, AL32UTF8只支持9i以及更高版本的数据库
UTF8既可以作为数据库字符集,也可以作为国家字符集(9i)
AL32UTF8只能作为数据库字符集
而且, AL32UTF8只支持9i以及更高版本的数据库
UTF8既可以作为数据库字符集,也可以作为国家字符集(9i)
AL32UTF8只能作为数据库字符集
oracle 客户端执行select * from nls_database_parameters
winxp下执行结果
PARAMETER | VALUE |
---|---|
NLS_LANGUAGE | SIMPLIFIED CHINESE |
NLS_TERRITORY | CHINA |
NLS_CURRENCY | ? |
NLS_ISO_CURRENCY | CHINA |
NLS_NUMERIC_CHARACTERS | ., |
NLS_CHARACTERSET | AL32UTF8 |
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 |
NLS_NCHAR_CHARACTERSET | UTF8 |
NLS_RDBMS_VERSION | 10.2.0.1.0 |
问题解决中。。。。待续
Linux Ubuntu客户端下:
PARAMETER | VALUE |
---|---|
NLS_LANGUAGE | AMERICAN |
NLS_TERRITORY | AMERICA |
NLS_CURRENCY | $ |
NLS_ISO_CURRENCY | AMERICA |
NLS_NUMERIC_CHARACTERS | ., |
NLS_CALENDAR | GREGORIAN |
NLS_DATE_FORMAT | DD-MON-RR |
NLS_DATE_LANGUAGE | AMERICAN |
NLS_CHARACTERSET | AL32UTF8 |
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 |