确定服务器端字符集和客户端字符集相同,客户端字符集环境变量为$NLS_LANG
服务器端字符集查询方法先登以dba登录到sqlplus,执行select * from v$nls_parameters where parameter='NLS_CHARACTERSET';或select userenv('language') from dual;服务器端字符集修改方法
SQL> shutdown immediate; SQL> startup mount; SQL> alter system enable restricted session; SQL> alter system set job_queue_processes=0; SQL> alter database open; SQL> alter database character set internal_use UTF8; SQL> shutdown immediate; SQL> startup注意:虽然客户端字符集与服务器端字符集一致,但若shell所用字符集与服务器端字符集不一致时,从
sqlplus 中查询出来显示也是为乱码。