From: nuzul dot hayat at gmail dot com
Operating system: CentOS
PHP version: 5.2.5
PHP Bug Type: ODBC related
Bug description: Oracle field name truncated to 15 characters using
ODBC/Instantclient
Description:
------------
Compiled PHP 5.2.5 with Apache 2.2.6 with UnixODBC support and other
standard options.
ODBC connection was set up using Instantclient version 10.2.0.3 ODBC
driver. When tested using isql, the output was OK but when execute using
PHP, the fields name truncated to only 15 chars resulting "Undefined Index"
notice. This may be a notice but has huge impact on the system.
for example:
SS_SUBJECT_STATUS truncated to SS_SUBJECT_STAT.
Surprisingly, it seems that I'm alone. The closest article i found was
field name limited to 30 chars but that is for MSSQL. Setting the
defaultlrl also not working as the problem is in the field name, not the
content.
Expected result:
----------------
isql output:
SQL> SELECT * FROM SUBJECT_SUMMARY s WHERE s.SS_SEMESTER_CODE='A042' AND
s.SS_SUBJECT_CODE='LSI2023' AND s.SS_LECT_GROUP='A'
+-----------------+--------------+----------------+--------------+------------------+------------------+------------------+------------------+------------------+--------------------+--------------------+------------------+
| SS_SEMESTER_CODE| SS_STUDENT_ID| SS_SUBJECT_CODE| SS_LECT_GROUP|
SS_TOTAL_CLASS | SS_ATTEND_COUNT | SS_LATE_COUNT | SS_ABSENT_COUNT |
SS_UNKNOWN_COUNT | SS_WARNING_DATE | SS_BAR_DATE |
SS_SUBJECT_STATUS|
+-----------------+--------------+----------------+--------------+------------------+------------------+------------------+------------------+------------------+--------------------+--------------------+------------------+
|
+-----------------+--------------+----------------+--------------+------------------+------------------+------------------+------------------+------------------+--------------------+--------------------+------------------+
Actual result:
--------------
php output:
SS_SEMESTER_COD SS_STUDENT_ID SS_SUBJECT_CODE SS_LECT_GROUP
SS_TOTAL_CLASS SS_ATTEND_COUNT SS_LATE_COUNT
SS_ABSENT_COUNT
SS_UNKNOWN_COUN SS_WARNING_DATE SS_BAR_DATE
SS_SUBJECT_STAT
--
Edit bug report at http://bugs.php.net/?id=43688&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=43688&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=43688&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=43688&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=43688&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=43688&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=43688&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=43688&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=43688&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=43688&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=43688&r=support
Expected behavior: http://bugs.php.net/fix.php?id=43688&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=43688&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=43688&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=43688&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=43688&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=43688&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=43688&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=43688&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=43688&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=43688&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=43688&r=mysqlcfg
