Settings For Arabic Urdu Support Work ((better)) | Oracle Database 10g Developer 6i

Go to: System Properties → Advanced → Environment Variables → System variables → New

A 8-bit character set specific to Windows Arabic/Urdu encoding. Use this only if your entire ecosystem is strictly Windows-based and legacy. Go to: System Properties → Advanced → Environment

SELECT * FROM nls_database_parameters WHERE parameter='NLS_CHARACTERSET'; Changing Settings: the corresponding value is AMERICAN_AMERICA.AR8MSWIN1256 .

The NLS_LANG parameter is the most critical setting. It tells the Developer 6i runtime how to encode and decode data sent to the database. This must be set in the Windows Registry of the client machine. Open the (regedit). Go to: System Properties → Advanced → Environment

If you must use the legacy AR8MSWIN1256 database character set, the corresponding value is AMERICAN_AMERICA.AR8MSWIN1256 .