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
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.