The other day i asked about the proper column to store UUID's in. After thinking about it some more, i still think that a BINARY(16) is a better way to store a UUID. I'd need to strip the dashes from the formatting, but the storage would only be half as much (slightly less actually) as the suggested VARCHAR(36). The index lookups seem like they'd be faster too.
Am i offbase? Also, in talking to a friend that uses that other database from redmond, i discovered that they have build in GUID (same as UUID from what i can discern) columns that are optimized for that kind of data. As it seems that UUID's are becoming the preferred internal ids, are there any plans for UUID column optimizations in MySQL? -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] "The software required Windows 2000 or better, so i Downloaded Linux" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]