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!

Not getting Euro Symbol in PDF Report using XML Publisher

Saurabh Jaiswal1Aug 19 2011 — edited Feb 21 2012

Hi,

We have developed an Oracle Report from Report Builder 6i and also a Template in RTF Format.
We are using XML Publisher to display our XML Output in PDF Format to Users..

There is a Field called Comments on Customer Transaction Form, where user can enter any characters and that we are querying in Report and displaying on the PDF Output.
Currently, the user entered a Euro Character on the comments section and that was not visible to user on PDF Report and replaced by a Question Mark as below:

"3% price reduction ?89.91, 20% marine"

When i am Querying to the Database, i am able to see the Euro Symbol, but when i checked the XML generated on the Unix Box for the Report. I found as below:

"3% price reduction \342\202\25489.91, 20% marine"

So, the Euro Symbol on the database is replaced by " \342\202\254" in the XML Output and ? in the PDF Outbut.

Please help ASAP.

Regards
Saurabh Jaiswal