1)服务器端:select name,value$ from props$;
查看服务器字符集
注:若要修改服务器字符集:
1. shutdowm immediate
2. STARTUP MOUNT;
3. ALTER SYSTEM ENABLE RESTRICTED SESSION;
4. ALTER DATABASE OPEN;
5. ALTER DATABASE CHARACTER SET ZHS16GBK;
ALTER DATABASE national CHARACTER SET ZHS16GBK;
6. 10g中: alter database character set internal_convert zhs16gbk;
2)客户端:
export LANG=zh_CN.GBK //这个是linux的字符集设置
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK //这个是oracle的字符集设置