Hello, I'm having problem with accented characters when getting text data from sqlite3 with Java (sqlite jdbc). When i query in command line, the result came correct with accentuation. For example:
*sqlite> select nom_pais from pais ; Itália Rússia * But, when I query from java app, it's work wrong, as: *nome do país: It li nome do país: R£ssi * I tried set properties on connection: *Properties prop = new Properties(); prop.put("charSet", "UTF-8"); this.conn = DriverManager.getConnection("jdbc:sqlite:" + file, prop); * And set system properties before get result: * System.setProperty("file.encoding", "UTF-8");* But nothing doesn't work... Any idea? Please, anyone can help me? best regards Fabiana _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users