#38533 [Opn->Bgs]: problems connection to database with NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
| From: | tony2001@php.net | Date: | Mon, 21 Aug 2006 13:17:25 +0000 |
| Subject: | #38533 [Opn->Bgs]: problems connection to database with NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-101064@lists.php.net to get a copy of this message | ||
ID: 38533
Updated by: tony2001@php.net
Reported By: j dot henge-ernst at interexa dot de
-Status: Open
+Status: Bogus
Bug Type: OCI8 related
Operating System: linux
PHP Version: 5CVS-2006-08-21 (snap)
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[2006-08-21 12:52:28] 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)))'));
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=38533&edit=1