Hi,
yes, but unfortunately I have still a project using FTS3 tables to which I have
to add new features..
Regards,
Hardy
> Am 2019-08-30 um 13:00 schrieb Dan Kennedy :
>
>
> On 30/8/62 17:39, mailing lists wrote:
>> Hi,
>>
>> but there is no token '^beta'! Even if in FTS3 '^' is not regarded
On 30/8/62 17:39, mailing lists wrote:
Hi,
but there is no token '^beta'! Even if in FTS3 '^' is not regarded as a special
character. Is the '^' removed by the tokenizer?
Right. It's removed by the tokenizer.
FTS3/4 is focused on backwards compatibility. New work should really use
FTS5 - i
Hi,
but there is no token '^beta'! Even if in FTS3 '^' is not regarded as a special
character. Is the '^' removed by the tokenizer? Because it is regarded as a
diacritical character?
PS: I have to admit that I have overlooked the comment that '^' works only for
FTS4 tables.
Regards,
Hardy
>
The fts3/4 documentation says:
"If the FTS table is an FTS4 table (not FTS3), a token may also be
prefixed with a "^" character. In this case, in order to match the token
must appear as the very first token in any column of the matching row."
So change "FTS3" to "FTS4" and it will likely wo
Hi,
I could not find an example showing a result in the documentation, therefore I
created one by myself:
CREATE VIRTUAL TABLE myData USING FTS3(content);
INSERT INTO myData 'alpha beta';
1)
SELECT * FROM myData WHERE myData MATCH 'beta';
Result:
content
alpha beta
This is what I expected.
5 matches
Mail list logo