title: MySQL LOAD DATA INFILE limits my import?
body: <p>I try to import data from a CSV to MySQL. For this I run mysql and log in with:</p>
  
  <pre><code>mysql -u USER -p --local-infile=1 DATABASE
  </code></pre>
  
  <p>and import data with:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE '/home/USER/FILENAME.csv' 
  INTO TABLE TABLENAME 
  FIELDS TERMINATED BY ';' 
  ENCLOSED BY '"' 
  LINES TERMINATED BY '\n';
  </code></pre>
  
  <p>First I thought everything is fine because the data was loaded and looked good so far but then I got some problems and found out that strings are limited to 32756 characters in my longtext column. So I'm sure I forgot something but couldn't find the answer until know :(</p>