.net binary guid/uuid, almost?

[Elijah Glover]

Hi,

The newest mysql datalayer returns a guid datatype if a binary(16) is returned.
It looks to me like .net is picking up the wrong uuid/guid... in the wrong format

Formatted GUID Returned From .net mysql datalayer.
f06601f3-e979-dd40-a397-4c0caeb5bf0b

Original GUID: (should be)
f30166f0-79e9-40dd-a397-4c0caeb5bf0b

As you can see it has all the correct hex chars, in a different order.

Table Has A Binary(16) Primary Key Column, That parts fine.
SQL UNHEX(REPLACE(uuid(), '-', '')) this is the SQL that i am using to encode guid/uuid stirng to binary.

Its just when i run a datareader. and use guid.tostring

Any Ideas?



Edited 1 time(s). Last edit at 09/16/2008 07:47AM by Elijah Glover.