Thread: NLS
-
Hello,every one here
My database server is under Windows 2000(Japanese). and my client is Windows 98(Japanese).
when I query from data dictionary , I got following:
select * from NLS_INSTANCE_PARAMETERS
PARAMETER VALUE
--------- -----
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
select * from NLS_DATABASE_PARAMETERS
PARAMETER VALUE
--------- -----
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
select * from NLS_SESSION_PARAMETERS
PARAMETER VALUE
--------- -----
NLS_LANGUAGE JAPANESE
NLS_TERRITORY JAPAN
As you see, only parameters in session view were for Japanese.
I don't know what Oracle do for it. And how can I make all sessions use English instead of Japanese or vice versa.
I do not means using Alter session command to do it.
Is there anyone would clarify it for me?
Thank you in advance.
-
add in regedit, where Oracle resides
NLS_LANGUAGE AMERICAN_AMERICA.WE8ISO8859P1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|