> 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. Pavel On Tue, Nov 8, 2011 at 12:11 PM, hmas <i...@iode-informatique.fr> wrote: > > > Simon Slavin-3 wrote: >> >> >> 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. >> >> Thanks for your answer. >> foocol contains a string of numbers. >> The result of typeof(foocol) is text. >> Herve. >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > -- > View this message in context: > http://old.nabble.com/select-...-where--%3D--or--like--tp32802547p32803113.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
