DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: NLS

  1. #1
    Join Date
    Oct 2000
    Posts
    23
    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.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  


Click Here to Expand Forum to Full Width