On Thu, Sep 29, 2011 at 8:42 PM, David Garfield <garfi...@irving.iisd.sra.com> wrote: > If the value in key is a blob, then like matches it and = does not.
Thanks. This suggestion helped me track down the issue. I was actually going through ActiveRecord (the ORM for Ruby on Rails). Was upgrading my app for Ruby 1.9 and my unit tests were not passing. Your suggestion lead me to the following page which gave me the solution: http://stackoverflow.com/questions/7437944/sqlite3-varchar-matching-with-like-but-not -- http://saveyourcall.com - Easily record phone calls from any phone http://pixelwareinc.com - Atlanta-based web development and design _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users