Skip to Main Content
  • Questions
  • Compile file *.fmb, *.mmb wih unicode!

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Chi.

Asked: June 08, 2017 - 5:29 am UTC

Last updated: June 09, 2017 - 2:36 am UTC

Version: Oracle application 10.1

Viewed 1000+ times

You Asked

Hi Tom!

I'm have been an issue with unicode when compile file *.fmb to *.fmx and *.mmb to *.mmx (OS: linxux).

I set NSL_LANG=AMERICAN_AMERICA.UTF8; NLS_LENGTH_SEMANTICS=CHAR.When I execute the command below it's successful but the unicode fonts not display.

"frmcmp BATCH=YES USERID=user/passwd@db MODULE=a.fmb MODULE_TYPE=form COMPILE_ALL=yes WINDOW_STATE=minimize"

Please help me sold the problem!

Thanks in Advance!


and Connor said...

Check MOS notes 460099.1 and 314074.1

I've quoted some of the first one below:



Click to add to Favorites How To Show Subscripts, Superscripts, Greek, Math Symbols & Special Characters in Forms (Doc ID 460099.1) To BottomTo Bottom

In this Document
Goal
Solution
References

APPLIES TO:

Oracle Forms - Version: 10.1.2 and later [Release: 10.1.2 and later ]
Information in this document applies to any platform.
Checked for relevance on 21-Oct-2010
NLS_LANG
GOAL

The goal is to be able to display any character selected from windows Character Map as boilerplate in a Form.


SOLUTION

This note applies to boilerplate text items only.

In order to display the greatest range of characters, it is recommended that the latest version of the JDK 1.5.0_X or 1.6.0_X plugin be used. Although the latest version of JInitiator (1.3.1.30 at the time this note was written) will show a wide range of special characters it will be a subset of those that can be displayed using JDK 1.5.0_X or 1.6.0_X


Note that the characters are rendered on the client machine so the client machine must have the fonts/special characters installed on it. In some cases this may require installing extra fonts or font supplements on the client.

The Windows character map (Start-> Programs -> Accessories -> System Tools -> Character Map) gives a good indication of what characters you can display on a windows client. Using this tool, you should be able to insert and view most of the characters in the Windows Character Map into a Form using Forms Builder. In general, the font chosen in Windows Character map should be the same when inserted into your form and should be a unicode font. Although this is not always necessary, you will find more displayable characters if the font is unicode. Note that to display the characters in Forms Builder one should have NLS_LANG set to AMERICAN_AMERICA.UTF8 in the Windows registry for the Developer Suite Oracle Home.

Assuming you have created the Form the following is needed to run it from an Application Server on windows and unix platforms:

WINDOWS

1. Generate the form ensuring that NLS_LANG is set to AMERICAN_AMERICA.UTF8 in the registry.
2. Ensure that NLS_LANG is set to AMERICAN_AMERICA.UTF8 in the OH/forms/server/default.env file.
3. Run the form using the latest version of 1.5.0_X or 1.6.0_X

UNIX

1. Accomplish the following steps in order to successfully generate the form using UTF8:

a. Locate Tk2Motif_UTF8.rgb in the OH/guicommon/tk/admin directory.
b. Back up the original Tk2Motif.rgb file.
c. Copy Tk2Motif_UTF8.rgb to Tk2Motif.rgb
d. Modify the OH/bin/frmcmp_batch.sh by adding the following:

TERM=vt220
export TERM

ORACLE_TERM=vt220
export ORACLE_TERM

NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_LANG

e. Generate the form using -> frmcmp_batch.sh module=myform userid=un/pw@db

2. Ensure that NLS_LANG is set to AMERICAN_AMERICA.UTF8 in the OH/forms/server/default.env file
3. Run the form using the latest version of 1.5.0_X or 1.6.0_X .

Is this answer out of date? If it is, please let us know via a Comment