Thread: Full-text search can't handle single-quote mark in a phrase (e.g. golfer's elbow)
View Single Post
Old 10-25-2023, 07:47 PM   #5
droopy
Guru
droopy ought to be getting tired of karma fortunes by now.droopy ought to be getting tired of karma fortunes by now.droopy ought to be getting tired of karma fortunes by now.droopy ought to be getting tired of karma fortunes by now.droopy ought to be getting tired of karma fortunes by now.droopy ought to be getting tired of karma fortunes by now.droopy ought to be getting tired of karma fortunes by now.droopy ought to be getting tired of karma fortunes by now.droopy ought to be getting tired of karma fortunes by now.droopy ought to be getting tired of karma fortunes by now.droopy ought to be getting tired of karma fortunes by now.
 
Posts: 834
Karma: 2912460
Join Date: Apr 2009
Device: Kobo Forma
Quote:
Originally Posted by kovidgoyal View Post
full text search is based on words, it doesnt support punctuation of any kind, and that limitataion comes from the sqlite fts engine.
Hi Kovid,
Actually, I learned that full-text search, at least in phrases, does support punctuation. But I'm getting ahead of myself. Let's rewind.

FT Search couldn't find any books with
"golfer's elbow"


But it found eight books when it was a curly (a.k.a "smart) apostrophe, as in:
"golfer’s elbow"
droopy is offline   Reply With Quote