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