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 mecab but it makes misstakes). Is there no other way than to hold the same data in an virtual FTS3 and a normal table to do both search types? because i don't want to bloat the download and in memory caching. the normal table is 29MB indexed is 59MB (and loaded completely in memory ~80MB) both together would be over 100MB when loading completely into memory and with basically the same data twice. regards boscowitch _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users