|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #8708 special chars insertion into oracle / NLS_LANG ?
Submitted: 2001-01-15 07:20 UTC Modified: 2001-03-09 21:11 UTC
From: jl dot barranger at wappup dot com Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0.1pl2 OS: linux mandrake
Private report: No CVE-ID: None
 [2001-01-15 07:20 UTC] jl dot barranger at wappup dot com
hi !

this our very painful problem...

we've been able to use php4.O.0 with Oracle 8i and use OCI functions to insert and retrieve datas in Our TAbles..

We can't do it no more, as special chars are transformed badly on insert... maybe since we installed PHP 4.01 pl2.

Apache config as been checked as well as Oracle.

with php 4.0.0 the virtual host was configured with an special NLS_LANG env. var set to the WE8DEC value... wich seems to be very specific and not so usual...

this value is still registerd but can't resolve the problem.

any other script (perl) from anyother source than our web server ( is able to insert proper datas... but our php scripts can't.

we tried to set an environnement variable with php special functions, but it changed nothing.

we're in contact with Oracle support but i'm afraid they won't help us...

is there anyone in your brillant team who will send us a solution ???

thanks for all and patience in uncrypting myvery poor english

cusoon("jl barranger");


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2001-01-15 07:28 UTC]
You should set the environment variables in the shell before starting Apache NOT with PHP's putenv(). 

 [2001-03-09 21:11 UTC]
Also try PHP 4.0.4pl1 if setting the environment vars 
doesn't help.

Closed due missing feedback.


PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Fri Oct 07 12:03:43 2022 UTC