On Wed, Mar 31, 2010 at 2:29 AM, Lester Caine <les...@lsces.co.uk> wrote:
> 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'.

You mean something akin to MSSQL's uniqueidentifier data type - store
as 16 byte but will return the hex string on SELECT? AWESOME!!  You
just gave me another reason not to use MySQL :D

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

Reply via email to