My Oracle Support Banner

Arabic Data Stored In The Database Is Not Shown Correctly After Upgrading To The Web (Doc ID 577599.1)

Last updated on APRIL 08, 2020

Applies to:

Oracle Forms - Version 10.1.2.0.2 to 11.0.0 [Release Oracle10g to 11.0.0]
z*OBSOLETE: Microsoft Windows
Checked for relevance 21-JUL-2011


Symptoms

After upgrading to Forms on the web, Arabic data queried from the database is not displayed correctly. Data is shown in Arabic, however, some Arabic characters are not displayed correctly, the characters are replaced with different other Arabic characters, causing the Arabic data to be meaningless.

When querying the data from SQL*Plus or from Forms 6i client/server,  the data is displayed correctly.

This Data was inserted using Oracle Forms 6i and the client NLS_LANG was set to <language>_<territory>.AR8ISO885P6 and the database character ser was set also to AR8ISO885P6.

Changes

Using Forms on the web.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.