C#/Oracle: Specify Encoding/Character Set of Query?
- by Reini
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?
