Question

suse linux下oracle中文显示成问号，怎样修改oracle编码

操作系统是suse linux enterprise desktop 10,oracle是 10g。
suse有的中文显示问号。oracle插入中文后查询得到的是问号。
suse下RC_LANG和RC_LC_ALL是zh_CN.GB2312.
oracle通过select name,value$ from props$ where name like '%NLS%';
查的NLS_NCHAR_CHARACTERSET
AL16UTF16
启动监听后，通过sqlplus / as sysdba登陆oracle，执行如下：
startup;
shutdown immediate;
startup mount;
alter system enable restricted session;
alter system set job_queue_processes=0;
alter database open;
alter database character set internal_convert zhs16gbk;
可是改不过来，请高手指教。

Answer 1

可以通过以下固定用法实现：
sql> conn / as sysdba;
sql> shutdown immediate;
database closed.
　　database dismounted.
　　oracle instance shut down.
　　sql> startup mount;
　　oracle instance started.
　　total system global area 135337420 bytes
　　fixed size 452044 bytes
　　variable size 109051904 bytes
　　database buffers 25165824 bytes
　　redo buffers 667648 bytes
　　database mounted.
sql> alter system enable restricted session;
　　system altered.
sql> alter system set job_queue_processes=0;
　　system altered.
sql> alter system set aq_tm_processes=0;
　　system altered.
sql> alter database open;
　　database altered.
sql> alter database character set internal_use CHINESE_CHINA.AL32UTF8;
sql> shutdown immediate;
sql> startup;
备注：具体的编码格式根据实际需要修改即可，推荐UTF-8（默认是GBK）。

Answer 2

utf8:
ALTER DATABASE `数据库` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

ALTER TABLE `数据表` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

gbk (包含gb2312):

ALTER DATABASE `数据库` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci

ALTER TABLE `数据表` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci

Answer 3

alter database character set internal_use JA16SJIS;

Answer 4

重新创建一个数据库，选择ZHS16GBK呢？