On 11/09/11 19:42, Yuriy Kaminskiy wrote:
Paul Corke wrote:
On 09 November 2011 15:32, hmas wrote:
sqlite> select hex(foocol) from footable where foocol like
'999998012470700566';
39393939393830313234373037303035363600
It looks like there's an extra 00 on the end.
x'3900' != x'39'
That said, it seems LIKE operator is buggy.
sqlite> SELECT X'1245005679' LIKE X'1245001234';
1
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Windows
sqlite3.exe
SQLite version 3.7.9 2011-11-01 00:52:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> SELECT X'1245005679',X'1245001234';
↕E|↕E
Roger
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users