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!

How to remove extended ascii characters (from ascii code 128 - 255)

User756729-OracleDec 2 2009 — edited Dec 11 2009

Hi,

Is there a way to use regexp to remove extended ascii characters ranging from ascii code 128 - 255, like 'ï¿½�' from a CLOB string?

I tested following syntax. I thought this should remove '½', but not working.

select regexp_replace('ï¿½?' , chr(189), '') from dual;

Any advice on this is greatly appreciated.

Thanks,
James

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2010

Added on Dec 2 2009

2 comments

3,742 views