title: CSV file export with encoding issues
body: <p>I'm trying to export a SQL Server table into a CSV file:</p>
  
  <p>Data in the table is like = Presentación or Difusión</p>
  
  <p>All is working good... but in the <code>.CSV</code> file I find:</p>
  
  <pre><code>Presentaci&amp;#243;n or Difusi&amp;#243;n
  </code></pre>
  
  <p>This is my .cs code:</p>
  
  <pre><code>GridView1.AllowPaging = false;
  GridView1.DataBind();
  
  StringBuilder sb = new StringBuilder();
  
  for (int k = 0; k &lt; GridView1.Columns.Count; k++)
  {
      // add separator
      sb.Append(GridView1.Columns[k].HeaderText + ';');
  }
  
  // append new line
  sb.Append("\r\n");
  
  for (int i = 0; i &lt; GridView1.Rows.Count; i++)
  {
      for (int k = 0; k &lt; GridView1.Columns.Count; k++)
      {
          // add separator
          sb.Append(GridView1.Rows[i].Cells[k].Text + ';');
      }
  
      // append new line
      sb.Append("\r\n");
  }
  
  Encoding encoding = Encoding.UTF8;
  
  Response.Clear();
  Response.Buffer = true;
  Response.AddHeader("content-disposition", "attachment;filename=OrigenDatos.csv");  
  Response.Charset = encoding.EncodingName;
  Response.ContentType = "application/text";
  Response.ContentEncoding = Encoding.Unicode;
  Response.Output.Write(sb.ToString());
  Response.Flush();
  Response.End();
  </code></pre>
  
  <p>Is UTF-8 the true charset?</p>