[Mono-bugs] [Bug 63539][Min] Changed - OdbcDataReader: TINYINT retrieved as System.Int16 instead of System.Byte

[bugzilla-daemon@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 tsureshkumar@novell.com.

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

--- shadow/63539	2004-08-26 13:10:17.000000000 -0400
+++ shadow/63539.tmp.9843	2004-08-27 09:58:00.000000000 -0400
@@ -1,13 +1,13 @@
 Bug#: 63539
 Product: Mono: Class Libraries
 Version: unspecified
 OS: unknown
 OS Details: 
-Status: REOPENED   
-Resolution: 
+Status: RESOLVED   
+Resolution: FIXED
 Severity: Unknown
 Priority: Minor
 Component: Sys.Data
 AssignedTo: tsureshkumar@novell.com                            
 ReportedBy: sebastien.robitaille@croesus.com               
 QAContact: mono-bugs@ximian.com
@@ -115,6 +115,26 @@
 
 Regards
 Sébas
 
 PS: I really appreciate your effort and rapidity for fixing the bugs 
 I submit. Thanks.
+
+------- Additional Comments From tsureshkumar@novell.com  2004-08-27 09:57 -------
+yes. Thanks for pointing out.
+
+TinyInt should return System.Byte. Unfortunately, when I tested with
+MySql, MS runtime returned System.Int16. There might be an issue in
+MySql ODBC driver for windows. When I checked with SqlServer, it was
+returning Byte. However, the MySQL ODBC driver for linux returns
+correct return type.
+
+The problem is fixed in CVS. 
+
+NOTE: However, as MySQL ODBC Driver 3.51 returns SQL_C_SSHORT for
+TinyInt column on windows, This will differ in behavior  with linux
+environment.
+
+please refer
+http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconmappingnetdataproviderdatatypestonetframeworkdatatypes.asp
+for mapping between ODBC DataProvider type to .NET Framework Type.
+