List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 12 2004 10:10pm
Subject:Re: GUID storage
View as plain text  
In the last episode (May 12), Larry Lowry said:
> Well I'm trying to move to MySQL from the MS SQL Server world.  Most
> data elements are easy except for the uniqueidentifier.
> 
> In the MySQL world what is the preferred/best way to store a
> uniqueidentifier?  The easiest would just be a char(36).

What is a "uniqueidentifier"?  36 chars sounds like a uuid, in which
case a char(36) is probably the most transparent.  If you convert them
to raw form they will fit in a binary char(16), though.  You could even
write uuid_to_string and uuid_from_string UDFs to simplify conversion.

-- 
	Dan Nelson
	dnelson@stripped
Thread
GUID storageLarry Lowry12 May
  • Re: GUID storageMike Hillyer12 May
  • Re: GUID storageJeremy Zawodny12 May
    • Re: GUID storageUnknown Sender29 Jun
      • Re: GUID storageDan Nelson29 Jun
  • Re: GUID storageDan Nelson12 May
  • Re: GUID storageLarry Lowry12 May
    • Re: GUID storageDan Nelson13 May
    • Re: GUID storageSergei Golubchik13 May