ID: 44003
Comment by: tyler dot reese at taqua dot com
Reported By: tceverling at yahoo dot co dot uk
Status: Open
Bug Type: ODBC related
Operating System: Windows XP SP2
PHP Version: 5.2.5
New Comment:
In /ext/odbc/php_odbc_includes.h, you can change the 'name' field, of
the 'odbc_result_value' struct, from 32 to 256 (or whatever length you
need), and then recompile PHP.
With that said, is this (changing 'name' length from 32 to 256) ever
going to be a permanent fix in any upcoming official version of PHP?
This same issue is reported in:
Bug #30043 ODBC Column Name Truncation (missing multi-byte support)
Previous Comments:
------------------------------------------------------------------------
[2009-04-17 13:09:35] netvbonline at yahoo dot co dot uk
This is over a year old? Has anyone been able to fix as I am using
latest version of PHP as of 17 Apr 2009 with dynamic queries and just
encountered this issue
Many Thanks :-))
------------------------------------------------------------------------
[2008-01-31 18:17:50] tceverling at yahoo dot co dot uk
Description:
------------
After executing a "SELECT" SQL query and then doing an
odbc_fetch_array(), field names longer than 31 characters gets
truncated.
Reproduce code:
---------------
<?php
$link = odbc_connect('MYSQL', '', ''); // Connect to MySQL
$res = odbc_exec($link, 'select * from test');
var_dump(odbc_fetch_array($res));
$link = odbc_connect('Access', '', ''); // Connect to Microsoft
Access
$res = odbc_exec($link, 'select * from test');
var_dump(odbc_fetch_array($res));
?>
Expected result:
----------------
Assuming that a field name within the table `test` is
'1234567890123456789012345678901234567890', expected result maybe like:
array(1) {
["1234567890123456789012345678901234567890"]=>
string(1) "1"
}
array(1) {
["1234567890123456789012345678901234567890"]=>
string(1) "1"
}
Actual result:
--------------
array(1) {
["1234567890123456789012345678901"]=>
string(1) "1"
}
array(1) {
["1234567890123456789012345678901"]=>
string(1) "1"
}
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=44003&edit=1
