Quoting Benoit Gregoire <[EMAIL PROTECTED]>:
> On Thursday 26 October 2006 22:43, Phil Longstaff wrote:
>> 3) All object ids are (or should be) GUIDs. A GUID is represented by a
>> set of 4 int fields. I use this instead of varbinary because it isn't
>> variable length. I don't use any text type because I don't want any
>> issues with 0x00 as a char in a GUID.
>
> Fair enough, it's fixed length. But it will make for really ugly SQL for
> JOINS, with the only benefit of saving four bytes. I think using a varbinary
> is much preferable (and just as portable).
Or a varchar(32) and the hexstring... Just as portable and actually
human-readable (and human-enterable). Not that I'm biased or anything
;)
-derek
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
[EMAIL PROTECTED] PGP key available
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
