title: MySQL LOAD DATA with multiline data
body: <p>I'm having problems with Mysql's LOAD DATA command. </p>
  
  <p>With simple data, it works fine. </p>
  
  <p>When I try to load in data which is long, and has a field which extends over many lines, it fails.</p>
  
  <p>Here's my input data. Fields are tab-delimited. </p>
  
  <pre><code>1   2008-06-27 12:00:00 Type-Safe Enumerations  title Fr    5   
  ...line 1..
  ...line 2....   
      \N  2002-10-01 12:00:00 END-OF-THE-LINE
  2   2008-06-27 12:00:00 Class for constants Classe pour constantes  1   
  line 1...
  ..line 2..
      \N  2002-10-01 12:00:00 END-OF-THE-LINE
  4   2008-06-27 12:00:00 Another Énumérations    5   
  line 1
  line 2
      \N  2002-10-01 12:00:00 END-OF-THE-LINE
  5   2008-06-27 12:00:00 And Another Énumérations    5   
  line 1
  line 2
      \N  2002-10-01 12:00:00 END-OF-THE-LINE
  </code></pre>
  
  <p>And here's the LOAD DATA command:</p>
  
  <pre><code>&gt;LOAD DATA LOCAL INFILE "TopicInfileText2.dat" INTO TABLE Topic 
       LINES TERMINATED BY "END-OF-THE-LINE";
  </code></pre>
  
  <p>The target table :</p>
  
  <pre><code>CREATE TABLE Topic (    
      Id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
      LastEdit TIMESTAMP NOT NULL,             
      TitleEnglish VARCHAR(75) NOT NULL,
      TitleFrench VARCHAR(75),
      ChapterId SMALLINT NOT NULL References Chapter,             
      BodyEnglish TEXT NOT NULL,             
      BodyFrench TEXT,             
      CreationDate DATETIME NOT NULL,
      PRIMARY KEY (Id)
  );
  </code></pre>
  
  <p>Warnings from MySQL</p>
  
  <pre><code>| Incorrect integer value: '
  2' for column 'Id' at row 2 |
  | Incorrect integer value: '
  4' for column 'Id' at row 3 |
  | Warning | 1366 | Incorrect integer value: '
  5' for column 'Id' at row 4 |
  | Warning | 1366 | Incorrect integer value: '
  ' for column 'Id' at row 5  |
  </code></pre>