I need to create a data warehouse in Saudi Arabia, on Oracle 9.2.0. The database will store almost everything in English, but will need to store Arabic names in Arabic, and will need to handle both gregorian and hijri date formats and display them correctly. This same database may later need to support Chinese and Japanese.
What character set and national character set would be best for this? Also, what would you set NLSLANG to on the client side, running Microsoft Windows.