title: mysql> error 1265: data truncated for column 'xxx' at row 1
body: <p>I'm trying to import a csv file into a table in a mysql database. The table has 141 columns with datatypes of <code>INT</code>, <code>VARCHAR(20)</code>, <code>TIMESTAMP</code>,<code>TIMESTAMP</code>, and then a series of <code>TINYTEXT</code>s and <code>VARCHAR(4)</code>s.</p>
  
  <p>I'm getting 7 data truncated errors on columns with datatype <code>VARCHAR(4)</code> for which the data does <strong>not</strong> exceed 4 characters.</p>
  
  <p>I tried forcing it to continue with <code>IGNORE</code>, but then it went crazy and chopped data from <em>other</em> cells into pieces and scattered them throughout the table.</p>
  
  <p>I'm using the command-line on an MS 2008 R2 Server to run the SQL and the csv file is located in the Db's directory.</p>
  
  <p>P.S. I did read several of the other posts and google results related to mysql+import or mysql+data truncated (1265), but they didn't seem to cover this particular issue.</p>
  
  <p>Thanks!</p>
  
  <p><b>EDIT</b>: I'm pretty sure it has something to do with the <code>LOAD DATA</code> function because if I <code>INSERT</code> one row at a time, it works just fine…</p>
  
  <p>My sql for the import is:</p>
  
  <pre><code>LOAD DATA INFILE '2011-09.csv' IGNORE INTO TABLE `survey`.`2011-09` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
  </code></pre>