Oracle Database 10g Developer 6i Settings For Arabic Urdu Support Work Review

Use VARCHAR2 columns (not NVARCHAR2 unless using AL16UTF16). Insert as normal:

CREATE TABLE employees ( id NUMBER, full_name NVARCHAR2(100), -- Unicode address VARCHAR2(200 CHAR) -- Character-length semantics ); Use VARCHAR2 columns (not NVARCHAR2 unless using AL16UTF16)

The most critical setting is the NLS_LANG parameter in the Windows Registry. This tells Developer 6i how to interpret the data coming from the database. Writing Urdu or Arabic in Oracle Forms 6i always use NCLOB or NVARCHAR2 :

If you need to change an existing DB:

When creating tables for Urdu documents or names, always use NCLOB or NVARCHAR2 : Use VARCHAR2 columns (not NVARCHAR2 unless using AL16UTF16)