DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Arabic Problem while passing arabic value from form to report as parameter

saadatahmadMay 15 2008 — edited May 21 2008

hi,
I have created one report using lexicals. My report query is
select col1, col2, col3.......coln
from table_name
&p_where_clause

I'm building my dynamic where clause in form and passing it as a parameter to report. Everything is fine except the Arabic. I'm passing the Report heading also as a parameter and printing in report as Heading. This is in Arabic. When the report runs and parameter is shown, I can see the arabic written in the report parameter form. But when I run the report either as PDF or HTML, I get '???????' instead of arabic. Because of this problem, I'm unable to pass my where condition properly to report.

Even if I create a simple report. Create a parameter for heading of the report. Run the report from form passing the value of the parameter in arabic, I get the question marks only. For english, there is no problem.

My database characterset is AR8ISO8859P6.
NLS_LANG = AMERICAN_AMERICA.AR8MSWIN1256
I have changed my unifont.ali file and added this entry
[PDF:Subset]
Arial = "arial.ttf"
Arial..italic... = "ariali.ttf"
Arial...Bold.. = "arialbd.ttf"
Arial..italic.Bold.. = "arialbi.ttf"
"Andale Duospace WT J" = "Aduoj.ttf"
"Albany WT J"="AlbanWTJ.ttf"
"Arabic Transparent"="artro.ttf"

Note: Instead of Jinitiator, I have configured Java Standard Edition 1.6.0_05-b13. So In my application server, I'm not using Jinitiator because of the arabic font issue.

I spent too much time on finding the reason for this with no success. Please suggest something. I'm unable to figure out what may be the solution.

if you require more information regarding the problem, please let me know.

Thanks and regards,
Saadat Ahmad

Message was edited by:
saadatahmad