Strange problem with GetSchemaTable and utf8

[stofel]

Hi, I have a problem with an oracle DB which is installed with an utf8-characterset. I build a form in VS2005 where the user type in a SQL-selectstatement and the form executes it and displays the result. Everything works fine with a singlebytecharcterset. For example:

String sqltext = "Select artext from tbl_ar"; // artext is
// varchar2(30 char)
DataTable schTable;
OracleDataReader rdr = null;

OracleCommand cmd = new OracleCommand (sqltext, OracleConnection, OracleTransaction);
rdr = cmd.ExecuteReader(CommandBehavior.KeyInfo);
schTable = rdr.GetSchemaTable(); // Here the DataTable is filled with the
// information of the columns
DataRow fldDescr = schTable.Rows[0];
int len = (int) fldDescr[2]; // 2 = ColumnSize

In the database with the utf8-characterset the variable len hat the value 0f 90 instead of 30. Is there a way to get the correct result ? Thanks in advanced Stofel

[Wendelius]

Hi, Check that your character set is compatible at client side (HKEY_LOCAL_MACHINE\Software\Oracle....) Mika