On Sun, Oct 23, 2011 at 2:21 PM, Baruch Burstein <bmburst...@gmail.com> wrote: > I have done something similar and it worked for me, but there is an issue > with indexes you should take into account, as discussed here: > http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2011-July/031470.html
Thanks a lot for that link. Sqlite was not using index even in my case. So I removed the concatenation in the query and passed a single parameters which will have % appended. I can see Sqlite uses index now. Much better! > . > Out of curiosity (since this query and it's field names seem very similar to > one I am using), what are you using this for? I am developing a text editor for indic languages. It has some amount of artificial inteligence builtin. I use the above said scheme to remeber words entered into the editor. > On Sun, Oct 23, 2011 at 7:36 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > > It should. Check the value of "data" variable - you are probably passing > something other than what you think you are. I don't think anything wrong > with the code you've shown - the problem must lie in the code you haven't. My bad. I was passing an incorrectly encoded string. Corrected the encoding and all started working. > On Sun, Oct 23, 2011 at 4:28 PM, Richard Hipp <d...@sqlite.org> wrote: > > sqlite3_trace() does, since version 3.6.21 (2009-12-07). What version of > SQLite did you say you were using? I got it working. I was reseting the parameters at a wrong location. This is the reason why trace was not showing the parameter value. All works well. Thanks for the help. -- -n _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
