Sorry every one ! It's my fault ! I made a function on top of sqlite3_exec which have :
va_start(argp,acSql); vasprintf(&acBuffSql, acSql, argp); So this one tried to identify the %A ..... my bad ^^ On Thu, Jul 3, 2014 at 5:40 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users