Re: using UID in DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux