OraFAQ Forum: SQL & PL/SQL » Inserting copyright symbol in oracle.

Home » SQL & PL/SQL » SQL & PL/SQL » Inserting copyright symbol in oracle.

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

Inserting copyright symbol in oracle. [message #48628]

Sun, 05 December 2004 20:45

Ankur
Messages: 22
Registered: August 2000

Junior Member

Hi,

Can somebody tell me, how to insert symbols like copyright or TM �� or other registered symbols.

Thanks

Ankur

Report message to a moderator

Re: Inserting copyright symbol in oracle. [message #48632 is a reply to message #48628]

Mon, 06 December 2004 01:58

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

use ascii() function to get the ascii code for the required symbol.
then use chr() to get the char back.

ex:
select ascii('�') from dual;
-- 174

now u can use chr(174) whereever u required �.

by
vamsi

Report message to a moderator

Re: Inserting copyright symbol in oracle. [message #48634 is a reply to message #48632]

Mon, 06 December 2004 07:33

Jon
Messages: 483
Registered: May 2001

Senior Member

Correct, since the question asked about symbols in general. It also asked about the copyright symbol specifically, which is 169. 174 is the registered symbol.

Report message to a moderator

Re: Inserting copyright symbol in oracle. [message #48642 is a reply to message #48634]

Mon, 06 December 2004 19:20

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

u r right. i have given an example.

by
vamsi

Report message to a moderator

Previous Topic:	Usage of GUID/UUID as PKEY
Next Topic:	What is a foreign key?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 04 00:02:28 CDT 2025