On Thu, Oct 18, 2012 at 2:28 AM, Tristan Van Berkom <trista...@openismus.com > wrote:
> Hi all, > I've been around and around the documentation, run a sequence of > test cases and still haven't figured this out. > > What is the proper default escape sequence to be used for GLOB > pattern matching in SQLite ? > > I've already read in this other thread: > > http://osdir.com/ml/sqlite-**users/2012-06/msg00349.html<http://osdir.com/ml/sqlite-users/2012-06/msg00349.html> > > That the ESCAPE keyword cannot be used to override the > default escape sequences used in GLOB, but how do I just > get by with defaults ? > The only characters that need escaping are *, ?, and [, and they can all be escaped by making them into a one-character character class: [*], [?], and [[]. > > If this simply cannot be done, I'd really appreciate if > someone could point me in the right direction here, must > I override the 'glob' function in C code ? > > If so, that's really not a problem as I'm running this > from C code anyway... but what should I override it with ? > > Best Regards, > -Tristan > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users