Contains function against image data type

  • Hi all,

    I am working on application maintance. I got a Contains(myField, myString) that used to look into an image data type field (text) for the string, but right now it's not responding they way it's supposed to do.

    Recently really big files have been introduced in the DB, could this related to the issue?

    Anyone can help regarding this?

    Many thanks,

    Giovanni 

    JI
  • Do you get any error? What kind of misfunctioning does it have?

  • Sorry,

    I should have had specified.

    No errors, when I look for a string I know is in there sometimes it doesn't find it.

    Cheers,

    G

    JI
  • You sad you have just inserted some large data into the tables. Maybe full text catalogs are not yet populated. Are you manually updating the tables? Can you successfully select old record from that table with Full text?

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

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