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

go to bug id or search bugs for

Doc Bug #11220 special chars insertion into oracle / NLS_LANG
Submitted: 2001-05-31 13:50 UTC Modified: 2002-06-08 11:34 UTC
From: izzy at einsurance dot de Assigned:
Status: Closed Package: Documentation problem
PHP Version: 4.0.5 OS: SuSE Linux 7.0 / 7.1
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: izzy at einsurance dot de
New email:
PHP Version: OS:

 

 [2001-05-31 13:50 UTC] izzy at einsurance dot de 
Having problems to insert special chars (as German Umlaute 
like "???") into oracle using oci8 functions. Tried to set 
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 (as we use for all 
other applications here), but then I am not even able to 
connect to the database any more.
I saw some other bugs similiar to this one, some closed 
but still unsolved - I hope I have more luck with an 
answer helping me to solve my problem. Since I'm already 
asked a couple of times to migrate to Java... No answer 
will be a bad answer :)
If special settings (like php.ini or configure line) are 
relevant, please let me know - so I'll supply them.
Thanx
Izzy.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-31 18:21 UTC] sniper@php.net 
As you are from Germany you might understand this better:

http://www.php-center.de/faq/faq-database_oracle.html

I'm not 100% sure it has the answer..but seems like it. :)
Please let us know if it does so some of it could
be added to our manual.

--Jani
 [2001-06-01 02:15 UTC] izzy at einsurance dot de 
Other than I wrote in my mail (in-reply-to your comment), 
it appears that the setting of ORA_NLS33 *before* NLS_LANG 
brings the "Lock" down - at least I can connect to the 
database with it (which I couldn't without). But since I 
have no necessary permission to set those vars in the 
Apache startup script (missing the root login to that 
server ;) I can't tell now wether it really *solves* the 
problem, since I only can use putenv() for testing here 
(the setting with putenv() seems to have no effect, I 
still get the "old" default settings by "SELECT 
USERENV('LANGUAGE') FROM dual". As soon as I can check 
that with the server admin I will do - and report it here 
then.
Thanx for your help so far!
Izzy.
 [2001-06-01 02:45 UTC] izzy at einsurance dot de 
Just found somebody to do the job on the server. Following 
is the solution:

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=<language>_<country>.<charset>

of course, after setting all the other environment 
variables, especially ORACLE_HOME ;)

So you may now a) consider this bug closed and b) add this 
solution to the dox/faq. I will go look at the online dox 
if I can add a "user comment" meanwhile ;)

Again, thank you for your fast help and solution!

Izzy.
 [2001-06-01 15:59 UTC] sniper@php.net 
The current documentation does mention all
these environment vars that should be used,
but doesn't have any examples/information what
to set as the values.
 [2002-06-08 11:34 UTC] mfischer@php.net 
It's not our problem/job what values to use. There are *tons* of oracle documentation out there. Oracle is not a kiddy database, so people should read the books. Closing.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Sep 19 15:01:27 2024 UTC