On Jul 25, 2008, at 8:50 AM, Chris Holbrook wrote:
> I created a table with four text columns and a blob column, and
> populated it using sqlite3 functions ~prepare, ~bind_text,
> ~bind_blob. Now I can't query the data using, for example, "where
> app = 'AA'", though "where app like 'AA'" works! The LENGTH()
> function returns the number of characters which one would expect.
Did you use bind_text, or bind_blob? What does:
SELECT typeof(app) FROM ...
Tell you? Comparing a BLOB to a text string is always false in SQLite.
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
