During upgrade to Forms 10g we faced an issue with Arabic data because of mapping issue between Windows Arabic Encoding (AMERICAN_AMERICA.AR8MSWIN1256) and ISO Arabic Encoding (AMERICAN_AMERICA.AR8ISO8859P6).
The underlying code-page for the existing data in database server is Windows Arabic Encoding(AR8MSWIN1256 or cp1256). Since the NLS Charset for Database is set as ‘AR8ISO8859P6’, the data when retrieved from Web based Oracle Form application shows garbage value.
We tried to set Arabic Window Encoding in application server level (In file default.env added NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256) but still it does not show the correct value.
However, when we perform an explicit CONVERT (SQL function) from AR8ISO8859P6 to AR8MSWIN1256 the data is displayed properly. But this is not proper solution as data inserted from web forms will show garbage in client server system (like SQL PLUS, FORMS 6i).
At this stage we cannot change the DB NLS Charset and hence pls. suggest us a suitable solution to fix this issue. You may open a service request to Oracle for this issue.
Do let us know for any further clarifications needed.