Post reply

Comparing image data type

  • September 5, 2007 at 3:40 am

    #178323

    hi

    i need to compare 2 image data type fields to check if they are equal

    does this work?

    substring(image1,0,Datalength(image1) ) = substring(image2,0,Datalength(image2))

    is it good?

    or there is anothe method?

    10x

    If something's hard to do, then it's not worth doing.

  • September 5, 2007 at 6:21 am

    #731462

    Did you TRY it?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • September 5, 2007 at 6:59 am

    #731482

    I don't store images in my database, but i do store information about them.

    I wrote a program that gets the CRC of any file, and I store that in the database with the filename and file size. I've found that if the CRC and the filesize are the same, they are the same file, but with different names.

    this works with any file, not just images, but docs, videos, etc. It works well for me.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply