Comparing Images in SQL

Question

What is the best way to compare with images in a database? I tried to compare them (@Image is an image type):

Select * from Photos 
where [Photo] = @Image

But it gets the error "Image and image of data types are incompatible in an equal operator."

Answer 1

Because the image data type is binary and a huge storage space, IMO, the easiest way to compare image fields is to compare hashes. Therefore, you need to save the hash of the "Photo" column on your table.

Answer 2

, , . , . , . , , , , .

Answer 3

, , .

, , . .

, 100100 , 5050 . ( ), .

, , :

• pdiff
• ImageMagick compare

, , ( , , ), MD5 .

Answer 4

, . , DATALENGTH SUBSTRING READTEXT, . , CLR .

Answer 5

, . , . , , . 2 , 50% . , , .

, .