Please HELP.....Problem storing Chinese in Oracle 8.0.5
Date: 2000/06/09
Message-ID: <8hqh3n$7hj13_at_imsp212.netvigator.com>#1/1
I have set up a database to support Chinese characters with the following
DML. When
SQL> insert into chinese_test values('a',1,'§A¦n¶Ü','§Ú«Ü¦n');
insert into chinese_test values('a',1,'§A¦n¶Ü','§Ú«Ü¦n')
I tried to insert chinese to a NVARCHAR2 column via sqlplus and
PowerBuilder, I got
*
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)
Received on Fri Jun 09 2000 - 00:00:00 CEST