Updated DDL for SQL backend

Derek Atkins warlord at MIT.EDU
Thu Oct 26 23:58:22 EDT 2006


Quoting Benoit Gregoire <bock at step.polymtl.ca>:

> 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
       warlord at MIT.EDU                        PGP key available



More information about the gnucash-devel mailing list