Trouble with converting special characters

From: <paulmcinerney_at_my-dejanews.com>
Date: Mon, 24 May 1999 14:36:15 GMT
Message-ID: <7ibo4v$1k2$1@nnrp1.deja.com>

I am trying to convert special characters with PL/SQL, however I PL/SQL refuses to convert certain characters. The script below is an example of the problem:

set serveroutput on ;
DECLARE
        v_Test varchar2(100) := '-----�E----';

BEGIN
                dbms_output.put_line(v_Test ||
'\n') ;

                v_Test := replace(v_Test, chr
(235),'e') ; -- �E0xeb)

                dbms_output.put_line(v_Test ||
'\n') ;

		v_Test	:= '-----�-----';
		dbms_output.put_line(v_Test ||


'\n') ;


		v_Test := replace(v_Test, chr
(174),'e') ;  -- �(0xae)
		dbms_output.put_line(v_Test ||

'\n') ;

end ;

In the example above, 0xeb is not converted at all, however 0xae is converted just fine. The version of PL/SQL is 8.0.4.0.0 (Japanese version)

I need to fix this urgently. Any assistance would be greatly appreciated.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 24 1999 - 09:36:15 CDT