Re: Configuring my machine for Arabic(multi-lingual) in Oracle

You may need to determine what database character set the database was built with.

The database may need to have been built as having an "AL32UTF8" character set (NLS_CHARACTERSET parameter). It could be sitting at something like "US7ASCII".

Hope this helps.

SYSTEM_at_NGDV>list
  1 select substrb (parameter,1,30) parameter,   2 substrb (value,1,30) value
  3 from v$nls_parameters
  4* order by parameter
SYSTEM_at_NGDV>/

PARAMETER                      VALUE


------------------------------ ------------------------------

NLS_CALENDAR                   GREGORIAN
NLS_CHARACTERSET               AL32UTF8
NLS_COMP                       BINARY
NLS_CURRENCY                   $
NLS_DATE_FORMAT                MM/DD/YYYY HH24:MI:SS
NLS_DATE_LANGUAGE              AMERICAN
NLS_DUAL_CURRENCY              $
NLS_ISO_CURRENCY               AMERICA
NLS_LANGUAGE                   AMERICAN
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CHARACTERSET         AL16UTF16

PARAMETER                      VALUE


------------------------------ ------------------------------

NLS_NCHAR_CONV_EXCP            FALSE
NLS_NUMERIC_CHARACTERS         .,
NLS_SORT                       BINARY
NLS_TERRITORY                  AMERICA
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR

19 rows selected. Received on Wed Jan 28 2015 - 17:03:25 CET