Hasan Jawaid: Configure Urdu language in Oracle

Saturday 20 July 2019

Download Urdu support installer for your platform from :

after installation/restart, you get urdu icon in taskbar (a language bar)

then you can write urdu anywhere like notepad, wordpad, ms word etc etc

make sure you have OS install CD before proceeding with install!

after that create your oracle database , database locale should be utf-8 / unicode

i think there is nvarchar field that is capable of handling unicode in oracle

To Change the NLS Setting for Oracle Environment / Forms Environment In (Win95/NT/2000 client ) by using the blow details .

Title : NLS Setting for Oracle Environment:

You can change database character set by doing the following steps.

Login to oracle Database server as sys privilege. If Sys Is Primary User otherwise Login to oracle Database server as system privilege.

Step1 : connect sys@Database_Name as sysdba;

Step2 : shutdown immediate;

Step3 : startup mount;

Step4 : alter system enable restricted session;

Step5 : alter system set job_queue_processes=0;

Step6 : alter system set aq_tm_processes=0;

Step7 : alter database open;

Step8 : alter database Database_Name character set AR8MSWIN1256;

Step9 : alter database Database_Name national character set AR8MSWIN1256;

Step10 : shutdown immediate;

Step11 : startup;

Title : Check Current Database Character:

Step1: Select * from v$nls_parameters;

Step2: select * from nls_database_parameters;

Title : NLS Setting for Forms Environment :

Step1 : Run regedit, Registry window will appears

Step2 : Select HKEY_LOCAL_MACHINE

Step3 : Select SOFTWARE

Step4 : Select ORACLE

Step5 : Select NLS_LANG .(Its Available In right Side)

Step6 : Double Click NLS_LANG and then enter the value as AMERICAN_AMERICA.AR8MSWIN1256

Hasan Jawaid