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 ??
Yes, but ** ONLY ** if your present character-set support both languages. Check in the docs WHAT languages your character-set supports.
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)
Click Here to Expand Forum to Full Width