Re: oracle characters strange problem

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 15 Feb 2006 15:31:10 GMT
Message-ID: <1140017465.473787_at_proxy.dienste.wien.at>


amitkr.3_at_gmail.com wrote:
> Please explain this behavior of my oracle 8i
>
> select chr(163) from dual
>
> selects
>
> #
>
> select chr(35) from dual
>
> selects
>
> #
>
> And
> select chr(163) from dual
> minus
> select chr(35) from dual
> selects a
>
> #

I guess that's alright.

What is your database character set?

(select value from v$nls_parameters where parameter='NLS_CHARACTERSET')

Yours,
Laurenz Albe Received on Wed Feb 15 2006 - 16:31:10 CET

Original text of this message