Stack Overflow
Stack Overflow

Questions tagged [fts4]

FTS3 and FTS4 are an SQLite virtual table modules that allows users to perform full-text searches on a set of documents.

The most common (and effective) way to describe full-text searches is "what Google, Yahoo and Altavista do with documents placed on the World Wide Web". Users input a term, or series of terms, perhaps connected by a binary operator or grouped together into a phrase, and the full-text query system finds the set of documents that best matches those terms considering the operators and groupings the user has specified.

103 questions
0
votes
1 answer

Sqlite fts4 search html encoded character

I am coding a dictionary project. Its can translate english to arabic or arabic to english. Words are stored in sqlite fts4 database. Arabic letter in database stored html encoded like غير When i use fts4 query syntax in english…
ahmetkocabiyik
  • 127
  • 3
  • 9
0
votes
1 answer

sqlite3 with FTS4 table: Query returns wrong row

I have a weird issue with my FTS4 index in SQLite3, namely that a MATCH query for one term returns not the exact match but another, similar one, and vice versa. Here is an example to illustrate it better: SELECT name FROM test_idx WHERE name MATCH…
jbaiter
  • 6,913
  • 4
  • 30
  • 40
0
votes
1 answer

sqlite fts4 can not use offsets funtion when use group by

I have two table: table 1: fts virtual table docid Long auto increase, content Text, (fts column) table 2: meta data table docid Long(foreigner key of table1 docid), username Text, timestamp Long sql: select table1.docid content, username,…
Jimmy Chen
  • 177
  • 5
0
votes
1 answer

Getting no such module: fts error in corona with sqlite

I am trying to run a "match" query against a sqlite database from inside a corona app. I compiled the sqlite database from the source files using cl.exe and when I compiled I included the flags to enable the fts features. Then I created a virtual…
user2026318
  • 173
  • 1
  • 13
0
votes
1 answer

Create Table Using FTS4 giving Error

I found a nice query using MATCH keyword, but it requires fts4. So, I'm trying to create a Table using fts4 like below, static { mCreateEntries.add("CREATE TABLE " + Tables.LOCATION_DETAILS + " USING fts4(" +…
Sreedhu Madhu
  • 2,480
  • 2
  • 30
  • 40
0
votes
1 answer

How do I match on three values / keywords in a full text search?

I am using a query similar to the one below: SELECT id, description FROM FullTextTable WHERE FullTextTable MATCH '1.010 OR 1.01 OR 1.0100' If I only use two 'OR' operators, the query returns as expected, but I get no results when I attempt to use…
keithwill
  • 1,964
  • 1
  • 17
  • 26
0
votes
1 answer

How do I query an fts table in sqlite for one column matching and another NOT matching a particular query?

I have a Suggestions table(FTS4) that is used to provide suggestions for a query in Android action bar search. I need to query the table for suggestions where one column(suggest_text_1) matches the query text AND another column(data_type) does NOT…
Vinay S Shenoy
  • 4,028
  • 3
  • 31
  • 36
0
votes
1 answer

iOS contact search app

I am developing an app similar to iOS contact app . In my app it would be around 20000 contacts in the list . I would like to perform universal search in this app. Also the search should happen as we type in the search field , Searching "John…
Raj
  • 5,895
  • 4
  • 27
  • 48
0
votes
2 answers

Need to tweak my FTS4 SQLite query

The query below doesn't work on Android and throws the following exception Unable to use function MATCH in the requested context It is a pretty complicated query so I'm looking into ways of simplifying it. For info, this query works on the same…
chopchop
  • 1,905
  • 2
  • 22
  • 37
0
votes
0 answers

Android FTS4 database returns an empty cursor when using a search query

In my application, I have created a FTS4 database which stores contact information and the application gives the user the ability to search the contacts based on the name. When the user enters a search query, that query is then compared to the…
Sai Valluri
  • 85
  • 1
  • 3
  • 6
0
votes
1 answer

no such module: fts4aux- Error while querying sqlite virtual table created using fts4aux

I am trying to collect the words and built a set from fts4aux table to feed a AutocCompleteTextView. But having issues accessing the virtual table created using fts4aux I have a virtual table 'ProductVirtual'. CREATE VIRTUAL TABLE ProductVirtual…
Visa
  • 111
  • 4
-1
votes
1 answer

How to increase Sqlite FTS4 snippet size

Hi I am using sqlite to do full text search on a number of documents. WHile I've got it working basically but I would very much like to increase/expand the amount of text returned in the snippet, is there a way to increase the size, amount of text…
user595985
  • 1,543
  • 4
  • 29
  • 55
-2
votes
1 answer

"SQLiteException error: No such table" if I change the table's name in the same DB and run again the app

I have created a fts database DATABASE_NAME and a table FTS_VIRTUAL_TABLE. I can insert and select values. If I change the name of the table in my code e.g. FTS_VIRTUAL_TABLE_NEW keeping the same database DATABASE_NAME and run the application I get…
kkats
  • 69
  • 1
  • 7
1 2 3 4 5 6
7