Re: Please HELP.....Problem storing Chinese in Oracle 8.0.5

In article <8hqh3n$7hj13_at_imsp212.netvigator.com>,   "Kit" <pashwawa_at_hotmail.com> wrote:
> I have set up a database to support Chinese characters with the
 following
> DML. When
> I tried to insert chinese to a NVARCHAR2 column via sqlplus and
> PowerBuilder, I got
>
> SQL> insert into chinese_test values('a',1,'§A¦n¶Ü','§Ú«Ü¦n');
> insert into chinese_test values('a',1,'§A¦n¶Ü','§Ú«Ü¦n')
> *
> ERROR at line 1:
> ORA-12704: character set mismatch
>
> The characters might not be ligible as i dont think SQLPLUS supports
 the
> display of Chinese.
>
> Any help would be GREATLY appreciated.
>
> Kit..
>
> ---------
> CREATE DATABASE big5
> .
> .
> .
> CHARACTER SET US7ASCII
> NATIONAL CHARACTER SET ZHT16BIG5;
> ----------
>
> Name Null? Type
> ------------------------------- -------- ----
> SOME_CHAR NOT NULL VARCHAR2(10)
> SOME_NUMBER NOT NULL NUMBER(6)
> SOME_CHINESE1 NOT NULL NVARCHAR2(30)
> SOME_CHINESE2 NOT NULL NVARCHAR2(60)
>
>
You´ll need to use N'§A¦n¶Ü',N'§Ú«Ü¦n'

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.