The MD5 gamut is 2^128 or 16^32 or 340,282,366,920,938,463,463,374,607,431,768,211,456. Your database will run out of integer keys long before it's an issue with almost complete certainty. But yes, it is a potential problem. Easy to make fail-fast with a constraint on your DB though.
cheers, barneyb On Tue, Jun 16, 2009 at 1:03 PM, Alan Rother<[email protected]> wrote: > > One catch with a hash, it is possible, however highly unlikely, that two > different email addresses will produce the same hash. > Just be aware of it. > > =] > > -- > Alan Rother > Adobe Certified Advanced ColdFusion MX 7 Developer > Manager, Phoenix Cold Fusion User Group, AZCFUG.org > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
