| Euro Sign [message #207642] |
Wed, 06 December 2006 07:01  |
Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore
|
Senior Member |
|
|
Hi,
I have a table called po_vendors where one of the supplier name looks like 'A HOGGARTH & SONS ¤' (ie supplier name with euro sign) which is not getting displayed/printed properly.
The supplier is getting displayed as 'A HOGGARTH & SONS ¿'. The SQL query also returns me the same kind of result, instead of euro sign '¿' is getting printed.
select vendor_name
from po_vendors
where vendor_name like 'A HOGG%'
Have any one has overcome a similar scenario, your help will be highly appreciated in this.
Thanks
Safeeq
|
|
|
|
|
|
|
|
| Re: Euro Sign [message #207991 is a reply to message #207971] |
Thu, 07 December 2006 13:06  |
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
|
Senior Member |
|
|
hi safeeq,
ok I tried what u have suggested me but the problem is that euro sign did not get entered in the table so it is not giving euro as output i am giving u the example :
| Quote: | SQL> insert into euro values('Ashutosh SONS ¤');
1 row created.
SQL> commit;
Commit complete.
SQL> insert into euro values('As?+Ts§+{¦');
1 row created.
SQL> commit;
Commit complete.
|
When i run the report Output for 'As?+Ts§+{¦' is coming correct but for Ashutosh Sons 'a dark rectangle' is not coming correct .
As Euro is printing in it is not storing in same fasion .
Ashu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
