Wednesday, November 4, 2009

Bangla Font Configuration With Oracle

First Collect SolaimanLipi.ttf (Click here for download) Font from a Reliable Sourse.Install this font and follow below steps:

*** It will be better if u use Developer10g Rel-2 ( Version 10.1.2.0.2 - 32 Bit )
*** During database installation must be change Product Language by AL32UTF8

[Remember that, u must have configure JRE in Webutil Configuration
For JRE, must be incldue the followinng code into Formsweb.cfg file
(Path: DevHome\forms\server\)

###########################################################################
   # Page displayed to users to allow them to download Sun's Java Plugin.
   # Sun's Java Plugin is typically used for non-Windows clients.
   # (NOTE: you should check this page and possibly change the settings)
   jpi_download_page=/forms/java/jre-6u17-windows-i586-S.exe
   # Parameter related to the version of the Java Plugin
   jpi_classid=clsid:CAFEEFAC-0016-0017-FFFF-ABCDEFFEDCBA
   # Parameter related to the version of the Java Plugin
   jpi_codebase=/forms/java/jre-6u17-windows-i586-S.exe
   # Parameter related to the version of the Java Plugin
   jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_17
   # EM config parameter
   # Set this to "1" to enable Enterprise Manager to track Forms processes
   em_mode=0
 #######################################################################
  
In the Key Configuration of formsweb.cfg file 
 replace baseHTMLjinitiator=webutiljini.htm by baseHTMLJInitiator=webutiljpi.htm

   archive=frmall.jar
   webUtilArchive=frmwebutil.jar,jacob.jar
   baseHTMLJInitiator=webutiljpi.htm

#######################################################################

For Download JRE(jre-6u17-windows-i586-s.exe) Click Here  
Classid : CAFEEFAC-0016-0017-FFFF-ABCDEFFEDCBA ]

1. Start>>Run>>regedit>>Database Home>> Edit NLS_LANG file by double click

Replace AMERICAN_AMERICA.WE8MSWIN1252 by AMERICAN_AMERICA.UTF8

2. Start>>Run>>regedit>>DeveloperSuit Home>> Edit NLS_LANG file by docuble click

Replace AMERICAN_AMERICA.WE8MSWIN1252 by AMERICAN_AMERICA.UTF8


3. For showing in report go to the path

..\...\DevSuiteHome\tools\common\uifont.ali

Write "SolaimanLipi" = "SolaimanLipi.ttf"
between [ PDF:Embed ] and [ PDF Subset ]


4. Developmnent machine and for app

..\...\DevSuiteHome\forms\java\oracle\forms\registry.dat

Go to default.fontMap.appFontnames line and append SolaimanLipi font name by the following.

default.fontMap.appFontnames=SolaimanLipi,.....



If you want to show default font with SolaimanLipi.(Not Mandatory) then

Find the lines default.fontMap.defaultFontname=Dialog
and replace by default.fontMap.defaultFontname=SolaimanLipi



5. Shutdown OC4J Instance once then again Start OC4J Instance.

[N.B: 01. Use Avro Keyboard (version: avrokeyboard_4.1.0) and Install SolaimanLipi font into your operating system's FONTS folder.

02. Go Start Menu >> Settings >> Control Panel >> Regional & Language Options >>
Then Select Languages Tab and Check Install files for complex script & right-to-left languages(Including Thai)
>> Ok(You have need Operating Systems CD & your system must be restart.)]

Download Avro Keyboard From The Following Link:
http://www.omicronlab.com/news/avro-keyboard-4.1.0-released.html

7 comments:

Jahid said...

Thank You vary much. I worked but while printing report in PDF the proper fond does not displayed. Anyway are you the same Sampad I know from based Ltd. Did you work in Irainfotech?

Thanks a lot.

Jahid.
Analyst Programmer
IBCS-PRIMAX

Tamzidul Amin said...

you have to maintain report configuration instruction as well as solaimanLipi font must be installed in client pc.

Anyway, I left ERA Infotech 5 months ago. Now I m in Banglalink as an Application Engineer. Please pray for me. Take Care. Keep in touch.

Tamzidul Amin (Sampad)
01926662229.

Muhammad Gulam Rabbni Khan said...

in my project i use oracle 6i developer. in form i use SutonnyMJ font. after second time installation form font has broken. how can i solve it? please help me?

Anonymous said...

Dear bro..
but it only applicable at oracle forms interface but when i run report the fonts are going disorder in PDF ..any solution

Md.Saiful said...

I am in problem with bangla combined word.such as
'Muktijuddah'. I haved it successfully.but in report as pdf it dosen't show successfully.

Please help me

Md. Nazrul Islam said...

Vai,
Assalamu alaikum. How get free copy of Developer10g Rel-2 . Please give a copy of developer & database.

Yours
Nazrul
enazrul@gmail.com

Anonymous said...

i want to enable bangla font in oracle form developer

Post a Comment