Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NLS characterset problem (german)
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.
Received on Tue Oct 26 1999 - 09:36:26 CDT