title: importing a csv file into mysql as BLOB
body: <p>I'm working on test scripts and I want to load the results.csv file into a database as a BLOB. 
  Basically I want my table to look like:</p>
  
  <p>serial_number | results |. </p>
  
  <p>So one row for each device. My code would look like this for a device with serial number A123456789 (changed names and path for simplicity). The table is called test.</p>
  
  <pre><code>create table test (serial_number varchar(20), results longblob);
  insert into test values ('A123456789',load_file('C:/results.csv'));
  </code></pre>
  
  <p>When I do this, however, the second column which should contain a BLOB, comes out containing NULL, with no exceptions raised.</p>
  
  <p>If I open my results.csv file in notepad, then save as .txt file with no changes whatsoever, I get exactly what I want when I run the same code substituting ".csv" with ".txt" in the path. Basically it would also solve my problem if I could load the csv file as a text file.</p>
  
  <p>thanks for anything you may be able to contribute.</p>