QUESTION:about data type convert

From: <epeppanda_at_yahoo.com.cn>
Date: 16 Jan 2006 00:44:22 -0800
Message-ID: <1137401062.707467.118310@g49g2000cwa.googlegroups.com>

I want convert NVARCHAR2 to VARCHAR2,fail in oracle 8.1.6, but succeed in oracle 9.2.0;
this is my tables,for same sentence like this : SQL> desc n1

Name                                      Null?    Type


----------------------------------------- --------

---------------------

NVAR                                               NVARCHAR2(20)

SQL> desc n2
Name                                      Null?    Type


----------------------------------------- --------

---------------------

NVAR                                               VARCHAR2(20)

I convert it like this :
SQL> insert into n2(nvar) select nvar from n1; insert into n2(nvar) select nvar from n1

                            *

ERROR at line 1:
ORA-12704: character set mismatch

how can I implement under oracle 8.1.6 Received on Mon Jan 16 2006 - 02:44:22 CST