查询服务器用户字符集:select userenv('LANGUAGE') From dual
查询结果:AMERICAN_AMERICA.ZHS16GBK
设置系统变量名:NLS_LANG,变量值:AMERICAN_AMERICA.ZHS16GBK
重启电脑
服务器字符集:
select * from nls_database_parameters
NLS_LANG = language_territory.charset
NLS_LANG = NLS_LANGUAGE||NLS_TERRITORY||NLS_CHARACTERSET
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
客户端字符集环境
select * from v$version
查询结果:AMERICAN_AMERICA.ZHS16GBK
设置系统变量名:NLS_LANG,变量值:AMERICAN_AMERICA.ZHS16GBK
重启电脑
服务器字符集:
select * from nls_database_parameters
NLS_LANG = language_territory.charset
NLS_LANG = NLS_LANGUAGE||NLS_TERRITORY||NLS_CHARACTERSET
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
客户端字符集环境
select * from nls_instance_parameters
查看数据库版本:select * from v$version