SQL & PL/SQL

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!

trying to print 'Â£' sign

373320Mar 17 2005 — edited Apr 4 2005

Hi all,

I am trying to print a report from Unix.report has a TEXT as "a further fee of Â£ 15" but when the print is taken the TEXT prints "a further fee of # 15"

I have set NLS_LANG in NLS_database_paramters and tried

select chr(163) from dual;

and it displays 'Â£' sign so the environment is correctly setup

ANY IDEAS

Thanks in Advance

JHA

Locked Post

New comments cannot be posted to this locked post.

Locked on May 2 2005

Added on Mar 17 2005

17 comments

508 views