title: Save UTF8 string by SqlBulkCopy c#
body: <p>I have this Sql query:</p>
  
  <pre><code>INSERT INTO myTable (myField) VALUES (N'Thermal Oxide: 0 Å to 40 μm')
  </code></pre>
  
  <p>and I want to exeute it by SqlBulkCopy like that:</p>
  
  <pre><code>DataTable myDataTable=myDb.getData("select top 1* from myTable").Clone();
  DataRow dr = myDataTable.NewRow();  
  dr["myField"] ="N'Thermal Oxide: 0 Å to 40μm'";
  myDataTable.Rows.Add(dr);
  this.openCon();
  using (SqlBulkCopy bulkCopy = new SqlBulkCopy(con))   {
      bulkCopy.DestinationTableName = dt.TableName;
      bulkCopy.BulkCopyTimeout = 100;
      bulkCopy.WriteToServer(myDataTable);
  }   this.closeCon();
  </code></pre>
  
  <p>It is work perfect, but my question is: where can I initilize the 'N' prefix? and maybe there is no need?</p>
  
  <p>Thanks,
  chani</p>