Oracle 10g Report showing junk char for £ in PDF output
Hi,
We have a custom report (RDF) to show Receivables Credit-memo details and one of the credit memo has "£" in the comments field value, which is being displayed with a special char prefix i.e. "£", when we view the comments from Forms it shows correctly as "£" (without any special char prefix)
could you please let me know how to show "£" symbol correctly in report output, any pointer would be really helpful.
we are using eBusiness R12.1.3 and database 11g (hosted on Solaris-10 server) and in the database NLS_CHARACTERSET is setup as "UTF8" (in NLS_DATABASE_PARAMETERS)
Rgds,
-Kamal