ID: 43688
Updated by: [EMAIL PROTECTED]
Reported By: nuzul dot hayat at gmail dot com
-Status: Open
+Status: Feedback
Bug Type: ODBC related
Operating System: CentOS
PHP Version: 5.2.5
New Comment:
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.
Please avoid embedding huge scripts into the report.
Previous Comments:
------------------------------------------------------------------------
[2007-12-27 14:36:35] nuzul dot hayat at gmail dot com
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 this bug report at http://bugs.php.net/?id=43688&edit=1
