Can not insert into MySQL
MySQL variables:
character_set_clientutf8
character_set_connection utf8
character_set_databaseutf8
character_set_results utf8
character_set_server utf8
character_set_system utf8
Database connection:
conn = DriverManager.getConnection("jdbc:mysql://" + dbHost +"/" + dbDatabase +
"?user=" + dbUser +"&password=" + dbPasswd +
"&useUnicode=true&characterEncoding=utf-8");
Row insertion:
stm = conn.prepareStatement("INSERT INTO genres (genre) VALUES (?)");
stm.clearParameters();
stm.setString(1, newGenre);
stm.executeUpdate();
stm.close();
This code running on Sun Java Application Server in managed bean. The data is not inserted and this line is written to MySQL log:
2 Prepare[2]
There is no error or exception. When I setcharacterEncoding=koi8-r option while connecting then row is inserted. But in both caces I have unreadable characters when printing data to JSP (through JavaServer Faces). What must I do to insert data (and print properly)?
