title: C# .net Core and Oracle set encoding
body: <p>In web-api project on <code>.Net Core</code> has connect to <code>Oracle</code> DB via <code>dotNetCore.data.OracleClient (nugget package)</code></p>
  
  <p>I read data from pipelined funxction like this:</p>
  
  <pre><code> using (DbConnection connection = new OracleConnection("oraclecs")) {
      connection.Open();
  
      using (var cmd = connection.CreateCommand()) {
        cmd.CommandType = CommandType.Text;
  
        cmd.CommandText = "select name from Table(SCHEMA.PACKAGE.FUNC(PARAM1=&gt;1,PARAM2=&gt;4))";
  
        DbDataReader er = cmd.ExecuteReader();
        while (er.Read()) {
          string Name = er.GetValue(er.GetOrdinal(name: "name")).ToString();
        }
        connection.Close();
      }
    }
  </code></pre>
  
  <p>Name in database in Russian language 
  DB encoding <code>NLS_CHARACTERSET</code> is <code>CL8MSWIN1251</code></p>
  
  <p>When I got value from field <code>name</code> I see ???????? instead of real name</p>
  
  <p>Also just <code>select</code> in command text via <code>Oracle SQL Developer</code> return correct data</p>
  
  <p>What can help me to fix it?</p>