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
 [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-2025 The PHP Group
All rights reserved. 		Last updated: Tue Nov 04 22:00:01 2025 UTC