//先查看有关字符集的信息
SQL>col value$ format a40
SQL> select * from nls_database_parameters;
SQL> select * from V$NLS_PARAMETERS;
//查得的主要对应client端的显示
SQL> select * from sys.props$ WHERE NAME='NLS_LANGUAGE';
//可以把'AMERICAN' 改为'SIMPLIFIED CHINESE ',不过这个于本问题无关
//修改字符集
SQL> select * from sys.props$ WHERE NAME='NLS_CHARACTERSET';
SQL>UPDATE sys.PROPS$ SET VALUE$='ZHS16GBK' WHERE NAME='NLS_CHARACTERSET';
SQL>commit;