Home » SQL & PL/SQL » SQL & PL/SQL » Extended ASCII character problems
Extended ASCII character problems [message #384663] Wed, 04 February 2009 12:47 Go to next message
ms960
Messages: 2
Registered: February 2009
Junior Member
I've got a table with a bunch of CLOB's that have extended ASCII characters (, , etc.) in them. These characters are causing problems in one of our environments because of the character set being used in that environment, which I have no control over.

I am trying to find and replace all instances of these characters, using something like:

select recid, publicobjective
from record_backup
where instr(publicobjective,'') > 0;


AND

select recid, publicobjective
from record_backup
where instr(publicobjective,chr(168)) > 0;


I can see the characters inside the columns, but these queries return 0 records. What would be causing that? More importantly, how can I find them and do a bulk replace?

Thanks!
Re: Extended ASCII character problems [message #384664 is a reply to message #384663] Wed, 04 February 2009 12:51 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

search this forum for ASCIISTR function

[Updated on: Wed, 04 February 2009 12:51]

Report message to a moderator

Re: Extended ASCII character problems [message #384668 is a reply to message #384664] Wed, 04 February 2009 13:51 Go to previous messageGo to next message
ms960
Messages: 2
Registered: February 2009
Junior Member
BlackSwan wrote on Wed, 04 February 2009 13:51
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you

You mean the hour I spent searching this and other forums looking for an answer before I posted? Sorry -- I'm not a full-time DBA therefore wasn't aware I should have searched for the ASCIISTR function.


BlackSwan wrote on Wed, 04 February 2009 13:51

search this forum for ASCIISTR function

Thanks.
Re: Extended ASCII character problems [message #384669 is a reply to message #384663] Wed, 04 February 2009 13:55 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
A basic problem with search in general is that if you don't know what you need then you might not find it.
Previous Topic: Alternatives for oracle soundex & soundex arabic version?.
Next Topic: How can I return a ref cursor from dbms_sql.
Goto Forum:
  


Current Time: Tue Dec 06 14:15:46 CST 2016

Total time taken to generate the page: 0.12316 seconds