title: case insensitive order by in SQLite in .net
body: <p>I'm using SQLite from a C# program using SQLite.net ( <a href="http://sqlite.phxsoftware.com" rel="nofollow noreferrer">http://sqlite.phxsoftware.com</a> ).</p>
  
  <p>By default SQLite select order by clause sort is case sensitive, I want the result to sort case insensitive, I found "COLLATE NOCASE" but the documentation says it will only handle English characters in the ascii range, I want true linguistic international case insensitive sort using the CultureInfo.CurrentCulture collation (making it use String.Compare will do the trick).</p>