> Any idea? Please, anyone can help me? How did you put your data into database? I guess you did that with command line utility. And as your console wasn't set to have UTF-8 charset then contents of pais now is not in UTF-8. But jdbc driver tries to treat it as UTF-8 and so you don't see what you want to see. To check this guess execute this query:
select nom_pais, hex(nom_pais) from pais; You can execute it in command line utility and see if hex contents has correct UTF-8 encoding as it should be. Pavel On Sun, Jul 3, 2011 at 2:40 PM, Fabiana Nascimento <fabia...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users