title: JDBC-ODBC Bridge queries to Access fail when they have accented characters
body: <p>I'm sending a query through the JDBC-ODBC Bridge to an Access database from Java, like this:</p>
  
  <pre><code>"SELECT * FROM localities WHERE locName='" + cityName + "'"
  </code></pre>
  
  <p>When cityName is a normal string with no accented characters, the resultset is correct.
  But when cityName happens to be something like <code>LEÓN</code>, <code>SAHAGÚN</code>, that is with accented characters in them, then I get no results. It seems like the query fails in these cases.
  The same queries when run in MS Access work all right, I also tried with Ms Data Acces SKD and these queries work perfectly.</p>
  
  <p>They only fail when passing through the JDBC-ODBC Bridge.
  As I understand, Java uses UTF-8 for strings and so does Access. And they both use Unicode.
  Does anyone know any solution to this problem?</p>