JDBC/MySql problem with Unicode

From: Barley (barley_at_pacific.net)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 12:19:41 -0700

Hi all,

I have been struggling to get MySql to accept Unicode characters for a while
now with no success. I am attaching a small example program as well as a
mySql dump in hopes that someone can help.

The expected behavior is that the program should insert a curly quote and a
'one quarter' symbol. It gets the 'one quarter' symbol, but not the curly
quote (unicode char 201C). Any help much appreciated.

MySql version - 4.1.4-gamma-nt-log
Connecto/J version - 3.0.10

table dump:
----------------------------------------
use testchar;
DROP TABLE IF EXISTS `testchar`;
CREATE TABLE `testchar` (
  `testchar` varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
----------------------------------------

test code snippet:
----------------------------------------
try {

      Class.forName("org.gjt.mm.mysql.Driver");
      Connection conn = DriverManager.getConnection(

"jdbc:mysql://localhost/testchar?user=root&useUnicode=true&character
Encoding=utf8");
      java.sql.Statement select = conn.createStatement();
      select.executeUpdate("insert into testchar (testchar) values ('problem
characters - \u201C ... \u00BC')");
      ResultSet r = select.executeQuery("select testchar from testchar");
      while (r.next()) {
        System.out.println(r.getString(1));
      }
      conn.close();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
-----------------------------------------

The output should be:
problem characters - " ... ¼

Instead, it is:
problem characters - ? ... ¼

Many MANY grateful thanks to anyone who can tell me what I am doing wrong.
This has been very frustrating.

Gregg