translate and accent characters

From: Richard <quintinr_at_vtls.com>
Date: 4 Feb 2003 08:01:31 -0800
Message-ID: <43153696.0302040801.5fab3ab0_at_posting.google.com>


Why doesn't the translate function work in this statement?

select 231 decimal_,

       to_char(231, 'xxxx') hex_,
	   chr(231) character_,
	   nvl(translate(chr(231), chr(231), 'c'), 'NULL!') translation
  from dual

  DECIMAL_ HEX_ CHARACTER_ TRANSLATION
---------- ----- ---------- -----------

       231 e7 ç NULL!

1 row selected

Thanks! Received on Tue Feb 04 2003 - 17:01:31 CET

Original text of this message