[sqlite] FTS4 inquiry (non-printable characters, column delimiters)

Greetings All, I use the Full Text Search facilities extensively. The feature is intuitive and works beautifully and super fast even with 100GB+ databases. I must applaud the SQLITE dev team on such amazing work. I have two questions with regards to FTS. 1) I'm going out on a limb here: As

[sqlite] Fts */or. Inconsistencies

SQLite Gurus, In SQLIte FTS3/4, does the '*' (wildcard expansion character) discriminate between alphanumeric characters vs non-alpha numeric characters when matching? I have two test cases below which causes me to believe that it does. Also, the OR operator appears to fail when matching against

[sqlite] FTS Tokenizer (separator)

Greetings All, >From section seven of the FTS3/FTS4 documentation: A term is a contiguous sequence of eligible characters, where eligible characters are all alphanumeric characters, the "_" character, and all characters with UTF codepoints greater than or equal to 128. All other characters are

[sqlite] Fts4 table + triggers

Greetings all, It is well known that you cannot create triggers against virtual tables and fts4 tables are a form of virtual table. Has anyone developed a work around method for this or simulating the end effect? I have a full text search table which is comprised of joining and selecting from