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 Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved. 		Last updated: Tue May 07 15:01:36 2024 UTC