|Subject||RE: [firebird-support] Re: detect duplicate blobs, how to?|
> You are aware of course that you can't use any hashing function on its own toActually, if you choose the right hash function you can detect duplicates.
> detect duplicates? - the best you can do is detect *probable* duplicates,
If you create a UDF based on/using SHA256, the result would be unique (with a 2^256 certainty) -- there is no known collision of a SHA256 hash (https://en.wikipedia.org/wiki/Hash_function_security_summary).