NLS Parameters, Character Set Selection for Saudi Arabia

pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Abkeyte
    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.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following