MySQL Forums
Forum List  »  Stored Procedures

Re: UUID column type
Posted by: scott
Date: October 18, 2005 07:47PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
66201
October 16, 2005 10:15AM
29004
October 18, 2005 09:03AM
Re: UUID column type
21892
October 18, 2005 07:47PM
27950
October 19, 2005 07:28AM
18732
October 28, 2005 03:58AM
17245
September 08, 2007 03:46PM
15777
November 04, 2005 09:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.