title: PHP/json My field names are being truncated to 30 characters. Can I stop this?
body: <p>Ok so I got this piece of vendor software that they said should be run on an apache php server and MySql database.</p>
  
  <p>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.</p>
  
  <p>ex.<br>
  mysql_select_db -> mssql_select_db<br>
  (among other things)</p>
  
  <p>So I have the following code in a php file </p>
  
  <pre><code>$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).'}';
  </code></pre>
  
  <p>and my results look something like this (captured with fiddler 2)</p>
  
  <blockquote>
    <p>{"results":[{"KEY_FIELD":"57", "My30characterlongfieldthatiscu":"GoodValue"}]}</p>
  </blockquote>
  
  <p>"My30characterlongfieldthatiscu" should be "My30characterlongfieldthatiscutoff"</p>
  
  <p>Kinda weird, no?</p>
  
  <p>The vendor claims that the app works perfectly on their end.</p>
  
  <p>I'm thinking this is some sort of IIS PHP limit, is there a way around it or can I expand it?</p>
  
  <p>I found this solution
  <a href="http://www.php.net/manual/en/ref.mssql.php#74834" rel="nofollow noreferrer">http://www.php.net/manual/en/ref.mssql.php#74834</a>
  but I don't understand it.</p>
  
  <p>Thanks!</p>