On 10/16/13 08:48, Dan Kennedy wrote:
On 10/15/2013 08:13 PM, Raf Geens wrote:
Hi,
I have a FTS4 table that contains entries in multiple languages
(using the languageid option). I also have a spellfix1 table that I
use to search with misspelled words on the FTS4 table. In the
spellfix1 documentation a fts4aux table is used to fill a spellfix1
table based on a FTS4 one. This works in a single-language scenario.
However, I've found that the fts4aux table is empty if the languageid
option is used on the FTS4 table.
My workaround for this has been to create temporary copies of the
FTS4 table, one for each language, with the languageid column
dropped. I can then use fts4aux and fill the spellfix1 table language
by language. This feels like a big hack though. Have I missed a
better way to do this?
The upcoming 3.8.1 release adds a hidden languageid column
to the fts4aux table:
http://sqlite.org/draft/fts3.html#f4alid
So you by adding "languageid=N" to the WHERE clause used
to query the fts4aux table you can read the vocabulary
belonging to languages with non-zero language-ids.
Will this work for you?
Dan.
Yes, that sounds ideal, thanks!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
