#30043 [Com]: ODBC Column Name Truncation (missing multi-byte support)

ID: 30043 Comment by: bobbyboyojones at hotmail dot com Reported By: arobins at csg dot uwaterloo dot ca Status: Open Bug Type: Feature/Change Request Operating System: * PHP Version: 4CVS, 5CVS New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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! ------------------------------------------------------------------------ [2004-11-03 16:52:01] arobins at csg dot uwaterloo dot ca Until 'true multi-byte support' comes along, might I suggest as a temporary solution simply increasing the field name buffer? (i.e. from 32 to 256) ------------------------------------------------------------------------ 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 http://bugs.php.net/30043 -- Edit this bug report at http://bugs.php.net/?id=30043&edit=1