php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
 [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 (www.wappup.com) 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");

Patches

Pull Requests

History

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

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

Closed due missing feedback.

--Jani
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Wed Oct 30 22:01:28 2024 UTC