select ... where [=] or [like] 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 but if I do select foocol from footable where foocol like '999998011295918220' the result is 999998011295918220 My questions are : Is the "=" a valid operator for the where clause in sqlite3 ? Is it a problem of encoding (all code points are under 127) ? Thanks for all help. HM -- View this message in context: http://old.nabble.com/select-...-where--%3D--or--like--tp32802547p32802547.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
