Hi All,
Apologies for the newbie questions...
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?
Many TIA,
David

