RE: Need to store a Guid as an Id

2004-09-24 Thread Michael McTernan
need to say how many chars you want the index to run to, max is 255 I think - check the docs. Regards, Mike -Original Message- From: Daniel Cummings [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 20:27 To: MySql List Subject: Need to store a Guid as an Id MySql doesn't support Guid

Need to store a Guid as an Id

2004-09-23 Thread Daniel Cummings
MySql doesn't support Guids but we were attempting to use a VarChar. We set the VarChar to binary, but from what I'm reading the binary setting doesn't affect storage just sorting and evaluations. I was able to get the binary storate I needed in a TinyBlob but I can't set this to a primary key