Richard,
> Sean
> Even SHA256 can’t eliminate all possibility of a duplicate. If you have files
> of
> more than 256 bits in them, by the pigeon hole principle, there WILL be
> duplicates within the universe of all possible files. There HAS to be. The
> probability is very low (but not zero) if
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, February 9, 2017 11:33 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Re: detect duplicate blobs, how to?
> You are aware of course that you can't use
09.02.2017 17:39, hamacker wrote:
> Well, the man page says fully supports text BLOBs, I assume that binary not.
For blobs, it works with raw binary data.
Dmitry
Well, the man page says fully supports text BLOBs, I assume that binary not.
If HASH() behavior will operate ^Z and others control chars in Blob Image,
then now I need to think how to use this function to kill duplications.
Any function like CHECKSUM, CRC32,...?
2017-02-09 10:36 GMT-02:00 Dmitry
09.02.2017 14:48, hamacker wrote:
>
> There is a HASH function but only for string.
It works for blobs as well.
Dmitry