Java + Mysql UTF8 Problem

by

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");

More Related Contents:

  1. How to get UTF-8 working in Java webapps?
  2. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  3. How to correctly write UTF-8 strings into MySQL through JDBC interface
  4. Producing valid XML with Java and UTF-8 encoding
  5. How to validate an XML file against an XSD file?
  6. Encode String to UTF-8
  7. Best way to compare 2 XML documents in Java
  8. MySQL and JDBC with rewriteBatchedStatements=true
  9. What’s the difference between fx:id and id: in JavaFX?
  10. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  11. Returning a ResultSet
  12. How to configure Tomcat to connect with MySQL
  13. UTF-8 byte[] to String
  14. Create XML file using java
  15. Error inflating when extending a class
  16. ImageView rounded corners [duplicate]
  17. Is there any XPath processor for SAX model?
  18. Java BufferedWriter object with utf-8
  19. how to get list of Databases “Schema” names of MySql using java JDBC
  20. Rotate Marker and Move Animation on Map like Uber Android
  21. Is there a way to retrieve the autoincrement ID from a prepared statement
  22. Android View Clipping
  23. Why can Java not connect to MySQL 5.7 after the latest JDK update and how should it be fixed? (ssl.SSLHandshakeException: No appropriate protocol)
  24. Easiest way to convert a Blob into a byte array
  25. JAXB – Ignore element
  26. Parse XML TO JAVA POJO in efficient way
  27. Is there a SaxParser that reads json and fires events so it looks like xml
  28. Java: How to insert CLOB into oracle database
  29. java.sql.SQLException: No database selected – why?
  30. Calculating length in UTF-8 of Java String without actually encoding it

Leave a Comment