Hi Paul,
>
> 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'));
G is CHAR(16) OCTETS. The string representation of a GUID is at least 36
chars long. It doesn't fit in 16 chars space.
>
> As Jiri said:
> Look like Guid in .NET has little bit different text representation than
> uuid_to_char from Firebird. Quaternions are swapped.
Not the text representation. The Microsoft GUID internal structure different
from FB's. This causes different byte order of the structs members.
This situation also happens in C or C++ using IBPP.
The problem is the different internal representation of the guid.
I can solve this by using stored procedures and UDFs, I just want to
indicate this problem.
Regs,
Zoltán
------------------------------------------------------------------------------
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
