db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: Strange performance issue with BLOB's
Date Thu, 13 Jul 2006 15:41:31 GMT
Piet Blok wrote:

> There is something else that I was wondering about. You may have noticed
> the SIZE and CRC column in my blob table together with the UNIQUE
> constraint. Obviously, I want to prevent duplicate blob's. What happens if
> I add a UNIQUE constraint on the blob data itself? Would it be accepted?

No, BLOBs are not comparable, this follows the SQL standard.


View raw message