Home » SQL & PL/SQL » SQL & PL/SQL » Euro Sign
Euro Sign [message #207643] Wed, 06 December 2006 07:05 Go to next message
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 properly.

select vendor_name
from po_vendors
where vendor_name like 'A HOGG%'

Ouput looks like - "A HOGGARTH & SONS "

The query should return me the vendor_name 'A HOGGARTH & SONS ' but unfortunately instead of euro sign some other character is getting displayed.

Can any one help me on this please.

Thanks
Safeeq


Re: Euro Sign [message #207648 is a reply to message #207643] Wed, 06 December 2006 07:22 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

This should give you the hints for how to approach this properly

http://forums.oracle.com/forums/thread.jspa?threadID=391482&tstart=90

Good Luck

[Updated on: Wed, 06 December 2006 07:24]

Report message to a moderator

Re: Euro Sign [message #207690 is a reply to message #207643] Wed, 06 December 2006 11:25 Go to previous messageGo to next message
Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore
Senior Member

I tried doing the work-around after reading the above link but still it didnt resolve my issue. Is there any way to resolve this issue,Please?
Re: Euro Sign [message #207843 is a reply to message #207690] Thu, 07 December 2006 03:27 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

So what are your charchterset for the db ?
And all you NLS parameters set to then ?
Re: Euro Sign [message #207908 is a reply to message #207843] Thu, 07 December 2006 05:41 Go to previous messageGo to next message
Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore
Senior Member

Hi,

select RPAD(Parameter,25,' ')Parameter,RPAD(Value,30,' ')Value from v$NLS_PARAMETERS
where parameter like '%CHARACTERSET%'

The output is,

Parameter Value
---------------------------------------------------------
NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16

select * from nls_database_parameters where parameter
='NLS_CHARACTERSET';

Parameter Value
---------------------------------------------------------
NLS_CHARACTERSET UTF8

Please let me know if you need more information.

Thanks
Safeeq
Re: Euro Sign [message #207956 is a reply to message #207908] Thu, 07 December 2006 08:44 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

There are alot of doc's for this on metalink, and also
on google, which charchterset to choose etc...

Thou I have an example for you, so you can see why it isn't working for you....

SQL> create table euro_sign (byte_varchar VARCHAR2(1 BYTE),
2 char_varchar VARCHAR2(1 CHAR));

SQL> INSERT INTO EURO_SIGN (BYTE_VARCHAR, CHAR_VARCHAR)
2 VALUES ('' ,NULL );
VALUES ('' ,NULL )
*
ORA-01401: inserted value too large for column

SQL> INSERT INTO EURO_SIGN (BYTE_VARCHAR, CHAR_VARCHAR)
2 VALUES (NULL,'');

1 row created.
SQL> select * from euro_sign
2 ;

B C
- -



Previous Topic: order by
Next Topic: How to refer to the whole new record (:new) in table trigger
Goto Forum:
  


Current Time: Fri Dec 09 13:35:18 CST 2016

Total time taken to generate the page: 0.17066 seconds