Hrmm, actually from this:
http://kekoav.com/blog/36-computers/58-uuids-as-primary-keys-in-mysql.html
and this:
http://www.mydatabasesupport.com/forums/mysql/246972-uuid-datatype.html
... it seems one really does need to use binary(16) and then perform a
hex conversion, otherwise there isn't a
Just a heads up: CakePHP, as of about 2 months ago I think, supports
UUIDs as a binary primary field type instead of just char.
See:
https://trac.cakephp.org/ticket/4119
I believe the field length still has to be 36.
>From this:
http://www.mysqlperformanceblog.com/2007/03/13/to-uuid-or-not-to
