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 [EMAIL PROTECTED] http://bugzilla.ximian.com/show_bug.cgi?id=75420 --- shadow/75420 2005-06-29 10:34:06.000000000 -0400 +++ shadow/75420.tmp.24058 2005-06-29 10:34:06.000000000 -0400 @@ -0,0 +1,53 @@ +Bug#: 75420 +Product: Mono: Class Libraries +Version: 1.1 +OS: +OS Details: Ubuntu Linux 5.04 x86 +Status: NEW +Resolution: +Severity: +Priority: Normal +Component: Sys.Data.SqlClient +AssignedTo: [EMAIL PROTECTED] +ReportedBy: [EMAIL PROTECTED] +QAContact: [EMAIL PROTECTED] +TargetMilestone: --- +URL: +Cc: +Summary: Bytes swapped when inserting Guid in a table + +Description of Problem: + +When trying to insert a new row in an MS SQL database table with a Guid +column, first 3 Guid elements are byte-swapped. + +Example: + +1. Create a table (Table1) with a Guid column (Id) +2. Try to run a simple insert query from a Mono application: + +INSERT INTO Table1 (Id) VALUES (0x03145b8a2fe248d7833599e18cbf43f8) + +3. Check newly inserted row with Enterprise Manager. You will see that this +Guid is inserted: + +8A5B1403-E22F-D748-8335-99E18CBF43F8 + +Actual Results: +8A5B1403-E22F-D748-8335-99E18CBF43F8 + + +Expected Results: +03145b8a-2fe2-48d7-8335-99e18cbf43f8 + +How often does this happen? +Always + +Additional Information: +The same thing is happening when you use Enterpise Manager to run this +query. So I think it's maybe a MS SQL server bug. Do you want me to provide +a workaround for this bug (Guid should be sent in form of +{03145b8a-2fe2-48d7-8335-99e18cbf43f8} so it's only 4 characters per Guid more) + +Cheers, +Aleksandar Dezelin _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
