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. If I insert data in the same table using explicit SQL, I can use "=" with success.
__________________________________________________________ Not happy with your email address?. Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users