Re: UUID column type

[scott]

Lawrence, Thanks for your post, I was thinking about binary(16) too.

But when I tried to execute the following pieces of code (inside a stored procedure)

...

create temporary table Temporary_table (id binary(16));

WHILE i <= num do
set i = i +1;
insert into Temporary_table values (BINARY uuid());
end WHILE;

I get the following error:

ERROR 1406 (22001): Data too long for column 'id' at row 1