Hi Everyone!

Ok so I got this piece of vendor software that they said should be run on an apache php server and MySql database.

I didn't have either of those so I put it on a PHP IIS server and I converted the code to work on SQL server.

ex.
mysql_select_db -> mssql_select_db
(among other things)

So I have the following code in a php file

$query = "SELECT * FROM TableName WHERE KEY_FIELD = '".$keyField."';";

$result = mssql_query($query); 

$arr = array();
while ( $obj = mssql_fetch_object($result) ) 
{
    $arr[] = $obj;  
}

echo '{"results":'.json_encode($arr).'}';

and my results look something like this (captured with fiddler 2)

{"results":[{"KEY_FIELD":"57", "My30characterlongfieldthatiscu":"GoodValue"}]}

"My30characterlongfieldthatiscu" should be "My30characterlongfieldthatiscutoff"

Kinda weird, no?

The vendor claims that the app works perfectly on their end.

I'm thinking this is some sort of IIS PHP limit, is there a way around it or can I expand it?

I found this solution http://www.php.net/manual/en/ref.mssql.php#74834 but I don't understand it.

Thanks!