Re: SQLPUS and NLS

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 19 Jun 2006 07:44:24 GMT
Message-ID: <1150703062.86736@proxy.dienste.wien.at>

FreeDBA <p.hirth_at_gmail.com> wrote:
> In dos
> set NLS_LANG=french_france.we8pc850
> and now it's ok !!!!
> so in dos the NLS_LANG is not used by SQLPLSU ?

Yes, it is.

DOS has codepage 850, so if you tell the Oracle Client that it should use codepage 850, the output will look correct.

Windows has codepage 1252, so if you tell it to use codepage 1252, the characters will look fine.

Same for AIX and ISO8859-1.

Bottom line: The codepage must be set to whatever codepage the client program expects.

Yours,
Laurenz Albe Received on Mon Jun 19 2006 - 02:44:24 CDT

Re: SQLPUS and NLS_LANG