title: MySQL import in phpmyadmin (CSV) chokes on quotes
body: <p>I am trying to import a <strong>.csv file</strong> into a MySQL table via <strong>phpMyAdmin</strong>.</p>
  
  <p>The .csv file is separated by pipes, formated like this:</p>
  
  <pre>
  data|d'ata|d'a"ta|dat"a|
  data|"da"ta|data|da't'a|
  dat'a|data|da"ta"|da'ta|
  </pre>
  
  <p>The data contains quotes. I have no control over the format in which I recieve the data -- it is generated by a third party.</p>
  
  <p>The problem comes when there is a <strong>| followed by a double quote</strong>. I always get an "invalid field count in CSV input on line N" error.</p>
  
  <p>I am uploading the file from the import page, using Latin1, CSV, terminated by |, separated by ".</p>
  
  <p>I would like to just <strong>change the "enclosed by" character</strong>, but I keep getting <strong>"Invalid parameter for CSV import: Fields enclosed by"</strong>. I have tried various characters with no success.</p>
  
  <p><strong>How can I tell MySQL to accept this format in phpMyAdmin?</strong></p>
  
  <p>Setting up these tables is the first step in writing a program that will use uploaded gzipped .csv files to maintain the catalog of an e-commerce site.</p>