Re: [sqlite] searching with like on FTS3

It does but as you can see the like is only performed on a normal table and the match you find only entrys like " sql " or maby " selserver " but not "blablalbasqlstatic" Am Dienstag, den 30.11.2010, 11:50 -0800 schrieb Sam Roberts: > On Mon, Nov 29, 2010 at 9:08 AM, Pascal Schnurr

Re: [sqlite] searching with like on FTS3

On Mon, Nov 29, 2010 at 9:08 AM, Pascal Schnurr wrote: > Hi recently I noticed that i can't search with the like '%searchword%' > syntax on an FTS3 virtual table. I'm no expert, but are you sure? This exact example, using LIKE, appears in the FTS3 docs:

[sqlite] searching with like on FTS3

Hi recently I noticed that i can't search with the like '%searchword%' syntax on an FTS3 virtual table. And with "match" i can't search on example sentences (the indexed data is a japanese dictionary an therefore has no spaces in example sentences and there is no perfekt tokenizer atm i tried

Re: [sqlite] searching with like on FTS3

The problem is that is is that i don't want the ICU tokenizer to split single words entrys and shorter figure of speaches, and for those the search is atm very good (and it has to be exact in 99% because i limit the results to 1). I modded the simple tokenizer to filter more stuff like [ ]

Re: [sqlite] searching with like on FTS3

On 11/30/2010 12:09 AM, boscowitch wrote: > Hi recently I noticed that i can't search with the like '%searchword%' > syntax on an FTS3 virtual table. > > And with "match" i can't search on example sentences (the indexed data > is a japanese dictionary an therefore has no spaces in example

[sqlite] searching with like on FTS3

Hi recently I noticed that i can't search with the like '%searchword%' syntax on an FTS3 virtual table. And with "match" i can't search on example sentences (the indexed data is a japanese dictionary an therefore has no spaces in example sentences and there is no perfekt tokenizer atm i tried