Question

  Asked: May 12 2004   12:58 AM GMT
  Asked by: abkeyte


NLS Parameters, Character Set Selection for Saudi Arabia


Oracle 9i, Installation/Upgrade

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

abkeyte  |   May 21 2004  11:01AM GMT

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.