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

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博客 ” ,链接:http://blog.itpub.net/24067357/viewspace-673210/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/24067357/viewspace-673210/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值