title: LINQ query on datatable changes encoding
body: <p>I have a datatable with Locale nb-NO and TextInfo ANSICodePage 1252.
  I run the following code:</p>
  
  <pre><code>IEnumerable&lt;DataRow&gt; ieDatarow = (from row in dtDatatable.AsEnumerable()
                                    where row.ItemArray[row.Table.Columns.IndexOf(strColumn)].ToString() == strValue &amp;&amp; row.ItemArray[2].ToString() != "strServiceAccount"
                                    select row).OrderByDescending(x =&gt; x.ItemArray[0]).Distinct();
  </code></pre>
  
  <p>Looking at the data in ieDatarow, strings with characters like æ, ø and å become like this: "Ã¸"</p>
  
  <p>With this code the characters do not change:</p>
  
  <pre><code>IEnumerable&lt;DataRow&gt; ieDatarow = ArgDatatable.AsEnumerable().OrderByDescending(x =&gt; x.ItemArray[0]).Distinct()
  </code></pre>
  
  <p>How can I retain the encoding from the datatable?</p>