language other then english- NLS_LANGUAGE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: language other then english- NLS_LANGUAGE

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    I had a requirement of storing documents of different language in database.
    How oracle will store my documents
    Can I retrive documents of other language. not changing nls parameter ?

    Will any body share experince ??

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    Yes, but ** ONLY ** if your present character-set support both languages. Check in the docs WHAT languages your character-set supports.

    Regards,

    Chiappa

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    1. u should create:
    - database with particular character set, that support both languages (if u have oracle 8.1.6 and less)
    - 2 different tablespaces for each language, that support need language
    (if u have oracle 8.1.7 and more) and place 2 (or more, as u need tables, that depended from language in different tablespaces)

    2. u should tune environment in client boxes, that should use 2 languages.
    - NLS_LANG variable (language, territory, charset)

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