MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: UUID column type
Posted by: Vince Garvin
Date: September 08, 2007 03:46PM

Just for info, the info to get the opposite:

CREATE FUNCTION `BINTOUUID`(UUID BINARY(16)) RETURNS char(36)
BEGIN
RETURN concat(HEX(LEFT(uuid,4)),'-', HEX(MID(uuid,5,2)),'-', HEX(MID(uuid,7,2)),'-',HEX(MID(uuid,9,2)),'-',HEX(RIGHT(uuid,6)));
END

Cheers,
Vince.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
UUID column type
66447
scott
October 16, 2005 10:15AM
Re: UUID column type
29108
Lawrence Holtsclaw
October 18, 2005 09:03AM
Re: UUID column type
21997
scott
October 18, 2005 07:47PM
Re: UUID column type
28052
Lawrence Holtsclaw
October 19, 2005 07:28AM
Re: UUID column type
18827
Svend Høst
October 28, 2005 03:58AM
Re: UUID column type
17329
Vince Garvin
September 08, 2007 03:46PM
Re: UUID column type
15854
Roland Bouman
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.