My Oracle Support Banner

Arabic Text Appears As Question Marks '???' After Forms Compilation (Doc ID 785137.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Oracle Forms - Version 10.1.2.0.2 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

When compiling Forms containing Arabic Text typed inside the Form, e.g. for Labels, all Arabic
texts are converted to question marks ‘???’ inside the “fmb” file, and also when running the Forms
on Application Server.

No issue with Arabic data retrieve from Database.

Forms are developed on Windows, and compiled on Unix Server.

Arabic settings were configured on Unix.

When "fmb" file is transferred to Unix, then back to Windows, Arabic text is not affected.

Issue occurs when "fmb" file is compiled on Unix.Arabic Text is seen correctly when the Form is opened in Forms Developer on Windows.

On Windows:
NLS_LANG = AMERICAN_AMERICA.AR8MSWIN1256 in my PC
On Unix:
Forms run with NLS_LANG = AMERICAN_AMERICA.AR8MSWIN1256, set in envFile used.


Steps To Reproduce:
1. Add Arabic text in the Forms source file ".fmb", e.g. for Labels.

2. Move the File to Unix Server.

3. Compile the "fmb" file on Unix Server using "frmcmp.sh".

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
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.