Re: using UID in DB

Tommy Pham wrote:

Storage wise it is just a 128 bit number, so twice as big as a simple 64 bit 'generator' that would normally be used in a single database system. The improvement is to use a raw number rather than a 16 character string.

Don't you mean raw number as 16 byte, which is what I intend to use binary(16) on MySQL if I'm going to use MySQL as DB, rather than 32/36 character string?

Character is a byte ;) Firebird we can use character string as 16 bytes. The 'improvement' is to provide a proper data type for it, and then return a 'UUID' rather than '16 character string'. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk// Firebird - http://www.firebirdsql.org/index.php