Online Shopping : Computers : Programming : Languages : PHP : Database Backed Sites : Oracle

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

84 of 150 people (56%) answered Yes
Recently 8 of 10 people (80%) answered Yes

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