生僻字乱码

zyrf2001

字符集采用了ZHS16GBK，遇到生僻字还是乱码，求解


C:\Users\ZCL>sqlplus ****/******@orcl120

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 23 22:22:00 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>  select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK

SQL> create table tmp_shengpizi (a varchar2(255));

Table created.

SQL> insert into tmp_shengpizi values ('䶮');

1 row created.

SQL> select * from tmp_shengpizi;

A
--------------------------------------------------------------------------------

?

SQL> create table tmp_shengpizi2 (a nvarchar2(255));

Table created.

SQL> insert into tmp_shengpizi2 values ('䶮');

1 row created.

SQL> select * from tmp_shengpizi2;

A
--------------------------------------------------------------------------------

?

panyuan520

学习啦。。。