title: Comparing strings that contain accents in SQLite for Java doesn't work
body: <p>I'm reading some bowling players' names in a file and then I need to find those names in a SQLite database to calculate their average.</p>
  
  <p>Everything works perfectly, except for names that contain accents (such as "É").</p>
  
  <p>I've used <code>PRAGMA Encoding</code> in SQLite Manager and the database is encoded in UTF-8. I also made sure that my Java uses UTF-8 for encoding by outputting <code>Charset.defaultCharset();</code></p>
  
  <p>Also, if I run my query in SQLite Manager, everything works great, which actually makes me pretty sure that there's something I need to do with the JDBC SQLite driver. I haven't found a way to see or change which encoding it uses. I'm not even sure that's the problem at all.</p>
  
  <p>Here's the code I'm using:</p>
  
  <pre><code>public double getPlayerAverage(String name, String leagueName){
      PreparedStatement ps = null;
      ResultSet rs = null;
      double average = 0.0;
  
      try{
          connect();
  
          ps = conn.prepareStatement("SELECT AVG(Score)Average FROM Scores " +
                  " JOIN Players p1 USING (PlayerID) " +
                  " WHERE UPPER(Name) = ? AND UPPER(LeagueName) = ? AND Season = '2012-2013' AND Score &gt; -1" +
                  " GROUP BY Season, LeagueName, PlayerID; ");
  
          ps.setString(1, name);
          ps.setString(2, leagueName);
  
          rs = ps.executeQuery();
  
          if(rs.next())
          {
              average = rs.getDouble("Average");
          }
          else
          {
              System.out.println(name + " --- " + leagueName);
          }
      }
      catch(SQLException sqle){
          sqle.printStackTrace();
      }
      finally{
          closer(rs, ps);
      }
  
      return average;
  }
  </code></pre>
  
  <p>The "else" outputs the names that don't have an associated average, which means that those players haven't been found in the database. All the names outputted this way contain accents and no names containing accents are parsed successfully.</p>