SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Insert Chinese characters in Japanese Database

user546710Sep 11 2007 — edited Sep 11 2007

Hi all,

I am having following characteristics on my computer

Machine OS --Windows Server 2003
OS language --Japanese

Oracle
Oracle9i Release 9.2.0.1.0 - Production
NLS_LANGUAGE JAPANESE
NLS_CHARACTERSET JA16SJIS

Now, i want to insert into database chinese characters. Please guide me how to do the following thing.

How to insert chinese characters on local machine and if i want to insert on the remote databse (i can not create database link for remote database). I have to send batch file or SQL file and they will execute it on their side.

if i use this command
alter session set nls_language = "SIMPLIFIED CHINESE"
and then insert the records and revert back to japanese character set. Is this correct way....?

Thanks in advance,
Pal

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2007

Added on Sep 11 2007

4 comments

398 views