how to insert japanes font in oracle 7.3

[pbmistry]

hi guys,

i have one question i.e how i insert japanese fonts into oracle 7.3 which characterset i set for that give some detail idea.

mistry_pradip&rediffmail.com

Pradip Mistry

[hrishy]

Hello

charcter set :JA16EUC
EUC 24-bit Japanese

character set JA16EUCYEN
EUC 24-bit Japanese with '\' mapped to the Japanese yen character
MB

please refer the oracle documentation manual.

regards
Hrishy

[padmam]

Dear Pradip, 30th Nov 2001 15:45 hrs Mumbai

I woul dlike to know on which application the oracle DB is used.

Any how this Link could throw you good amount of lead .

Please explain your problem in detail in this thread for further help.

http://www.fors.com/eoug97/papers/0515.htm

Cheers

Padmam

[pbmistry]

hi Padmam,

The problem is like this,

We r making a product in that gives to two language support US CHARACTER SET & EUROPEAN CHARACTER SET i.e. we gve language dependent support to customer & now we want to add japanese CHARACTER SET facility to customer.

We have Oracle 7.3 that is our restriction, now i want all the characters set support in one single database i.e US,EUROPEAN,JAPANESE fonts

give in detail which character set i define
like
NLS_LANG
NLS_LANGUAGES
NLS_TERRITORY
& OTHER PARAMETERS

Pradip Mistry

[padmam]

Hi Pradip, 30th Nov 2001 18:19 hrs Mumbai

http://www.fors.com/

The above link is Japanese oracle Support site.

There Just type NLS Language or NLS_LANGUAGE you will get lot of Links which can help you.

For Eg.

http://www.fors.com/orasupp/rdbms/nls/

you can find a link

CHANGING DATABASE CHARACTER SET

http://www.fors.com/orasupp/rdbms/nls/13881_1.HTM

from the above link your Question anser is

Note:
====
Cultural conventions for displaying data are dictated by the NLS parameters NLS_LANGUAGE and NLS_TERRITORY.

Please read the above links and if still you require help put your further doubts in this thread.

Cheers

Padmam

[pbmistry]

[
There are a couple of things to check:

1. Ensure that the NLS_LANG parameter on the client machine, that is running SQL*Plus is set as NLS_LANG=JAPANESE_JAPAN.JA16SJIS
2. If the client machine is a windows 2000 then install the mutli lang pack (to be able to see japanese characters)
3. Go to regional settings the change the default language to japanese
4. invoke SQL*Plus and select the japanese data.