分类: Oracle
2009-09-15 16:48:39
1) 查看服务器端字符集:
select * from nls_database_parameters;
select * from sys.props$;
-------------------------
以上两个算是无异议了。
不过 ,
select * from v$nls_parameters;
select userenv('language') from dual;
以上这两个也是返回服务器端字符集? 有点乱
看看吧:
SQL> select name,value$ from props$; NAME VALUE$ ------------------------------ ------------------------------------ DICT.BASE 2 DEFAULT_TEMP_TABLESPACE TEMP DBTIMEZONE -07:00 NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET ZHS16GBK 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 AL16UTF16 NLS_RDBMS_VERSION 9.2.0.1.0 GLOBAL_DB_NAME XD.US.ORACLE.COM EXPORT_VIEWS_VERSION 8