如何查到数据库字符集,谢谢AMERICAN_AMERICA.AL32UTF8 AMERICAN_AMERICA.AL32UTF8 哪个地方查到的数据库字符集是这样显示的,谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from nls_database_parameters; 看这个:select sys_context('USERENV', 'LANGUAGE') from dual; 一楼给的能查到american america al32utf8 这些都是不在同一行上,另UTF8和AL32UTF8有什么区别没 --查看当前数据库字符集设置SQL> select * from nls_database_parameters;PARAMETER VALUE---------------------------------------- ------------------------------------------------------------NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS .,NLS_CHARACTERSET AL32UTF8NLS_CALENDAR GREGORIANNLS_DATE_FORMAT DD-MON-RRNLS_DATE_LANGUAGE AMERICANNLS_SORT BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMPARAMETER VALUE---------------------------------------- ------------------------------------------------------------NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY $NLS_COMP BINARYNLS_LENGTH_SEMANTICS BYTENLS_NCHAR_CONV_EXCP FALSENLS_NCHAR_CHARACTERSET AL16UTF16NLS_RDBMS_VERSION 11.1.0.6.020 rows selected.SQL> SQL> select sys_context('USERENV', 'LANGUAGE') from dual;SYS_CONTEXT('USERENV','LANGUAGE')-------------------------------------------------------------------------------------------------------------------------AMERICAN_AMERICA.AL32UTF8SQL> SQL> SQL> SELECT USERENV('LANGUAGE') "Language" FROM DUAL;Language--------------------------------------------------------------------------------------------------------AMERICAN_AMERICA.AL32UTF8 select * from nls_database_parameters; 求一条简单的SQL语句,关于跨表更新,Oracle数据库语法 基础,导出导入表,麻烦解疑下 为什么在这张表上做查询速度这么慢? 备份恢复问题。急,多谢。 请教怎样查看当前数据库的时间格式? 很简单的问题!!!!!!!!!!! Oracle是否可以在客户端不安装其他的任何软件就可以访问?如果可以如何书写主机和服务名。 怎样随机插入若干条记录? Oracle 包(Package)全局变量疑惑 查询机构及其各子机构的工单处理情况 tiemstamp与datetime类型的区别 oracle几个问题请高手帮忙
select sys_context('USERENV', 'LANGUAGE') from dual;
america
al32utf8
这些都是不在同一行上,另UTF8和AL32UTF8有什么区别没
--查看当前数据库字符集设置
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 AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AMPARAMETER VALUE
---------------------------------------- ------------------------------------------------------------
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 11.1.0.6.020 rows selected.SQL>
-------------------------------------------------------------------------------------------------------------------------
AMERICAN_AMERICA.AL32UTF8SQL>
SQL>
SQL> SELECT USERENV('LANGUAGE') "Language" FROM DUAL;Language
--------------------------------------------------------------------------------------------------------
AMERICAN_AMERICA.AL32UTF8