title: SQLite upper() alike function for international characters
body: <p>Actually question was asked several times, but I didn't manage to find answer. </p>
  
  <p>There's set of SQLite table(s) which are read-only - I can't change their structure or redefine collation rules. Tables consisting some international characters (Russian/Chinese, etc).</p>
  
  <p>I would like to get some case-insensitive selection like:</p>
  
  <pre><code>select name from names_table where upper(name) glob "*"+constraint.toUpperCase()+"*"
  </code></pre>
  
  <p>It works only when <code>name</code> is latin/ASCII charset, for international chars it doesn't work.</p>
  
  <p>SQLite's manual reads:</p>
  
  <blockquote>
    <p>The upper(X) function returns a copy of input string X in which all
    lower-case ASCII characters are converted to their upper-case
    equivalent.</p>
  </blockquote>
  
  <p>So the question is: how to resolve this issue and make international chars in upper/lower case?</p>