How to Insert the Special Copyright © Character in an Oracle Table

[avellas]

Hi,

I was wondering if anyone would know how to insert the copyright character "©" into a field of an Oracle table?

Many thanks in advance...

Sam

[debasisdas]

What is the problem ?

try this sample

[code=oracle]insert into dept values(11,'©',' del');[/code]

[avellas]

Hi Everyone,

Lesson learned, I was trying to do this through the DOS SQLPLUS window, which doesn't support the characterset. If I use the SQL*Plus GUI then it will insert the copyright character set.

My humble apologies if I've wasted anyone's time.

Regards,
Sam

[amitpatel66]

Hi Everyone,

Lesson learned, I was trying to do this through the DOS SQLPLUS window, which doesn't support the characterset. If I use the SQL*Plus GUI then it will insert the copyright character set.

My humble apologies if I've wasted anyone's time.

Regards,
Sam

Hi Sam,

Its good to hear that you have learnt something, in that way you have wasted none of ours time.
We are always here to help you out.

MODERATOR

[singhh04]

Even you can do this from DOS Sqlplus Window:-

[code=oracle]

INSERT INTO dept VALUES(11,chr(1 69),'del');

[/code]