Store and Query Arabic Name in PeopleSoft Oracle database
784531Jul 12 2010 — edited Jul 12 2010I am trying to retrieve and display Arabic data within our production Oracle/PeopleSoft/Sun database. Our production database is not unicode and can not be converted to unicode. I created a small unicode database holding one record with an identification field and an nvarchar2 field which holds the student's name in Arabic. I created a dblink between our production database and the unicode database, and also defined the record with the identification field and the nvarchar2 field in our production database. I hoped to store the Arabic name in the unicode database, then just create a view through the dblink to display the Arabic name in our production database. However, all I get is question marks. The client has the arabic language installed and the region and locale is defined as QATAR. The client default font is Traditional Arabic, which holds all the arabic and english alphabet characters. When I run the sql: select * from NLS_DATABASE_PARAMETERS, I get the following.
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET US7ASCII
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 TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_LENGTH_SEMANTICS BYTE
NLS_SAVED_NCHAR_CS US7ASCII
NLS_NCHAR_CONV_EXCP FALSE
NLS_RDBMS_VERSION 10.2.0.4.0
I really do need help. I've tried everything I can think of. Thank you in advance for your help.
Carmen