Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need Help with ® (registered trademark) symbol

Status
Not open for further replies.
njtornado

njtornado

Programmer
Apr 2, 2001
8
US
How do you save a ® (registered trademark) symbol in an Oracle 8.1.7 db?
 
Sort by date Sort by votes
You can insert the symbol as image in Db and then use it. But if you need it for some Report or Form try to paste at as image there.
 
Upvote 0 Downvote
You need not save anything. Use the Chr() function. If you "SELECT CHR(174) FROM Dual" in Sqlplus you should get that symbol, assuming that the NLS_LANGUAGE setting doesn't get in the way.


SQL> select chr(174) from dual;

C
-
®

1 row selected.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
332
SkipVought
S
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
327
carp
carp
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
395
Andrzejek
Andrzejek
Tsmtbo2011
  • Locked
  • Question
Help Needed!! Micros WS6 610
Replies
1
Views
107
carp
carp
TheLazyPig
  • Locked
  • Question
Change format name with comma 1
Replies
3
Views
111
TheLazyPig
TheLazyPig

Part and Inventory Search

Sponsor

Back
Top