Very new to Sqlite3 and I finally have an FTS4 search working, but am stumped how to code for Case-Sensitive. I have a Database with tblMain
that has two BLOB_TEXT columns, advOne
and advTwo
CREATE VIRTUAL TABLE tFind USING FTS4(aOne, aTwo);
// populate tFind here
SELECT FROM tFind WHERE aOne MATCH 'Fine';
This works fast and returns records with
feeling fine
and
a Fine was levied
I need to find the records with only the case sensitive Fine
in them.
How do I word the line?
I am using Lazarus and Ubuntu if that makes any difference.
The default tokenizer ignores case.
You'd have to install your own custom tokenizer.