Re: [sqlite] FTS5 MATCH using "string*" matches just the exact string

2018-09-22 Thread Maziar Parsijani
Hi,Dan I have trimmed it here you can download it: https://drive.google.com/file/d/1D0xKF3DaOEbvfe9yFf0aFQvpo2nxWYqF/view?usp=sharing And the problem is searching with MATCH 'أعلم*' it must find 5 rows. it could be the same as I use LIKE "%أعلم%" On Tue, Sep 11, 2018 at 8:35 PM Dan Kennedy

Re: [sqlite] FTS5 MATCH using "string*" matches just the exact string

2018-09-22 Thread Dan Kennedy
On 09/22/2018 02:11 PM, Maziar Parsijani wrote: Hi,Dan I have trimmed it here you can download it: https://drive.google.com/file/d/1D0xKF3DaOEbvfe9yFf0aFQvpo2nxWYqF/view?usp=sharing And the problem is searching with MATCH 'أعلم*' it must find 5 rows. it could be the same as I use LIKE "%أعلم%"

Re: [sqlite] .timer

2018-09-22 Thread curmudgeon
Keith, did you ever get any feedback from ms about this bug? There's certainly been no windows update that solved the problem. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Why sqlite fts5 Unicode61 Tokenizer does not support CJK(Chinese Japanese Krean)?

2018-09-22 Thread Hideaki Takahashi
Hello, full text search index can be used to see how the text is tokenized for both FTS4 and FTS5. for FTS4, fts3tokenize can be used too. sqlite> CREATE VIRTUAL TABLE icu_zh_cn USING fts3tokenize(icu, zh_CN); sqlite> SELECT token, start, end, position FROM icu_zh_cn WHERE INPUT='为什么不支持中文 fts5

Re: [sqlite] FTS5 MATCH using "string*" matches just the exact string

2018-09-22 Thread Maziar
Hi Then I can do nothing about it. Sent from my iPhone > On Shahrivar 31, 1397 AP, at 7:50 PM, Dan Kennedy > wrote: > >> On 09/22/2018 02:11 PM, Maziar Parsijani wrote: >> Hi,Dan >> I have trimmed it here you can download it: >>