Arabic characters shows ¿¿¿¿¿¿ using sqlplus
904636Dec 11 2011 — edited Dec 12 2011Dear All,
As I installed Oracle 11gR2 on Windows 2008 with Arabic language package , created DB and import data from another existing database it contains both Arabic and English characters inside database tables.
Note : Inserting new record using forms accepting Arabic characters whereas selecting same row through shows "¿¿¿¿¿¿" due to Arabic keys enable.
selecting Arabic characters from sqlplus shows
select insured_name from schema Name.Table Name;
¿¿¿¿¿¿
My registry NLS_lang= American_America.AR8MSWIN1256
SELECT * FROM NLS_DATABASE_PARAMETERS;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AR8MSWIN1256
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 AR8MSWIN1256
NLS_RDBMS_VERSION 11.2.0.1.0
Please need your inputs.
Thanks in advance.
Regards
Riyaz