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

go to bug id or search bugs for

Bug #38533 problems connection to database with NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
Submitted: 2006-08-21 12:52 UTC Modified: 2006-08-21 13:17 UTC
From: j dot henge-ernst at interexa dot de Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 5CVS-2006-08-21 (snap) OS: linux
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: j dot henge-ernst at interexa dot de
New email:
PHP Version: OS:

 

 [2006-08-21 12:52 UTC] j dot henge-ernst at interexa dot de 
Description:
------------
php is unable to connect to the database if NLS_LANG=GERMAN_GERMANY.<charset> is set to something other than AMERICAN_AMERICA.<charset>

hernst@kingdomend:/tmp/phptest/install> export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
hernst@kingdomend:/tmp/phptest/install> bin/php test.php
X-Powered-By: PHP/5.2.0RC3-dev
Content-type: text/html

resource(1) of type (oci8 connection)
hernst@kingdomend:/tmp/phptest/install> export NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
hernst@kingdomend:/tmp/phptest/install> bin/php test.php
X-Powered-By: PHP/5.2.0RC3-dev
Content-type: text/html

<br />
<b>Warning</b>:  oci_connect() [<a href='function.oci-connect'>function.oci-connect</a>]: ORA-00604: error occurred at recursive SQL level 1
ORA-00922: missing or invalid option in <b>/tmp/phptest/install/test.php</b> on line <b>3</b><br />
bool(false)

Additional this php crashes if the third parameter (dbname) of oci_connect is ommited

Using oracle 10g with oci8:
Version               1.2.1
Revision              $Revision: 1.269.2.16.2.18 $

connect with sqlplus works for both NLS_LANG settings

Reproduce code:
---------------
var_dump(oci_connect('scott', 'tiger', '(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = example.com)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = example)))'));

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-08-21 13:17 UTC] tony2001@php.net 
Apparently Oracle Client library has some problems with your charset (I get "ORA-01017: invalid username/password; logon denied" with your NLS_LANG value) and there is nothing we can do about it.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri May 09 17:01:28 2025 UTC