My client want to store data in English but for reporting they need some reports in Farsi(Persian) character.
How can i achieve this in database? Is i need to install two different database one for English & other one for Farsi(Import/Export purpose).
Kindly guide, i am doing this first time. For Farsi character which CHARACTER set i used.
I am using database 10.2.0.1.0 in Windows environment.
Pl see this MOS Doc for the database characterset you need to use -
Does Oracle support the Farsi / Persian language (used in Iran, Afghanistan, Tajikistan, ....)? [ID 274108.1]
If you use the listed charactersets, the database will be able to store both English and Farsi content. It will be up to you (or some code) to provide the translations