NLS problem with Oracle7

From: Jaroslaw Lubczynski <eljot_at_elkomtech.com.pl>
Date: Thu, 5 Oct 2000 13:03:06 +0200
Message-ID: <8rhn2r$s7f$1@news.tpi.pl>

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 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 Received on Thu Oct 05 2000 - 06:03:06 CDT