[Mono-bugs] [Bug 78840][Cri] New - Oracle Parameters

[bugzilla-daemon at bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by songzhou at freesky.com.cn.

http://bugzilla.ximian.com/show_bug.cgi?id=78840

--- shadow/78840	2006-07-12 23:24:54.000000000 -0400
+++ shadow/78840.tmp.32643	2006-07-12 23:24:54.000000000 -0400
@@ -0,0 +1,54 @@
+Bug#: 78840
+Product: Mono: Class Libraries
+Version: 1.1
+OS: RHEL 2.1
+OS Details: RHEL3.0
+Status: NEW   
+Resolution: 
+Severity: 016 Two days
+Priority: Critical
+Component: Sys.Data
+AssignedTo: tsenganal at novell.com                            
+ReportedBy: songzhou at freesky.com.cn               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Oracle Parameters
+
+Please fill in this template when reporting a bug, unless you know what 
+you are doing.
+Description of Problem:
+if where are chinese charactor in the parameter(input) of non-queries, 
+the rusult of non-queries is incorrect.
+
+Steps to reproduce the problem:
+1:
+OracleCommand command = new OracleCommand(); 
+2:
+command.CommandText = "insert into t_Country (ID, Name) values 
+(:ID, :Name)"
+3:
+command.Parameters.Add("ID",OracleType.VarChar,40).Value = "123";
+command.Parameters.Add("ID",OracleType.VarChar,40).Value = "’†‘China";
+4:
+command.ExecuteNonQuery();
+
+
+Actual Results:
+the result been saved in the Oracle DataAccess is 
+ID       Name
+123      ’†‘Chi
+
+Expected Results:
+the result been saved in the Oracle DataAccess is 
+ID       Name
+123      ’†‘China
+
+How often does this happen? 
+every time
+
+Additional Information:
+
+please give me the answer quickly ,thanks !!!
+"’†‘" is two chinese charactors.