Re: translate and accent characters
From: Frank <fvanbortel_at_netscape.net>
Date: Tue, 04 Feb 2003 19:45:09 +0100
Message-ID: <3E400A35.3070007_at_netscape.net>
Date: Tue, 04 Feb 2003 19:45:09 +0100
Message-ID: <3E400A35.3070007_at_netscape.net>
Richard wrote:
> 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!
It does...
SQL> select nvl(translate(chr(231),chr(231),'c'),'null! ') from dual;
N
-
c
8.1.7.4 on Linux; 8.1.7.0 client on W2K, client side nls-lang: AMERICAN_AMERICA.WE8ISO8859P1 Frank
Frank Received on Tue Feb 04 2003 - 19:45:09 CET