Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What Character set & NLSLANG to use for Saudi Arabia?

223556May 12 2004 — edited May 16 2004

I'm looking for some advice on setting the character set and NLSLANG variables for a data warehouse in Saudi Arabia.

The entire implementation is in English, except the patient names that will be stored as both English and Arabic Characters. The Dates are displayed using both Hijri and Gregorian formats. All of the reporting from the Data Warehouse is expected in English characters.

We feel we would probably go with an UTF8 character set as we're developing a product that will need to run in a variety of locales.

We're thinking to set the database character set to al32utf8, the national character set to al16utf16.

On the client machines, we'll set
NLSLANG=arabic_saudi_arabia.ar8mswin1256.

Will this give us what we're looking for?

I'd appreciate any and all feedback on this.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2004

Added on May 12 2004

#database-key-features, #globalization-support

4 comments

1,209 views