On 8 Nov 2011, at 10:58am, hmas wrote: > My application insert into a table a string of numbers (for exemple > '999998011295918220'. > if I do (either from command line or from my c++ program) > select foocol from footable where foocol = '999998011295918220' > the result set is empty
I'm trying to figure out whether that string of digits was stored as a string or a number. Please do SELECT foocol,typeof(foocol) FROM footable WHERE foocol LIKE '999998011295918220' and tell us what the results are. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users