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' Paul. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users