language other then english- NLS_LANGUAGE

[Kumud]

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 ??

[JChiappa]

Yes, but ** ONLY ** if your present character-set support both languages. Check in the docs WHAT languages your character-set supports.

Regards,

Chiappa

[Shestakov]

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)