Arabic Text Appears As Question Marks '???' After Forms Compilation
Last updated on JULY 24, 2012
Applies to:Oracle Forms - Version 10.1.2.0.2 to 11.0.0 [Release Oracle10g to 11.0.0]
Information in this document applies to any platform.
Checked for relevance 10-JAN-2011
Checked for relevance 23-Jul-2012
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 following the <Note 207948.1> How to use Arabic Windows Character Set AR8MSIWN1256 with UNIX and Motif
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.
NLS_LANG = AMERICAN_AMERICA.AR8MSWIN1256 in my PC
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".
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms