Hello.
The data type should be VARCHAR(36) as it was in my example. There
is a bug in some versions. See:
http://bugs.mysql.com/bug.php?id=13290
Christian Parpart <trapni@stripped> wrote:
>
> I've been testing your example as I feel really much safer with UUIDs instead
> of auto_increments, however, my column datatype is VARCHAR(12) so 24bytes
> shorter than a usual UUID, although, all uuid() SELECTs differ only in first
> 12 bytes - why?
>
> Regards,
> Christian Parpart.
>
> [-- application/pgp-signature, encoding 7bit, 8 lines --]
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com