Re: SQLPUS and NLS_LANG

Laurenz Albe a écrit :

> 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

Onto the AIX,
Operabk> /home/oracle#echo $NLS_LANG
AMERICAN_AMERICA.WE8ISO8859P1
<operabk> /home/oracle#sqlplus system/whenever_at_operabk

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 14 16:43:00 2006

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production JServer Release 8.1.7.2.0 - Production

SQL> select 'é' from dual;

'É

--
é

SQL>


Onto WIndos
C:\Documents and Settings\Administrateur>echo %NLS_LANG%
AMERICAN_AMERICA.WE8ISO8859P1

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
JServer Release 8.1.7.2.0 - Production

SQL> select 'é' from dual;

'+'
---
+

SQL>


Could you explain me ? 
Thank's