A uniqueidentifier in MS SQL is basically a guid. I am generating
them via System.Guid.NewGuid().ToString(N") in the Dot Net
framework which now returns me a string of 32 characters (hex).
Internally I understand it is a 128-bit integer. As an option I could
store that in MySql. What data type would that be?
How would one convert to binary char(16)? In what documentation
would I find this? I do not know enough yet to write a UDF.
----- Original Message -----
From: "Dan Nelson" <dnelson@stripped>
To: "Larry Lowry" <Larry.Lowry@stripped>
Sent: Wednesday, May 12, 2004 3:10 PM
Subject: Re: GUID storage
> 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
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1