Re: SQLPUS and NLS_LANG

"FreeDBA" <p.hirth_at_gmail.com> a écrit dans le message de news: 1150296259.046778.61220_at_h76g2000cwa.googlegroups.com...

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


In DOS you're not using WE8ISO9959P1 but another code page (check with "chcp").
If you use sqlplusw.exe (real windows version), then you likely get your 'é'
(I think your windows code page is 1252 which is a strict superset of P1).

Regards
Michel Cadot