Home » SQL & PL/SQL » SQL & PL/SQL » How to insert a special character
How to insert a special character [message #4014] Sat, 02 November 2002 11:29 Go to next message
pk
Messages: 12
Registered: September 2000
Junior Member
Can someone help me how to insert a special
character ® (ascii value 174) into an Oracle table.

I tried like this : 'PK'|| CHR(174)||'PK'

But looks like it does not like it. It says unique constraint violated. Appreciate any help. Thanks

Report message to a moderator

Re: How to insert a special character [message #4016 is a reply to message #4014] Sat, 02 November 2002 18:08 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Your syntax is correct, but the unique constraint error is saying that the value already exists in the table and you can't add it a second time.

Report message to a moderator

Previous Topic: Which one is faster
Next Topic: Urgent Query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 15:20:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.