title: FoxPro - character limit on column names with INTO TABLE
body: <p>One of our systems is still running on a Visual FoxPro database. It's the bane of my life.</p>
  
  <p>While investigating a recent error, I discovered it was being caused by a misnamed column. The original DB has a table called <code>SELECTIONS</code> with a column called <code>mediumValue</code>, which is eleven characters long. The error was being caused by another table based on that data having the column renamed to <code>mediumValu</code>.</p>
  
  <p>The source of the problem appears to be this statement:</p>
  
  <pre><code>SET DELETED ON
  SELECT selections.*;
   FROM ;
       SELECTIONS;
   WHERE 
  //criteria
   INTO TABLE Result.dbf  
  </code></pre>
  
  <p>If you just run the select without the <code>INTO TABLE</code>, the column appears named as <code>mediumValue</code>. But with the <code>INTO TABLE</code>, the resulting <code>Result.dbf</code> table has the column named as <code>mediumValu</code>.</p>
  
  <p>Am I right in thinking this is some sort of inbuilt truncation, and is it documented anywhere? Is there any sort of setting I can override to fix it?</p>