I have a field which gets populated with incorrect characters and specially the chr(191) ' inverted ? sign'..

Original txt : . Unit 1 has stated, “I’M SO SORRY”. XXXX unable to obtain a full version from Unit 1 due to her injuries and QAS request that

Converted text : has stated, ¿I¿M SO SORRY¿. XXXX unable to obtain a full version from Unit 1 due So, ideally i do want to see the original text,

but for 9i version i cannot seem to get any equivalent functions as used by 10g or higher.


I had this sample code written but for 10g versions :-

UPDATE rc.rc_descripton
SET desc_description =
(
CASE
WHEN desc_description LIKE '%[^a-zA-Z0-9]%'
THEN Replace(REPLACE( desc_description, SUBSTRING( desc_description, regexp_instr('%[~,@,#,$,%,&,*,^,&,%,*,(,)]%', desc_description), 1 ),''),'-',' ')
ELSE desc_description
END
)

Tried using OWA_PATTERN.AMATCH but certainly does not work for 9i version too.

So what function can i use to make the above script work for oracle 9ir2 versions...??

SELECT replace(CONVERT('Ä Ê Í Õ Ø A B C D E ', 'US7ASCII', 'WE8ISO8859P1'),'?')    FROM DUAL; 

declare
  x varchar2(100) := 'Hello Ä Ê ÍTHere';
  y varchar2(200) := asciistr(x);
  res varchar2(100); 
begin
  while instr(y,'\') > 0 loop
     res := res || substr(y,1,instr(y,'\')-1);
     y := substr(y,instr(y,'\')+5);
  end loop;
  dbms_output.put_line(res||y);
end;
/