[Mono-bugs] [Bug 66087][Min] Changed - Using uniqueidentifier parameters with Tds70 and SQL 2000 doesn't work

[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 dezelin at gmail.com.

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

--- shadow/66087	2005-06-30 04:13:16.000000000 -0400
+++ shadow/66087.tmp.15201	2005-06-30 04:16:47.000000000 -0400
@@ -114,6 +114,24 @@
 *** Bug 75405 has been marked as a duplicate of this bug. ***
 
 ------- Additional Comments From dezelin at gmail.com  2005-06-30 04:13 -------
 Created an attachment (id=15403)
 A patch that fixes this bug
 
+
+------- Additional Comments From dezelin at gmail.com  2005-06-30 04:16 -------
+A NOTE:
+
+Only the first 3 parts of the Guid are incorrectly interpreted when
+sending uniqueidentifier in hex format. They are byte-swapped.
+
+Try this with Enterprise Manager:
+
+INSERT INTO Table1 (Id) VALUES (0x03145b8a2fe248d7833599e18cbf43f8)
+
+and you'll get this Guid in table:
+
+8A5B1403-E22F-D748-8335-99E18CBF43F8
+
+
+Cheers,
+Aleksandar Dezelin