Don't put raw user input where code is expected. Match strongs are code. You need to encapsulate (eg escape) or filter (delete bad characters) match strings outside sqlite.
On Thu., 18 Oct. 2018, 13:50 Maziar Parsijani, <maziar.parsij...@gmail.com> wrote: > It will crash or exit the program. > > On Thu, Oct 18, 2018 at 2:27 PM Jens Alfke <j...@mooseyard.com> wrote: > > > > > > > > On Oct 18, 2018, at 11:17 AM, Maziar Parsijani < > > maziar.parsij...@gmail.com> wrote: > > > > > > I just search for words an alphabets in different languages with python > > and > > > my database is sqlite but I need to do something to not getting error > > when > > > user input a wrong character like the ones that I told before.I can ban > > > user to not input these characters but I am curious to find a way on > > sqlite. > > > > What’s wrong with getting an error? If the error code or message is > > specific enough, you can detect it and tell the user they’ve entered > > invalid characters. > > > > —Jens > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
