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 AMERICAN_AMERICA.AR8MSWIN1256 #Update
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...
