title: Problems with foreign language encoding in CSV in Visual Basic
body: <p>I have a VB.Net script saving a CSV from a database which contains Japanese, Chinese, Korean, and English characters. </p>
  
  <p>The file opens fine in a plain text editor, but in Excel it shows either the "question mark" character, other apparently randomly characters, or dashes. It does this no matter which encoding format I choose when importing the data.</p>
  
  <p>The code I have to open the file looks like this</p>
  
  <pre><code>  Response.ContentType = "text/csv"
    Response.AddHeader("Content-Disposition", "attachment; filename=notifications.csv")
    Dim utf8 As New UTF8Encoding()
    Dim strW As New IO.StreamWriter("\windows\temp\notifications.csv", False, utf8)
    strW.Write(utf8.GetPreamble())
  </code></pre>
  
  <p>*<em>EDIT: *</em> Apparently this only happens in Excel 2011 for Mac</p>