java mysql utf8,Java + Mysql UTF8问题

as the title said, I have a problem between java and mysql

The mysql DB, tables, and columns are utf8_unicode_ci.

I have an application that took some input from an xml, then compose the query...

public String [] saveField(String xmltag, String lang){

NodeList nodo = this.doc.getElementsByTagName(xmltag);

String [] pos = new String[nodo.getLength()];

for (int i = 0 ; i < nodo.getLength() ; i++ ) {

Node child = nodo.item(i);

pos[i] = "INSERT INTO table (id, lang, value) VALUES (" +

child.getAttributes().getNamedItem("id").getNodeValue().toString() + " , " +

lang + " , " +

"'" + child.getFirstChild().getTextContent() + "'" +

");";

}

return pos;

}

this method return an array of String that contains one or more SQL insert Query...

then

Class.forName("com.mysql.jdbc.Driver").newInstance();

con = DriverManager.getConnection("jdbc:mysql:///dbname", "user", "pass");

.....

Statement s; s =

this.con.createStatement ();

s.execute(query);

both with s.execyte and s.executeUpdate the special characters are stored as ?

so special char are not stored correctly:

מסירות קצרות is stored as ?????????

Hi! is stored as Hi!

Any advice?

Thanks

解决方案

Solved,

I forgot to add the encoding when initializing Connection:

before was:

con = DriverManager.getConnection("jdbc:mysql:///dbname", "user", "pass");

now (working):

con = DriverManager.getConnection("jdbc:mysql:///dbname?useUnicode=true&characterEncoding=utf-8", "user", "pass");