Re: [Tracker] Case insensitive searches with sqlite



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/




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]