Hi All,
is it expected the following behavior or is it a bug?
%sqlite3 test.db
SQLite version 3.7.9 2011-11-01 00:52:41
sqlite> CREATE TABLE a (x BLOB);
sqlite> INSERT INTO "a" VALUES(X'30313233');
sqlite> INSERT INTO "a" VALUES('0124');
sqlite> SELECT x, typeof(x) FROM a WHERE x LIKE '012%';
0123|blob
0124|text
sqlite> select * from a where x = '0123'; <=== no record found
sqlite> select * from a where x like '0123';
0123
sqlite> select * from a where x = '0124';
0124
--
Alex Dupre
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
