Trouble with converting special characters

[paulmc...@my-dejanews.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) := '-----・----';

BEGIN
dbms_output.put_line(v_Test ||
'\n') ;
v_Test := replace(v_Test, chr
(235),'e') ; -- ・0xeb)
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.---