NLS LANGUAGE: How to set it?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: NLS LANGUAGE: How to set it?

  1. #1
    Join Date
    Jul 2003
    Posts
    134

    NLS LANGUAGE: How to set it?

    Guys, I have a few questions, could you please help me.

    1) How do I change the NLS_LANGUAGE to SPANISH from the existing one?

    2) By changing the NLS_LANGUAGE to SPANISH, would the data also get changed to SPANISH? What does NLS_LANGUAGE control?

    Kindly help me guys...

    Vipassana

  2. #2
    Join Date
    Jul 2003
    Posts
    134
    BTW I'm using Oracle 9i on Win 2000.

  3. #3
    Join Date
    May 2001
    Posts
    736
    1.NLS_LANG settings can be changed from your control pannel-->regional settings.
    2.IT is no way connected to your database data.

    Take a look in to oracle documentation.

  4. #4
    Join Date
    Jul 2003
    Posts
    134
    Originally posted by akhadar
    1.NLS_LANG settings can be changed from your control pannel-->regional settings.
    2.IT is no way connected to your database data.

    Take a look in to oracle documentation.
    So then why do we have parameters like NLS_LANGUAGE?

  5. #5
    Join Date
    Jul 2003
    Posts
    134
    I am using ALTER SESSION SET NLS_LANGUAGE = SPANISH; it says "session altered". But the server messages remains the same in English. I mean if I say ROLLBACK after this command, it gives "Rollback Complete"...it must have given that in Spanish right?

    Am I missing anything, need your input guys...

  6. #6
    Join Date
    May 2001
    Posts
    736
    Go to Registry.There HKEY_LOCAL_MACHINE -->SOFTWARE-->ORACLE-->where ever u will find NLS_LANG u can use SPANISH and all your messages will be in spanish.
    Note:For English we use MAERICAN_AMERIA but i don't know what will be used for spanish.

  7. #7
    Join Date
    Jul 2003
    Posts
    134
    I am a little amazed that with so many gurus out here, no one could give me a straight answer to my Qs ...

    I am trying with docs and metalink, nothin seems to be working. If someone feels they shd extend their hand to help, pls feel free to do so.

  8. #8
    Join Date
    Aug 2003
    Location
    Dhahran
    Posts
    33
    All the people who are offering solutions are doing it on a volunteer basis. I expect there is a filtering effect - they respond to the questions that they are interested in or which can be handled without doing any special research. If someone out there already knows the answer to your question and can spare a minute to type it in, that's good for you. But if someone has to do special research to answer your question it might as well be you. If it is someone else then it would be only because they are interested in the question too and want to trust the results.

    Perhaps the question just isn't interesting enough to guru class.

  9. #9
    Join Date
    May 2001
    Posts
    736
    Do us little favour
    Go through this link
    http://my.kharkov.org/docs/oracle/nt.816/a73010/apb.htm

    Here it is mentioned how to set up your NLS_LANG settings (including spanish)

  10. #10
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    After a short research I found this:
    To see server messages in a language you have set in NLS_LANGUAGE parameter, you need appropriate files in the ORACLE_HOME\RDBMS\MESG directory. These files use convention <product_id><language_abbrev>.MSB.

    If you don't have appropriate files there, you'll see the messages in English. I guess you need specify Spanish during Oracle install to have the files there.
    Ales
    The whole difference between a little boy and an adult man is the price of toys

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