OraFAQ Forum: Japanese » how to change the database language to JAPANESE

Home » Non-English Forums » Japanese » how to change the database language to JAPANESE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to change the database language to JAPANESE [message #366070]

Wed, 01 November 2000 03:44

Arunava Maity
Messages: 2
Registered: November 2000

Junior Member

Hi all,
Please help me out.How to change the database language to japanese.
thanx in advance

Report message to a moderator

Re: how to change the database language to JAPANESE [message #366078 is a reply to message #366070]

Tue, 07 November 2000 01:04

Indira Morishetty
Messages: 9
Registered: November 2000

Junior Member

Hope the following procedure may help you. Some time back I changed my DB character set from US7ASCII to UTF8 which supports Japanese.

Constraint here is that the new character set should be the super set of old character set.

In the above case, UTF8 is super set of US7ASCII, So I could do it.

SHUTDOWN IMMEDIATE; -- Normal
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET new_character_set_name; -- Do not enclose the character set in quotes
ALTER DATABASE NATIONAL CHARACTER SET new_character_set_name; -- Do not enclose the character set in quotes
SHUTDOWN IMMEDIATE; -- or NORMAL
STARTUP;

Indira Morishetty
Hyderabad
India

Report message to a moderator

Re: how to change the database language to JAPANESE [message #366113 is a reply to message #366070]

Thu, 23 November 2000 01:29

Srinivas Voruganti
Messages: 1
Registered: November 2000

Junior Member

Does the same procedure holds good for other languages too?
I would appreciate if u can offer yr renarks.
Thx
Srinivas
Denver,CO
USA

Report message to a moderator

Re: how to change the database language to JAPANESE [message #366114 is a reply to message #366113]

Thu, 23 November 2000 01:38

Indira Morishetty
Messages: 9
Registered: November 2000

Junior Member

I think I mentioned the constraint clearly in my previous reply. If the situation supports that condition, you can definitely do that.

And the new character set is going to be applicable for new insertions only.

Report message to a moderator

Next Topic:

Inserting Japanese data into Oracle via VB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 01:52:16 CST 2024