Re: NLS problem with Oracle7

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 Thu Oct 05 2000 - 14:51:17 CDT