I have used dotConnect for Oracle.
I have oracle database (11g) with NLS_NCHAR_CHARACTERSET = AL16UTF16 settings.
I use this test code in PL/Sql:
Code: Select all
create table a (b nvarchar2(1000));
insert into a values('űő');
select * from a;
But ¿¿ appear instead of 'ű' and 'ő', if I insert data to the table with dotConnector.
Test code:
Code: Select all
string sConnectionString = "User Id=<user>;Password=<pwd>;Server=<server>;Connection Timeout=30;Max Pool Size=150;Direct=True;Service Name=<srvname>;Unicode=true;";
OracleConnection connection = new OracleConnection(sConnectionString);
connection.Unicode = true;
connection.Open();
OracleCommand cmd = connection.CreateCommand();
cmd.CommandText = "insert into a (b) values (:data)";
cmd.Parameters.AddWithValue(":data", "űő");
cmd.ExecuteNonQuery();
OracleCommand cmd2 = new OracleCommand("select * from a", connection);
var read = cmd2.ExecuteReader();
while (read.Read())
Console.WriteLine(String.Format("{0}", read[0]));
read.Close();
connection.Close();
I tried it at windows 7 x64 and debian linux too and it worked similarly.
Thanks