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

Expand|Select|Wrap|Line Numbers

insert into dept values(11,'©','del');

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

Quote:

Originally Posted by 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

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:-

Expand|Select|Wrap|Line Numbers

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

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

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

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

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

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

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about