Home > IT Answers > Oracle > NLS Parameters, Character Set Selection for Saudi Arabia
Abkeyte
0 pts.
 NLS Parameters, Character Set Selection for Saudi Arabia
Installation/Upgrade, Oracle 9i
HI, 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.

Software/Hardware used:
ASKED: May 12, 2004  12:58 PM
UPDATED: May 21, 2004  11:01 AM
RELATED QUESTIONS
Answer Wiki:
I do not have the specific answer to your questions but the Globalization Guide in the 9.2 documentation set seems to address these points pretty concisely. It can be found at: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/toc.htm
Last Wiki Answer Submitted:  May 13, 2004  2:05 pm  by  Jrmills   0 pts.
All Answer Wiki Contributors:  Jrmills   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks JR!

I have reviewed that document and nearly everything else I can find on the subject (and, that’s alot of documentation).

Just for gp’s, here’s what we did:

We set the character set to AL32UTF8 and the national character set to AL16UTF16 (which is the default for 9i) for the database, and will set the NLS_LANG variable on the client side to AMERICAN_AMERICA.AR8MSWIN1256.

Abkeyte
 0 pts.