Well, I would love that to be simple ..... but when I printf my query, I got :
SELECT * FROM names where name LIKE '%mic%' that the code : sprintf( acQuery, "SELECT * FROM names where name LIKE '%%%s%%' ", acName); So what could it be ? any ideas ? On Tue, Jun 3, 2014 at 4:21 PM, Hick Gunter <h...@scigames.at> wrote: > Probably you are using a variant of the printf() function to generate your > statement and it is interpreting the %m as strerror(errno) (see man 3 > printf), whereas it is ignoring %' (thousands separator for decimal > conversions) either because it does not support this conversion or it is > missing the conversion specifier. > > Try inserting (3,'icka') into your table. > > If it works in the shell but not in your program, then it is nearly always > your program that is to blame. > > -----Ursprüngliche Nachricht----- > Von: Micka [mailto:mickamus...@gmail.com] > Gesendet: Dienstag, 03. Juni 2014 08:58 > An: sqlite-users@sqlite.org > Betreff: [sqlite] Like and percent character > > Hi, > > I'm having trouble with the percent character ..... > > > By example in my table I have : > > id name > 1 micka > 2 mickael > > I would like to do that : > > Select * from table name where name LIKE '%micka%' > > with my linux c program, the result is 0 > > but with the sqlite3 command program it works .... > > I also tested this : > > Select * from table name where name LIKE 'micka%' > > and this time, it works in my linux c program ... > > I'm using the last package of sqlite3-dev ... > https://packages.debian.org/wheezy/sqlite3 > > Why ? > > Thx you ! > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ----------------------------------------------------------------------- > Gunter Hick > Software Engineer > > Scientific Games International GmbH > Klitschgasse 2 – 4, A - 1130 Vienna, > Austria > FN 157284 a, HG Wien > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This e-mail is confidential and may well also be legally privileged. If > you have received it in error, you are on notice as to its status and > accordingly please notify us immediately by reply e-mail and then > delete this message from your system. Please do not copy it or use it for > any purposes, or disclose its contents to any person as to do so could be a > breach of confidence. Thank you for your cooperation. > _______________________________________________ > 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