Entry

set the putenv(NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1), but when i insert via the php scipts chars like "äöü" oracle get them as "|{}",same sqlplus ok

Apr 27th, 2004 23:46
Eyzen Medina, Guest,

Hi, this will not work. You have to do 2 configurations task
I will explain a sample with Oracle in Linux. I do this one year ago 
and works.

First you have to edit the file

$ORACLE_HOME/product/9.x.x/dbs/init.ora

Put this twoo lines and remove if allready exists the VARS 
(NLS_LANGUAGE and NLS_CHARACTERSET)

NLS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
NLS_CHARACTERSET=WE8ISO8859P1

The other task it's put in the oracle user (The DB Oracle User) the var 
NLS_LANG in the .bash_profile file.

export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

After that, restart oracle.

I was restared the linux too. :)

This method works me at this time, the linux machine was using oracle 
9i first version.

I hope tha's help you.

Eyzen