Req #30043 [Opn->Csd]: ODBC Column Name Truncation (missing multi-byte support)

Edit report at https://bugs.php.net/bug.php?id=30043&edit=1 ID: 30043 Updated by: cmb@php.net Reported by: arobins at csg dot uwaterloo dot ca Summary: ODBC Column Name Truncation (missing multi-byte support) -Status: Open +Status: Closed Type: Feature/Change Request -Package: Feature/Change Request +Package: *General Issues Operating System: * PHP Version: 4CVS, 5CVS -Assigned To: +Assigned To: cmb Block user comment: N Private report: N New Comment: Thank you for your bug report. This issue has already been fixed in the latest released version of PHP, which you can download at http://www.php.net/downloads.php Fixed as of PHP 5.4.0. Previous Comments: ------------------------------------------------------------------------ [2006-02-17 16:14:29] bobbyboyojones at hotmail dot com PDO + PDO_ODBC seems to have a similar issue, only it seems to experience a fatal error when it runs into long column names. I have tried the solution of changing the field name buffer from 32 to 256 in the odbc_result_value typedef struct, and everything has been working fine with all of the databases I've tried it against. ------------------------------------------------------------------------ [2005-10-24 20:31:42] kalowsky@php.net As PDO gains more and more traction that's probably the best idea ------------------------------------------------------------------------ [2005-10-24 18:29:47] wez@php.net You could try PDO + PDO_ODBC as an alternative. ------------------------------------------------------------------------ [2005-10-24 17:55:28] kalowsky@php.net As stated in a private email, the biggest issue with such a change is how much it effects other databases beyond those that you have used. It's a simple change, but it's unknown what databases will fail with this. ------------------------------------------------------------------------ [2005-10-19 20:46:04] arobins at csg dot uwaterloo dot ca It's been over a year since my original submission, and I was wondering if it would be at all possible for someone to implement an increase in the field name buffer from 32 to 256? Only one line needs to be changed to accomplish this, in ext\odbc\php_odbc_includes.h: line 217: char name[32]; -> char name[256]; If it is at all possible for someone to make this minor modification for me, I would be extremely grateful! ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=30043 -- Edit this bug report at https://bugs.php.net/bug.php?id=30043&edit=1