PHP Bug: Oracle field name truncated to 15 characters using ODBC/Instantclient
28-December 2007.
700
1 Have anyone else experience this bug/issue?
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.
If you have any suggest, feel free to drop a comment here.
No tag
» shutterspeaks:
on 28-December 2007 at 16:28 PM | Quote
It's PHP bug, please someone reply soon. Nobody reply at php bug tracker. If you guys don't know the solution, please vote the bug as important. Why it is a PHP bug and not Oracle or Oracle ODBC driver bug, because the isql works perfectly.
I can't find any article about this on google. The closest being truncated to 30 character and also for MSSQL.