> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Adam Cameron > Sent: Wednesday, December 08, 2004 3:18 PM > To: [EMAIL PROTECTED] > Subject: RE: [CFCDev] GUIDs as Primary/Foreign Keys > > >I haven't run into any performance problems yet. Presumably, with a > large enough dataset you might, but SQL Serve handles indexed strings > nicely enough in most cases. > > Are UUIDs stored as 36-char strings or 128-bit integers?
In SQL Server you can create a column as datatype "uniqueindentifier" - if you do you must pass the ID into SQL in the format it expects (not CFs format - but it's easy to convert) or use the NewID() function. If you do that I believe the data is stored internally as a 128 bit number (the column has a length of "16"). If you store it yourself or want to use a different format you have to create a char column of length 36 (or more I suppose). Jim Davis ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
