Skip to Main Content

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!

PDF Reports in Unicode / Arabic & English

53236Nov 22 2004 — edited Nov 28 2011
Hi,

i am working on Oracle database 9i (Database is having UTF8 characterset )
and Oracle 9iDS

i am having problem on generating PDF reports in Unicode.

Problem is : i have a data field in Database column with mixed languages like Arabic & English for example Half is in English and half in Arabic , Or Full in Arabic

now the problem is when i select this column in reports
value shown is not same as look like in forms runtime
( data is stored in UTF8 character ser database)

but if i generate in other format like HTMLCSS or RTF
reports comes correct.

one more point i want to highlight when i use any boiler palette text in reports and set fonts correctly , i am able to see the boiler palette text in correct in PDF output

and i wave installed unicode fonts and set the path REPORTS_PATH in registory in C:\winnt\fonts
also i have changed and using fonts SUBSETTING

i have tried setting
1)REPORTS_PATH to font directory
2) Download some unicode fonts (cyberbit) and installed
3)Fonts subsetting
4) with Acrobat version 5 and 6
5) nls_lang=AMERICAN_AMERICA.UTF8
6) acrobal setting Smooth Text,Smooth Line art,Smooth Images all ticked
but still i am not able to find out where i am doing wrong
please help me

Thanks,
Puneet Tripathi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2011
Added on Nov 22 2004
4 comments
7,680 views