On Wed, Nov 9, 2011 at 10:31 AM, hmas <i...@iode-informatique.fr> wrote: >>> Thanks for your answer. >>> foocol contains a string of numbers. >>> The result of typeof(foocol) is text. >> >> And what's the result of hex(foocol) ? My guess is you have some extra >> non-printable characters in there. >> > Hi, > Here are the results: > sqlite> select hex(foocol) from footable where foocol like > '999998012470700566'; > 39393939393830313234373037303035363600
Just as I said - extra '\0' character at the end which is not visible when you try to see the contents of the field, but is crucial for equality to fail. Pavel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
