This is more of an observation than a problem that I need a solution for.
I have some records that contain passwords in some of the fields. I was trying to search for a particular record yesterday by searching on the password. The search came up without finding any records even though I knew the record exists and I’d typed the password correctly.
After a bit of investigating I worked out that if a field contains the following:
#^N
a search won’t find it, even though the record is there.
Bob.
Try wrapping your search term in quotes and it should work. There are some special characters like the negative sign and either the pound or caret (caret is a bitwise operator in many programming languages) is messing it up. If I had to guess it’d be the caret.
Punctuation is also ignored in the general search unless you surround it with quotes. This is a limitation of the SQLite FTS system.
Thanks both. As I said earlier this is ‘no biggy’, it just had me scratching my head for a little while, thought I’d lost a record. Thanks for the explanation!
Bob.
.
