Re: NLS_LANG client problem

The WEb (Apache) User and the oracle user has the same environment variables. With both users, from sqlplus, I can insert and get words with á,é,etc, but not from a php web page.

Any idea?
Thanks

"Anurag" <avdbi_at_hotmail.com> wrote in message news:<ujqi24bmmj6kd5_at_corp.supernews.com>...
> I don't know php ... but you should understand that:
> * Setting NLS_LANG for oracle user will set it for only that user.
> * Thus you need to make sure that the web user has this same envioronment variable set.
>
> Anurag
>
> "Fernando Donate" <fernandodonate_at_yahoo.es> wrote in message
> news:b0aa0c3a.0207230321.3c7d7edd_at_posting.google.com...
> > Hello list
> >
> > I have installed oracle client 9.0.1 in my Linux box.
> > my ~oracle/.bash_profile:
> >
> > umask 022
> > if [ -f ~/.bashrc ]; then
> > source ~/.bashrc
> > fi
> >
> > ORACLE_BASE=/usr/local/oracle
> > export ORACLE_BASE
> > ORA_NLS33=/usr/local/oracle/product/9.0.1/ocommon/nls/admin/data
> > export ORA_NLS33
> > NLS_LANG=SPANISH_SPAIN.WE8ISO8859P1
> > export NLS_LANG
> >
> > But when I insert data in the oracle DB server , from a form web (php)
> > that contains the 'ñ','á','é','í','ó' and 'ú' characteres, they don't
> > appear well in the Server
> >
> > Is anything missing?
> > Any missconfiguration?
> >
> > Thanks.
> > Fernando
Received on Wed Jul 24 2002 - 03:42:00 CDT