查看nls_database_parameters系统配置
select * from nls_database_parameters;
SELECT * FROM PROPS$;
修改nls_database_parameters系统配置(注意:此处要以sys超级管理员登陆,否则没权限)
update props$ set value$ = ' ZHS16GBK ' where name = ' NLS_CHARACTERSET '
默认nls_database_parameters系统配置
PARAMETER : VALUE
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 : 10.2 . 0.4 . 0
select * from nls_database_parameters;
SELECT * FROM PROPS$;
修改nls_database_parameters系统配置(注意:此处要以sys超级管理员登陆,否则没权限)
update props$ set value$ = ' ZHS16GBK ' where name = ' NLS_CHARACTERSET '
默认nls_database_parameters系统配置
PARAMETER : VALUE
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 : 10.2 . 0.4 . 0