Re: [sqlite] Performance problem

[drh]

Stephen Toney <[EMAIL PROTECTED]> wrote:
> 
> 4. We do not preserve case in the index, so it can ignore incorrect
> capitalization in the search terms. Maybe FTS does this too?

That's a function of your stemmer.  The default stemmers in FTS2
both ignore capitalization.

> 
> 5. For historical reasons, we use NCRs like &#233; instead of UTF-8. Our
> programs remove these before indexing.
> 

You can do this in your stemmer.
--
D. Richard Hipp  <[EMAIL PROTECTED]>


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------