语言_地域.字符集simplified chinese_china.zhs16gbk set nls_lang=
语言_地域.字符集
simplified chinese_china.zhs16gbk
set nls_lang='simplified chinese_china.zhs16gbk'
oracle修改服务器端字符集：
sql>shutdown immediate;
sql>startup mount;
sql>alter system enable restricted session;
sql>alter system set job_queue_processes=0;
sql>alter system set aq_tm_processes=0;
sql>alter database open;
sql>alter database character set zhs16gbk;
如果出现了 error at line 1: ora-12712: new character set must be a superset of old character set
sql> alter database character set internal_use zhs16gbk; # 使用internal_use可以跳过超集的检查,
alter database character set internal_use
sql>shutdown immediate;
sql>startup 再检查就发现已经把字符集修整过来了
nls_lang=american_america.zhs16gbk
##################################################################################################################
--当前会话的信息
sql> select * from nls_session_parameters;
parameter value
-------------------- ----------------------------------------
nls_language american
nls_territory america
nls_currency $
nls_iso_currency america
nls_numeric_characte .,
rs
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_for dd-mon-rr hh.mi.ssxff am tzr
mat
nls_dual_currency $
nls_comp binary
nls_length_semantics byte
nls_nchar_conv_excp false
17 rows selected.
--实例的信息
sql> select * from nls_instance_parameters;
parameter value
-------------------- ----------------------------------------
nls_language american
nls_territory america
nls_sort
nls_date_language
nls_date_format
nls_currency
nls_numeric_characte
rs
nls_iso_currency
nls_calendar
nls_time_format
nls_timestamp_format
nls_time_tz_format
nls_timestamp_tz_for
mat
nls_dual_currency
nls_comp binary
nls_length_semantics byte
nls_nchar_conv_excp false
17 rows selected.
--数据库的信息
sql> select * from nls_database_parameters;
parameter value
-------------------- ----------------------------------------
nls_language american
nls_territory america
nls_currency $
nls_iso_currency america
nls_numeric_characte .,
rs
nls_characterset we8mswin1252
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_for dd-mon-rr hh.mi.ssxff am tzr
mat
nls_dual_currency $
nls_comp binary
nls_length_semantics byte
nls_nchar_conv_excp false
nls_nchar_characters al16utf16
et
nls_rdbms_version 11.2.0.3.0
20 rows selected.
sql> select * from v$nls_parameters;
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 we8mswin1252
nls_sort binary
nls_time_format hh.mi.ssxff am
parameter 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_nchar_characterset al16utf16
nls_comp binary
nls_length_semantics byte
nls_nchar_conv_excp false
19 rows selected.
sql>
sql> select * from v$nls_parameters;
parameter value
-------------------------------------------------- ----------------------------------------
nls_language simplified chinese
nls_territory china
nls_currency ？
nls_iso_currency china
nls_numeric_characters .,
nls_calendar gregorian
nls_date_format dd-mon-rr
nls_date_language simplified chinese
nls_characterset we8mswin1252
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 al16utf16
nls_comp binary
nls_length_semantics byte
nls_nchar_conv_excp false
已选择19行。
，