database - Java PreparedStatement UTF-8 character problem

Question

I have a prepared statement:

PreparedStatement st;

and at my code i try to use st.setString method.

st.setString(1, userName);

Value of userName is ?ak?a. setString methods changes '?ak?a' to '?ak?a'. It doesnt recognize UTF-8 characters. How can i solve this problem?

Thanks.

Answer 1

The number of ways this can get screwed up is actually quite impressive. If you're using MySQL, try adding a characterEncoding=UTF-8 parameter to the end of your JDBC connection URL:

jdbc:mysql://server/database?characterEncoding=UTF-8

You should also check that the table / column character set is UTF-8.