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

Re: GUID storage

2004-06-28 Thread Dan Nelson
In the last episode (Jun 28), Ray Kiddy said: > Is it in the plans to have a 128 bit numeric column type for MySQL? > If so, in what kind of time frame? If not, why not? I don't know of any 32-bit compiler that provides a 128-bit integer type, which means for most platforms mysql would have to req

Re: GUID storage

2004-06-28 Thread Ray Kiddy
Nowhere in this discussion was this question. Is it in the plans to have a 128 bit numeric column type for MySQL? If so, in what kind of time frame? If not, why not? Character arrays are obviously, but they are probably not the best way to get optimal performance. Native support for a 128 bit nu

Re: GUID storage

2004-05-12 Thread Sergei Golubchik
Hi! On May 12, Larry Lowry wrote: > 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

Re: GUID storage

2004-05-12 Thread Dan Nelson
In the last episode (May 12), Larry Lowry said: > 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

Re: GUID storage

2004-05-12 Thread Larry Lowry
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

Re: GUID storage

2004-05-12 Thread Dan Nelson
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

Re: GUID storage

2004-05-12 Thread Jeremy Zawodny
On Wed, May 12, 2004 at 02:50:55PM -0700, Larry Lowry wrote: > 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

Re: GUID storage

2004-05-12 Thread Mike Hillyer
Larry Lowry wrote: 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). Thanks. Larry Lowry In this case I

GUID storage

2004-05-12 Thread Larry Lowry
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). Thanks. Larry Lowry

Re: GUID

2004-01-08 Thread Jochem van Dieten
Hassan Shaikh wrote: How do I generate a GUID (Globally Unique Identifier) under MySQL on Linux. I am doing it under Win32 using one of the documented Win32 API but I want to do it on a Linux platform? Do you need a GUID or would a UUID be alright too? (128 bit identifier just like GUID

Re: GUID

2004-01-08 Thread robert_rowe
I don't think that Linux uses GUID's. They are a Microsoft construct. I just searched the MySQL manual and it doesn't mention them. What are you using them for? There may be an equivilent available. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

GUID

2004-01-08 Thread Hassan Shaikh
Hi, How do I generate a GUID (Globally Unique Identifier) under MySQL on Linux. I am doing it under Win32 using one of the documented Win32 API but I want to do it on a Linux platform? Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To