Re: SQLPUS and NLS

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 14 Jun 2006 14:03:00 GMT
Message-ID: <1150293778.833495@proxy.dienste.wien.at>

FreeDBA <p.hirth_at_gmail.com> wrote:
> someone could tel me why
>
> When i exceute : SQL> select upper('é') from dual;
>
> I obtain various results according to the workstation or I carry out it
> !!!
>
> sometimes i obtain : é
>
> other times : E
>
> Thank's

It's all explained in the Globalization Support Guide http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14225/toc.htm

You need to set NLS_LANG so that it matches the codepage that your client operating system or program uses.

Yours,
Laurenz Albe Received on Wed Jun 14 2006 - 09:03:00 CDT

Re: SQLPUS and NLS_LANG