Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPUS and NLS_LANG

Re: SQLPUS and NLS_LANG

From: FreeDBA <p.hirth_at_gmail.com>
Date: 14 Jun 2006 08:45:39 -0700
Message-ID: <1150299939.676137.88330@c74g2000cwc.googlegroups.com>

Michel Cadot a écrit :

> "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

In dos
set NLS_LANG=french_france.we8pc850
and now it's ok !!!!
so in dos the NLS_LANG is not used by SQLPLSU ? Received on Wed Jun 14 2006 - 10:45:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US