title: Reading a CSV w/ CFFile & Non-Roman Characters
body: <p><strong>Update:</strong> The original CSV was created in Excel; when I copied the data in to a Google Spreadsheet and downloaded a CSV from Drive, it works fine. I'm guessing there's an encoding issue w/ the Excel CSV? Is there any way to work around this w/ Excel or do we need to tell our clients to use Google docs? </p>
  
  <p>I've got a CSV w/ non-roman characters (my example is in French, but we support entirely non-roman languages such as Arabic and Thai as well) that I'm reading via ColdFusion's cffile. The problem is the output from the read is converting all the accented characters into a weird ? symbol (�). There was originally no charset specified on the cffile, so I tried adding utf-8 (no change) and utf-16 (everything is converted to sort-of Chinese?). </p>
  
  <p>Anyone know how I can get this data out of the CSV without losing/messing up the characters?</p>
  
  <p>CSV Example:</p>
  
  <blockquote>
    <p>Smith,Joan,joan.smith@test.com,Hôpital Jésus</p>
  </blockquote>
  
  <p>Original cffile:</p>
  
  <pre><code>&lt;cffile action="read" file="#expandedFilePath#" variable="strCSV"&gt;
  </code></pre>
  
  <p>cffile w/ charset added:</p>
  
  <pre><code>&lt;cffile action="read" file="#expandedFilePath#" variable="strCSV" charset="utf-8"&gt;
  </code></pre>
  
  <p>cfdump of strCSV (no charset/utf-8 charset):</p>
  
  <blockquote>
    <p>Smith,Joan,joan.smith@test.com,H�pital J�sus</p>
  </blockquote>
  
  <p>cfdump of strCSV (utf-16 charset):</p>
  
  <blockquote>
    <p>卭楴栬䩯慮ⱪ潡渮獭楴桀瑥獴⹣潭ⱈ楴慬⁊畳ഊ</p>
  </blockquote>