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:
https://www.omicronlab.com/avro-keyboard.html
I am currently working for an application in Oracle 10g DS.
ReplyDeleteSpecs require input to be in Bengali Unicode.
I have configured the Database in UTF-8 Character set. And I can now (After a week of R&D) write Prompts Oracle 10g DS in Bengali Input.
Problem is :
WHEN I RUN THE APPLICATION, IT SHOWS SQUARE BOXES ONLY AND THE TEXT ITEMS (WHEN I INPUT IN BENGALI) SHOWS ???????????
Seems that Oracle JInitiator does not work for Unicode Fonts.
Please, anybody, can u help ??
Best Regards,
hasanur, Dhaka, Bangladesh
I am also face this problem. If you now this solotion please help me.
DeleteDear,
DeleteI think you need to add bellow line on files.map file
<--your font name-->.ttf::{"component","oracle.jdk","1.4.2.0.6"},{"patch","oracle.jdk","1.4.2.14.02"},
files.map path>> \inventory\filemap\jdk\jre\lib\fonts
***Please inform me more details***
Hi, Still I am facing the same problem, for Arial Unicode MS . Operating System : Windows 2003 advanced server. . Both database and Oracle Forms and Reports are installed on the same server. . Databse : Oracle 10g Release 2 . Oracle Forms and Reports : Oracle 10g Developer Suite Release . Database setting : NLS_LANG = AL32UTF8 NLS_NCHAR_LANG = AL32UTF8. . Langauge : Bangla Langauge . Font : SolaimanLipi. Windows Setting : From regional setting, Indic is selected for Bangla font. . If Sql propmt I update the table values, it accept properly and also updating and quering from database properly without any issue. Not a problem for Combination letters. . For Forms : 1. I updated Registry.dat file, with font name 'SolaimanLipi. 2. In regedit, for Forms home, updated NLS_LANG=AMERICAN_AMERIC.UTF8 . Now if in forms-canvas I want to type the Marathi lebel (with Arial Unicode MS) then showing '??????', but if i tried to copy the word from Character map, then it showing it properly.But on running the form it showing combine letter separated. . On text box, it not allowing to type anything. for any key pressed it shows '????'.
ReplyDeleteHello,
ReplyDeleteI'm working on Oracle 11g with PHP . When I tried to fetch data(bangla font) from DB , its showing boxes, then I tried with AL32UTF8 , its showing "??????" like this. Have you any idea that , how can I resolve this issue.
Thanks,
Riyad