SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

inserting pound (£)symbol in a table from .sql file

886413Jun 8 2012 — edited Jun 11 2012

Hi,

While executing insert statement from sql developer that contains '£' symbol it is inserted correctly as '�' in a table according to th character set of the DB.

but when i execute the same insert statement that is inside a sql file it is inserted as '#' symbol in the same table in the same DB.

is there any difference executing the same insert statement from sql developer and from a file?

can anyone telll me the answer?

Thanks in avance

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2012

Added on Jun 8 2012

#sql-developer

3 comments

1,211 views