Re: [sqlite] Java and accented characters

[Pavel Ivanov]

> 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  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

[sqlite] Java and accented characters

[Fabiana Nascimento]

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