Dear Friend
I have installed Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
And when I install the database I choose character set as Arabic AR8MSWIN1256
character set AR8MSWIN1256
when I see the Arabic characters in the server and in the form it will be showing as ?????(junk)
and when I import the tables it display the following message :
import done in WE8MSWIN1256 character set and AL16UTF16 NCHAR CHARACTER SET
IMPORT SERVER USES AR8MSWIN1256 CHARACTER SET
<POSSIBLE CHARSET CONVERSION>
EXPORT CLIENT USES AR8MWIN1256 CHARACTER SET
<POSSIBLE CHARSET CONVERSION>
EXPORT SERVER USES UTF8 NCHAR CHARACTER SET
<POSSIBLE CHARSET CONVERSION>
And this is the setting in my server :
SQL> 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
PARAMETER VALUE
------------------------------ ----------------------------------------
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 9.0.1.1.1
20 rows selected.
Waiting for your valuable replay with examples please
Best regards
Jamil Alshaibani