OraFAQ Forum: SQL & PL/SQL » How to find the extended ascii characters from a string

Home » SQL & PL/SQL » SQL & PL/SQL » How to find the extended ascii characters from a string (Oracle 10 g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find the extended ascii characters from a string [message #596252]

Thu, 19 September 2013 09:11

debasisp
Messages: 10
Registered: February 2010
Location: BANGALORE,INDIA

Junior Member

Hi,

I have a table like mentioned below

create table test1( test_no number, test_description varchar2(100));

insert into test1 values (1,'ABC£¥');

insert into test1 values (2,'BCD£¥');

Now I am selecting from the above table and the expected rest it should have shown is as shown below

TEST1
-----------------------
TEST_NO TEST_DESCRIPTION
1 ABC£¥
2 BCD£¥

But instead of showing the extended ascii characters, it is showing some different characters as shown below

select * from test1;

TEST1
-----------------------
TEST_NO TEST_DESCRIPTION
1 ABCLY
2 BCDLY

I have an requirement where i need to fetch the exact ascii characters for £ and ¥ instead of L and Y respectively.

Could you please help me regarding the same.

regards,

Strikerdp

Report message to a moderator

Re: How to find the extended ascii characters from a string [message #596260 is a reply to message #596252]

Thu, 19 September 2013 10:33

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You must be sure that:
1/ Your NLS_LANG supports these characters
2/ Your client program (SQL*Plus or other) supports them
3/ Your OS terminal supports them
4/ Your OS supports them

Report message to a moderator

Previous Topic:	Architecture
Next Topic:	Grouping Data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 20:32:28 CDT 2024