Re: [Tracker] Case insensitive searches with sqlite

[Jamie McCracken <jamiemcc blueyonder co uk>]

Gabriel Burt wrote:
> Hi, just wondering if ya'll were aware of the issues with doing case
> insensitive searches with sqlite (eg it doesn't support it for
> non-ASCII charsets)?  I searched the list archives and didn't see
> anything.  Sorry if this is a solved issue or a non-issue.

The only searches that use sqlite require case sensitivity anyhow as the 
filesystem is case sensitive. (sqlite is mainly used to get the unique 
ID for a file or vice versa)

this does not affect the QDBM inverted word index where all words are 
normalised to utf-8 and stored in lowercase for hashing so case is not 
an issue when doing a fulltext search



--
Mr Jamie McCracken
http://jamiemcc.livejournal.com/