On Sun, 2005-01-23 at 10:17 -0800, David Wheeler wrote: > What's the best way to do case-insensitive searches in SQLite, given > that LOWER() may not work properly with UTF-8 characters? Is LOWER() > the best way in general, anyhow? And if so, will it use indexes? >
Use sqlite3_create_collation() to register a collating sequence that ignores case in UTF-8 characters. Then put "COLLATE <name>" after the declaration of the column you want to be caseless.
