Re: NLS problem with Oracle7

nope, forget that, EE is correct

frank wrote:

> inline
>
> Jaroslaw Lubczynski wrote:
>
> > Hi,
> >
> > My application runs in environment described below:
> >
> > Server Oracle 8.0.5 Workgroup Edition on WinNT 4.0
> > Oracle7 client ver 7.2.2 on SCO Open Server 5.0.4
> > Pro*C interface (Pro*C precompiler version 2.1.2.0.0) used as sql interface
> > NLS_LANG=POLISH_POLAND.EE8ISO8859P2 env. variable set
>
> 2 typo's here, I hope:
> POLISH_POLAND.WE8ISO8859P2 (WE, not EE)
> In the registry, not an environment variable
>
> >
> > Application working under SCO
> >
> > When I try to INSERT characters specific to Polish alphabet from sqlplus
> > (column of type CHAR) - everything seems to be OK - SELECT returns proper
> > Polish chars.
> > When I INSERT Polish characters from my application, database accepts this
> > without error, but SELECT returns unexpectable characters.
> > When I SELECT data from my application previously INSERTed under sqlplus -
> > wrong characters are in result. The same effect occurs when I SELECT data
> > from sqlplus INSERTed previously by my application
> >
> > This means my application doesn't convert characters properly - but sqlplus
> > does - under the same environment! What did I miss? When precompiling my .pc
> > file I tried NLS_LOCAL=NO and NLS_LOCAL=YES as well.
> >
> > Waiting for ANY help
> >
> > Jaroslaw "ELJOT" Lubczynski
> > programmer, Poland
>
> sqlplus will start with an alter session set nls_lang... etc, etc.
> Maybe you should, too (from within your app, that is)
Received on Fri Oct 06 2000 - 14:59:28 CDT