Getting UTF-8 strings from MySQL

From: Jonck (jonck_at_vanderkogel.net)
Date: 10/16/04 

Date: Sat, 16 Oct 2004 17:24:10 GMT

Hi everybody,
I'm having problems retrieving strings from MySQL in UTF-8. I know (or
at least I'm pretty sure) that the strings are being written to the
database correctly, because when I use the mysql command-line utility
and do a SELECT I see the correct strings there.
However, when I retrieve the strings they are not formatted correctly.
For example, if I write the string "Knäckebröt" to the database and then
try to retrieve it, it comes out as "Kn�ckebröt".

I read the Connector/J manual, where it tells me to do the following to
write and read UTF-8 strings to and from MySQL:
When opening a connection with MySQL I should use the following code:
Properties props = new Properties();
props.setProperty("characterEncoding", "utf-8");
conn = DriverManager.getConnection(connectionString, props);

However, when I now try to read a string from a resultset, for example (
where results is a JDBC ResultSet):
String messageText = results.getString("messageText");

the text comes out garbled.

Does anybody have any suggestions for me to be able to retrieve the text
with the correct encoding?

Thanks very much, Jonck

Relevant Pages

  • UTF-8 from MySQL
    ... I'm having problems retrieving strings from MySQL in UTF-8. ... when I retrieve the strings they are not formatted correctly. ...
    (comp.lang.java.programmer)
  • Re: escaping vs stored procedure
    ... it's really (PHP's MySQL library)'s function? ... It is a library function in MySQL. ... ng that mysql_escape_string prevents sql injection. ... mysql_real_escape_stringstrings, ...
    (comp.lang.php)
  • Re: import txt file to mysql with ruby & load data local ??
    ... Yes, if it will work with MySQL directly, it should work here as well. ... If you have valid MySQL strings, strings that created what you expected from ... are your valid strings will work with Ruby's MySQL interface. ...
    (comp.lang.ruby)
  • Re: Strip slashes?
    ... Also, manipulating strings ... with slashes in PHP is a pain the arse ... when inserting into MySQL. ...
    (alt.php)
  • Re: important problem with mysql and a service java
    ... in your SQL syntax; check the manual that corresponds to your MySQL ... The correct solution is to give each user a unique ID number using a column which is declared with the "auto_increment" qualifier, then store the strings in another table, linked to the user through his ID number. ... userid integer auto_increment primary key ...
    (comp.lang.java.databases)