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>
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!') translationfrom dual
DECIMAL_ HEX_ CHARACTER_ TRANSLATION
---------- ----- ---------- -----------
231 e7 ç NULL!
1 row selected
Thanks! Received on Tue Feb 04 2003 - 17:01:31 CET