RE: [firebird-support] Re: detect duplicate blobs, how to?

2017-02-09 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
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

RE: [firebird-support] Re: detect duplicate blobs, how to?

2017-02-09 Thread 'Richard Damon' rich...@damon-family.org [firebird-support]
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

[firebird-support] Re: detect duplicate blobs, how to?

2017-02-09 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
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

Re: [firebird-support] Re: detect duplicate blobs, how to?

2017-02-09 Thread hamacker sirhamac...@gmail.com [firebird-support]
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

[firebird-support] Re: detect duplicate blobs, how to?

2017-02-09 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
09.02.2017 14:48, hamacker wrote: > > There is a HASH function but only for string. It works for blobs as well. Dmitry