Re: NLS characterset problem (german)

Hi Markus,

try
alter session set nls_language = German; alter session set nls_territory = Germany; as the very first thing after you connect to the database in perl. this will override client-side settings.

if you query NLS_SESSION_PARAMETERS from your perl environment, you should see, whether your session is setup correctly.

dunno how to set sqlnet parameters.

if you are really desperate, use raw instead of varchar2 as datatype. this will not go through nls-conversions, it is returned as is. your app has to take care of conversions ASCII <--> RAW - this is rather painful.
There has got to be another way to set this up.

Karsten

In article <7v4e9a$330$1_at_nnrp1.deja.com>,   lmarkus_at_my-deja.com wrote:
> Hi all,
>
> I've tried different things without being successfull at all.
> I updated OAS 4.0.7 to 4.0.7.1 but nothing changed.
> The problem seems to be a clientside one, because characters
> are imported correctly by SQL Loader and are correctly displayed when
> using SQL Plus.
> Does anybody know where to set the correct NLS values for SQLnet
> and for Oracle Application Server, and in particular in the
> LiveHTML-Application/-Cartridge? I have found out, that the
> (modified?) DBI/DBD::Oracle module used in LiveHTML does not use the
DAD
> I created before, so the NLS information entered in the DAD screens in
> Oracle Application Server panel have no sense?!?
> Could the DBI/DBD be made responsible for destroying special
characters
> and how to workaround this or can I use DADs with DBI/DBD ?
>
> I really appreciate any help!
>
> Markus
>
> In article <940863906.3783.0.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> > The characterset in NLS_LANG should be WE8ISO8859P1
> >
> > Hth,
> >
> > --
> > Sybrand Bakker, Oracle DBA
> > <lmarkus_at_my-deja.com> wrote in message
> news:7v1em2$to6$1_at_nnrp1.deja.com...
> > > Hi karsten,
> > >
> > > sorry,
> > > I tried to set the environment variable under Oracle Application
> > > Server 4.0.7 by adding it to
> Applications\myApp\Configuration\Enviroment
> > > Variables but after restarting OAS + Listener, nothing changed.
> > > We are primary developing with LiveHTML + Web Application Objects.
> > > Are there any other solution tips?
> > >
> > > Thanks a lot.
> > >
> > > Markus
> > >
> > >
> > > In article <7v19gj$qc4$1_at_nnrp1.deja.com>,
> > > karsten_schmidt8891_at_my-deja.com wrote:
> > > > Hi,
> > > >
> > > > make sure, NLS_LANG is set correctly in your perl environment.
> > > > should be something like German_Germany.weiso8859-1
> > > >
> > > > Karsten
> > > >
> > > > In article <7uv1ce$am7$1_at_nnrp1.deja.com>,
> > > > lmarkus_at_my-deja.com wrote:
> > > > > Hello.
> > > > >
> > > > > I'm using Oracle 8i (8.1.5) and Oracle Application server4 on
> NT.
> > > > > my question is the following:
> > > > >
> > > > > how could I correctly extract special german characters using
> the
> > > > > perl/livehtml cartridge?
> > > > > what do I have to set up?
> > > > > I import data into several tables via SQL Loader.
> > > > > Displaying the rows in SQL+ shows me the correct character
> > > > > representations.
> > > > > In the application otherwise special characters get destroyed.
> > > > > [...]
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 27 1999 - 06:20:26 CDT