Re: UUID column type
I use BINARY(16). You definitely do NOT want to use CHAR(16) since you will most likely encounter side effects putting binary into a textual field. An alternative would be to convert the UUID to the string representation and store that using CHAR(43) (or CHAR(32) if you strip the punctuation and store just the hex digits) but that, of course, takes more storage and conversion processing without providing any added benefit.
As always, YMMV.
Subject
Views
Written By
Posted
66390
October 16, 2005 10:15AM
Re: UUID column type
29075
October 18, 2005 09:03AM
21976
October 18, 2005 07:47PM
28031
October 19, 2005 07:28AM
18807
October 28, 2005 03:58AM
17311
September 08, 2007 03:46PM
15837
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.