SQL & PL/SQL

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!

Hello Am trying to insert a special characcter "ƒ" but its not taking

978485Mar 21 2013 — edited Mar 25 2013

Hello all ,

Help is greatly appreciated.

Am trying to insert a special character for currency symbol -"ƒ". Below is my insert statement.

INSERT INTO PROD.region
(COUNTRY_ID, CURRENCY_SYMBOL , NAME)
VALUES
(530,'"ƒ"', 'Netherland Antilles' );

I tried from TOAD as well as Sql Plus , but its inserting as "?" for currency symbol column .

So please kindly anyone provide me suggestion how to have the exact value- "ƒ" to be inserted.'

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2013

Added on Mar 21 2013

14 comments

1,197 views