in reply to Re^3: Question: Generate unique/random 12-digit keys for 25,000K records, howto??
in thread Question: Generate unique/random 12-digit keys for 25,000K records, howto??

He was using MD5 and then only used the 8 first (or last) characters. This can lead to collisions.

(Also in theory two MD5s from two different inputs can be identical, but this is very unlikely)

  • Comment on Re^4: Question: Generate unique/random 12-digit keys for 25,000K records, howto??

Replies are listed 'Best First'.
Re^5: Question: Generate unique/random 12-digit keys for 25,000K records, howto??
by carol (Beadle) on Apr 30, 2008 at 22:04 UTC
    You are right. I didn't realise he would take a substring from the result.