Arabic Text Appears As Question Marks '???' After Forms Compilation [ID 785137.1]

		修改时间 02-MAR-2009 类型 PROBLEM 状态 PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:

Oracle Forms - Version: 10.1.2.0.2 to 10.1.2.3.0
This problem can occur on 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 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.

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

NLS_LANG is not set correctly in the compilation environment.

When compiling Forms, NLS_LANG should be set properly in the Environment to match the characterset
used by Arabic letters.

Solution

1. Please add the following in your "frmcmp_batch.sh" script.

NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256
export NLS_LANG

2. Compile the Forms using the new "frmcmp_batch.sh" script.

References

NOTE:360819.1 - Cannot Compile Forms Module On Unix FRM-91500
NOTE:207948.1 - How to use Arabic Windows Character Set AR8MSIWN1256 with UNIX and Motif

显示相关信息 相关的

产品

Middleware > Developer Tools > Database & PLSQL > Oracle Forms

关键字

COMPILE FORMS; CHARACTERSET; ENVFILE; AR8MSWIN1256; FRMCMP.SH

ITPub博客

Arabic Text Appears As Question Marks '???' After Forms Compilation

Applies to:

Symptoms

Cause

Solution

References

最新文章