C#/Oracle: Specify Encoding/Character Set of Query?

Posted by Reini on Stack Overflow See other posts from Stack Overflow or by Reini
Published on 2011-06-30T13:48:09Z Indexed on 2011/07/01 8:22 UTC
Read the original article Hit count: 344

I'm trying to fetch some Data of a Oracle 10 Database.
Some cells are containing german umlauts (äöü).
In my Administration-Tool (TOAD) I can see them very well: "Mantel für Damen" (Jacket for Women)
This is my C# Code (simplified):

var oracleCommand = new OracleCommand(sqlGetArticles, databaseConnection);
var articleResult = oracleCommand.ExecuteReader();
string temp = articleResult.Read()["SomeField"].ToString();
Console.WriteLine(temp);

The output is: "Mantel f?r Damen"
Tryed on Debugging (moving mouse over variable), Debug-Window, Console-Window, File.

I think I have to specify the Encoding/Character Set somwhere. But where?

© Stack Overflow or respective owner

Related posts about c#

Related posts about Oracle