#43688 [Opn->Fbk]: Oracle field name truncated to 15 characters using ODBC/Instantclient

ID: 43688 Updated by: tony2001@php.net 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