OraFAQ Forum: Server Administration » Printing/inserting/selecting of some special chars

Home » RDBMS Server » Server Administration » Printing/inserting/selecting of some special chars

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

Printing/inserting/selecting of some special chars [message #374508]

Fri, 15 June 2001 08:30

atul kulkarni
Messages: 4
Registered: June 2001

Junior Member

Here is a list of few chars, which I want to insert into table. Those chars are not exists in ASCII set.
Can someone please explain me either how (and which) to set the NLS char set or insert by some other method.
I am using oracle 8.1.6.3.0
Thanks
ă
Ă
ĭ
Ĭ
ō
Ō
ŭ
Ŭ

Report message to a moderator

Re: Printing/inserting/selecting of some special chars [message #374520 is a reply to message #374508]

Fri, 15 June 2001 18:23

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

Get the character's ascii number (this example is for 'a')
select ascii('a') from dual;

select chr(97) from dual;

Use chr() in insert, update etc.

Report message to a moderator

Re: Printing/inserting/selecting of some special chars [message #374548 is a reply to message #374508]

Mon, 18 June 2001 10:54

atul kulkarni
Messages: 4
Registered: June 2001

Junior Member

thnaks
but as I mentioned earlier, these chars are not defined in ASCII

Report message to a moderator

Re: Printing/inserting/selecting of some special chars [message #374549 is a reply to message #374508]

Mon, 18 June 2001 10:55

atul kulkarni
Messages: 4
Registered: June 2001

Junior Member

thnaks
but as I mentioned earlier, these chars are not defined in ASCII

Report message to a moderator

Re: Printing/inserting/selecting of some special chars [message #374550 is a reply to message #374508]

Mon, 18 June 2001 10:58

atul kulkarni
Messages: 4
Registered: June 2001

Junior Member

thanks,
As I mentioned, those are not ASCII chars.

Report message to a moderator

Previous Topic:	Re: complex query - Help required
Next Topic:	SQL QUERY - HELP REQUIRED

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 06 06:24:03 CDT 2024