[2013-10-23 11:49 UTC] 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_ .