Re: [sqlite] small sqlite fts snippet function or Fts Bug!

Yeah, -ID 4 was just a desperate experiment for a hack with longer data in the search to see if it would lead the snippet function to start grabbing the data from the start (or at least one "word"/char more). The offsets beeing wrong and therefore the ... was kinda expected of me, but in case it

Re: [sqlite] small sqlite fts snippet function or Fts Bug!

On 01/27/2015 06:48 PM, boscowitch wrote: and the in an sqlite shell (SQLite version 3.8.8.1 2015-01-20 16:51:25) I get following for a select with snippet: EXAMPLE OUTPUT: sqlite> select docid,*,snippet(test) from test where german match "a"; 1|[1] a b c|1] a b c 2|[{[_.,:;[1] a b c|1] a b c

[sqlite] small sqlite fts snippet function or Fts Bug!

Hello since it this bug report (+ a dirty-fix) it might be useful for both users and devs. that's why I send a copy to both mailing lists! I hope I don't bother the diligent devs who read all of both list, sry to them, and thx for sqlite btw. ;)! recently I wanted to use the snippet function in

Re: [sqlite] FTS snippet()

Drake, if I do this, I get: SQL logic error or missing database. Thanks Gert ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS snippet()

Quoth Gert Van Assche , on 2011-04-13 22:35:49 +0200: > SELECT snippet(example, '[', ']') FROM example WHERE CONTEXT MATCH > (SELECT TOKEN FROM example); You're asking to match a single independently arbitrarily chosen token from anywhere in the table (which is not even

[sqlite] FTS snippet()

Hi all, I'm sure I'm doing something stupid here... CREATE VIRTUAL TABLE example USING fts4(TOKEN, CONTEXT); INSERT INTO example(TOKEN, CONTEXT) VALUES('one', 'This is just one sentence.'); INSERT INTO example(TOKEN, CONTEXT) VALUES('two', 'This is just one sentence. Sorry, it

Re: [sqlite] FTS, snippet & Unicode?

On Aug 27, 2008, at 4:52 AM, Alexandre Courbot wrote: > I know there is a patch at > http://www.sqlite.org/cvstrac/tktview?tn=3140,38 that is supposed to > improve Unicode support in FTS3. I suspect it to turn any Unicode > character into a token - however maybe you can use it as a basis to >

Re: [sqlite] FTS, snippet & Unicode?

Alexey Pechnikov wrote: > > Is it included to 3.6.1 or 3.6.2 version? > No, it is not included in either version. The patch was submitted by the mozilla group, but it has not been checked in to SQLite. You can of course apply the patch to your own customized version of SQLite. HTH Dennis

Re: [sqlite] FTS, snippet & Unicode?

Hello! В сообщении от Wednesday 27 August 2008 06:52:09 Alexandre Courbot написал(а): > I know there is a patch at > http://www.sqlite.org/cvstrac/tktview?tn=3140,38 that is supposed to > improve Unicode support in FTS3. I suspect it to turn any Unicode > character into a token - however maybe

Re: [sqlite] FTS, snippet & Unicode?

I know there is a patch at http://www.sqlite.org/cvstrac/tktview?tn=3140,38 that is supposed to improve Unicode support in FTS3. I suspect it to turn any Unicode character into a token - however maybe you can use it as a basis to implement what you need. Alex.

[sqlite] FTS, snippet & Unicode?

Hello, % sqlite3 -version 3.5.9 FTS's snippet seems to truncate Unicode sequences at time. For example, given the following text: Motto: ძალა ერთობაშია (Georgian) "Strength is in Unity" FTS's snippet would return the extract bellow for 'Unity, Freedom, Work': “… ��ია (Georgian) "Strength