Oracle 10g Arabic Character

When you enter Arabic data into  Data Base and retrieve it , you may face many errors like displaying Arabic fonts in " ???"  or any other unknown format.

Here's the way solve it :

 1. Run then  REGEDIT  then  Search for NLS_LANG then REPLACE any existing value with  ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256
2.CONTROL PANEL the   REGIONAL and LANGUAGE then ADMINISTRATIVE then CHANGE SYSTEM LOCAL to ARABIC then OK then reboot..

3.RUN then SQL PLUS then SYS/SYS as SYSDBA then OK then run the following commands:

SHUTDOWN IMMEDIATE;

 STARTUP MOUNT; 

 ALTER SYSTEM ENABLE RESTRICTED SESSION; 

 ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; 

 ALTER SYSTEM SET AQ_TM_PROCESSES=0; 

 ALTER DATABASE OPEN;

ALTER DATABASE CHARACTER SET internal_use AR8MSWIN1256 ;

ALTER DATABASE CHARACTER SET AR8MSWIN1256;

ALTER DATABASE NATIONAL CHARACTER SET AL32UTF8;

SHUTDOWN IMMEDIATE; -- or SHUTDOWN NORMAL;

STARTUP RESTRICT;

STARTUP;

STARTUP FORCE;

4. Now it should run correctly and display Arabic language without errors.

hoping it helps you.

enjoy...