> On 3 Jul 2014, at 2:38pm, RSmith <rsm...@rsweb.co.za> wrote: > > > On 2014/07/03 15:12, Micka wrote: >> It's really weird that : >> >> SELECT * FROM names where name LIKE '%mic%' >> >> works with the sqlite3 command shell but not with the C librairie ......
It works fine with the C library. I'm betting that you are using a C function to assemble the string, and your C function understands '%' as a formatting or escape character. Try writing code to put the string SELECT * FROM names where name LIKE '%mic%' together then print the length of the string. It should be 43 characters long. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
