Storing and Reteriving Data in Japanese

Hello All,
I am working with Oracle 8i(8.1.7) database,OS is Windows(using English Language).I created a database on this machine to store Japanese data.During my creation of database i seleced UTF-8 as database character set and NLS_NCHAR_NCHARACTERSET as J16EUC(in anticipation that it is Japanese character set).Before this database creation,i was having another database on my machine with characterser as WE8ISO8859P1.But my NLS_LANG entry is still having only one entry as AMERICAN_AMERICA.WE8ISO8859P1.
Finally, my problem is that how i can store and reterive Japanese data from thie new database.My type of solution will be great help for me.
BRegards
Kapil

Go to REGEDIT under HKEY_LOCAL_MACHINE-->SOFTWARE-->ORACLE-->Here in NLS_LANG u can change Character set as per your need.

I already have changed NSL_LANG to Japanese.Still when i try to wtite say a insert into a table (say)Emp with empno and ename as
insert into emp values(1,'‚½‚ß‚ÄŽg‚¦‚éYahoo!ƒ|ƒCƒ“ƒg').
when i try to extract it shows ename as ???Yahoo??.
Can u suggest how i can say same when selecting from emp.

see in this box i entered certain japanese characters as ename in my previous post but its showing Garbag values.

insert into emp values(1,'say Japanese Characters');
but i am getting garbage.

can u post the NLS_LANG settings from REGEDIT.Under Oracle u will find NLS_LANG at 3 locations.Did u changed all of them.
Also look into the following link.
http://asktom.oracle.com/pls/ask/f?p...5783936214008,

My NLS_LANG value earlier as one place was AMERICAN_AMERICA.WE8ISO8859P1 and at other two places it was NA.now i have changed at all the places as Japanese_Japan.UTF8.I have restarted my database as well,still i can't see or store the database in Japanese.My OS is english based.So how i can store and reterive data from my database in Japanese Language.

There u are.Since your OS is pure english that's why it is not able to display japanese character set even though u are setting NLS_LANG settings.Use the OS which is japanese enabled i hope that your problem will be solved.

Check the following link which describes exactly your problem.
http://metalink.oracle.com/metalink/...p_id=11697.996

Hi,

You change your character set to UTF 8 or UTF 32. You must use win2000 having multilingual support. Change your regional setting to japanes and install fonts munch related fonts into your machine. after doing this go to sql prompt then you can see japanese fonts into your sql promp.(your OS must be in japanese).

Thanks akhadar and pbmistry,both of you given me new direction to think,i have to now check Japanese version of Windows,tough to find,still thanks to both of you.

Another query that is coming to my mind,if i choose Japanese OS,till i will be able to work with English data as well?I want to save and see both English as well as Japanese data.Is it possible.Or i should be able to store japanese data even if i am not able to see it.But finally my application is going to show data in browser(for english and japanese).How is that possible?

Quote:

---

your OS must be in japanese

---

I can't agree with that. Your OS no need to be in Japanese. The key point is NLS_LANG setting in your client and your client PC should be able to show Japanese character. I implement quite few this kind of databases for China and Japan users. My OS is pure English, character set of databse is UTF8.

Hello xiaomao
My NLS_LANG setting is Japanese_Japan.UTF8.I am working on Server,that is its NLS_LANG.then can u elaborate how i can insert and later reterieve Japanese data using English OS.Any kind of suggestion will be great help to me.
Regards
Kapil

My DB is running on UNIX server that is pure English OS without any ability to display Chinese or Japanese character. If I retrieve Japanese character data from server side,it will show as ???. My database character set is AMERICAN_AMERICA.UTF8. This database is used to store English as well as multi-byte Asian Characters, like Chinese, Japanese,etc.

Users receive/display data on client machines through applications, sqlplus and other tools. For our Japan users, they need to set NLS_LANG=Japanese_Japan.JA16SJIS.Please note, their client machines/PCs are Japanese character support/enabled, which means their PCs know how to display and input Japanese character. This can
be done by installing some Japanese software, e.g. Japanese Windows. You also need to install some Japanese font to display Japanese language.

Your case is almost the same as my home PC. My home PC is English OS with database created with UTF8. I can store/retrieve Chinese character because I have some software installed to support Chinese character. I also need to set NLS_LANG to ZHS16GBK before I invoke sqlplus. In your case, you only need make sure it can hanlde Japanese character and set NLS_LANG=Japanese_Japan.JA16SJIS before run any application or sqlplus.

To check whether you have NLS_LANG set after invoking SQLPLUS, you can do:

C:\>set NLS_LANG=Japanese_Japan.JA16SJIS
C:\>sqlplus test/test@icare2

SQL*Plus: Release 10.1.0.2.0 - Production on û╪ 9îÄ 9 14:29:39 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

TEST 04-09-09 SQL>host echo %NLS_LANG%
Japanese_Japan.JA16SJIS

TEST 04-09-09 SQL>

I unset NLS_LANG and use the value from windows registry:

C:\>sqlplus test/test@icare2
SQL*Plus: Release 10.1.0.2.0 - Production on Thu Sep 9 14:38:10 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

TEST 09-SEP-04 SQL>host echo %NLS_LANG%
%NLS_LANG% --------------it shows no NLS_LANG set

TEST 09-SEP-04 SQL>@.[%NLS_LANG%].
SP2-0310: unable to open file ".[AMERICAN_AMERICA.WE8MSWIN1252]..sql"
----------------- Here AMERICAN_AMERICA.WE8MSWIN1252 is the NLS_LANG setting from windows registry.

TEST 09-SEP-04 SQL>


Help this can help.

Hi,

You can select both japanese and english in the regional setting, after doing this you can see both the character set without using japanese OS and you must have MS Mincho fonts installed in your machine this will installed by your machine automatically.

If you have further doubt mail me
[email protected]