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!

Inserting special character data via SQL Plus

stromrFeb 13 2014 — edited Feb 13 2014

Hi,

I need to insert the registered trademark symbol into a field using SQL Plus. I have tried the following, but it doesn't work.

update table_name

set field_value = chr(169)

where table_key = 123;

I have tried several ascii codes for different special characters and the special characters don't get inserted. The NLS_CHARCTERSET value in the DB is UTF8. Any help would be greatly appreciated.

Thanks,

Rick Strom

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2014

Added on Feb 13 2014

5 comments

3,437 views