Bug #65950 [Com]: Field name truncation if the field name is bigger than 32 characters

Edit report at https://bugs.php.net/bug.php?id=65950&edit=1 ID: 65950 Comment by: charles dot durrant at thomsonreuters dot com Reported by: michael dot y at zend dot com Summary: Field name truncation if the field name is bigger than 32 characters Status: Closed Type: Bug Package: ODBC related Operating System: Linux PHP Version: 5.4.21 Assigned To: yohgaki Block user comment: N Private report: N New Comment: I had this problem, patch appreciated Previous Comments: ------------------------------------------------------------------------ [2013-11-04 09:00:06] ab@php.net Automatic comment on behalf of yohgaki Revision: http://git.php.net/?p=php-src.git;a=commit;h=e50eb1ce3408d15cd26fd88203c68f52e59f6b0b Log: Fixed bug #65950 Field name truncation if the field name is bigger than 32 characters ------------------------------------------------------------------------ [2013-10-28 09:44:32] yohgaki@php.net 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 http://git.php.net/?p=php-src.git;a=commitdiff;h=e50eb1ce3408d15cd26fd88203c68f52e59f6b0b ------------------------------------------------------------------------ [2013-10-26 23:01:58] yohgaki@php.net Patches for branches is ready, but git is closed now. Assign this to myself. ------------------------------------------------------------------------ [2013-10-25 23:11:07] yohgaki@php.net I think SQL standard is 128, but 256 should work also. (There may be DBMS that has larger limit) Checked php_obdb.c and it look fine with your patch. I'll apply your patch. Thank you. ------------------------------------------------------------------------ [2013-10-23 11:49:01] michael dot y at zend dot com Description: ------------ Field names are truncated to 30 charactes if they are bigger than 32 bytes in MS SQL Server. If i am using odbc php extension that connects to unixodbc + freetds. Test script: --------------- <?php $cnx = odbc_connect("Driver=FreeTDS; Server=10.9.178.47;port=1433;Database=AdventureWorks;CHARSET=UTF-8;TDS_Version=8.0;", "sa", "pass"); $query = "SELECT * FROM dbo.Roman"; $res = odbc_exec($cnx,$query); while( $row = odbc_fetch_array($res) ) { print_r($row); } echo $cnx; ?> Expected result: ---------------- Roman table there is a field which name is hello_one_two_three_four_five_six_seven_eight_nine_ten_eleven. Actual result: -------------- It is truncated to hello_one_two_three_four_five_ . ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=65950&edit=1