Re: [sqlite] FTS questions

2013-01-12 Thread Michael Black
of SQLite Database Subject: Re: [sqlite] FTS questions Thanks for your reply Why I care the language: according to the documentation: "A term is a contiguous sequence of eligible characters, where eligible characters are all alphanumeric characters and all characters with Unicode codepoint v

Re: [sqlite] FTS questions

2013-01-12 Thread moti lahiani
some special > purpose in mind. > > http://locate32.cogit.net/ > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of moti lahiani > Sent: Saturday, January 12, 2013 4:37 AM > To: sqlite-users@sqlite.org > Cc: Mo

Re: [sqlite] FTS questions

2013-01-12 Thread Michael Black
Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of moti lahiani Sent: Saturday, January 12, 2013 4:37 AM To: sqlite-users@sqlite.org Cc: Moti LAHIANI Subject: [sqlite] FTS questions Hello all I'm new with sqlite3 and sql. I have data base

[sqlite] FTS questions

2013-01-12 Thread moti lahiani
Hello all I'm new with sqlite3 and sql. I have data base that include path columns (file system path like c:\bla bla\myFiles\1.txt) On that columns I need to do 1) search for patterns in case the user want to find a file or directory 2) search for prefix path in case the user rename

[sqlite] FTS questions

2013-01-12 Thread moti lahiani
Hello all I'm new with sqlite3 and sql. I have data base that include path columns (file system path like c:\bla bla\myFiles\1.txt) On that columns I need to do 1) search for patterns in case the user want to find a file or directory 2) search for prefix path in case the user rename