Hi Zoltan
I have had same problem...
Try to insert guid as char, don’t convert to guid.
INSERT INTO T(G) VALUES('12345678-1234-1234-1234-123456789ABC');
>INSERT INTO T(G) VALUES(CHAR_TO_UUID('12345678-1234-1234-1234-123456789ABC'));
>SELECT UUID_TO_CHAR(G) FROM T;
>Result: '12345678-1234-1234-1234-123456789ABC'
>Result by FB.NET client SELECT G FROM T: (FB.NET handles CHAR(16) OCTETS as
>Guid)
>'56781234-1234-1234-3412-34127856BC9A'
[PM] as you can se...my problem is the same if I convert to uuid:
String from Membership: d1f5d194-5fa8-4ba1-bcf5-a4a788b58c1a
String from database: D194D1F5-5FA8-4BA1-F5BC-A7A4B5881A8C
As Jiri said:
Look like Guid in .NET has little bit different text representation than
uuid_to_char from Firebird. Quaternions are swapped.
BTW I think, that you should compare not strings but the guid values as
bytes/octets directly.
Best Regards,
Paul
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
