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!

NLS_CHARACTERSET From WE8ISO8859P1 to Arabic Suuported NLS_CHARACTERSET

688489Sep 13 2009 — edited Sep 14 2009

Hi Gurus..

we use Oracle 10g on HP-Unix
RDBMS_VERSION 10.2.0.1.0

We wanted the Database to Support Arabic Language as well,

Current NLS_PARAMETER

PARAMETER VALUE
------------------------------ --------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.1.0

To what Character Set NLS_CHARACTERSET to be changed So as the Database to Support Arabic Langauge as well,
Which NLS_CHARACTERSET IS Best Suport for Arabic
We have to Change From WE8ISO8859P1

please Help

thanks All

Khaja

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2009

Added on Sep 13 2009

#database-key-features, #globalization-support

6 comments

6,787 views