From: j dot henge-ernst at interexa dot de
Operating system: linux
PHP version: 5CVS-2006-08-21 (snap)
PHP Bug Type: OCI8 related
Bug description: problems connection to database with
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
Description:
------------
php is unable to connect to the database if
NLS_LANG=GERMAN_GERMANY.<charset> is set to something other than
AMERICAN_AMERICA.<charset>
[EMAIL PROTECTED]:/tmp/phptest/install> export
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
[EMAIL PROTECTED]:/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)
[EMAIL PROTECTED]:/tmp/phptest/install> export
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
[EMAIL PROTECTED]:/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 bug report at http://bugs.php.net/?id=38533&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=38533&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=38533&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=38533&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=38533&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=38533&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=38533&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=38533&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=38533&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=38533&r=support
Expected behavior: http://bugs.php.net/fix.php?id=38533&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=38533&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=38533&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=38533&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38533&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=38533&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=38533&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=38533&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=38533&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=38533&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=38533&r=mysqlcfg
