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). _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
