Re: Character set/Collation problem in MySQL 4.1

[Adam Beguelin]

I have a similar problem. I'm trying to insert a java string value into a table but the special characters (\u2019 and \u2018 quotes in this case) get converted to questionmarks.

I'm using 4.1.7-standard on linux (fedora core2). If I run the same program against 4.1.8-nt running on windows XP. (I am using the latest version of the jdbc driver as well.)

Suggestions?


String s = new String("\u2019hello\u2018");
PreparedStatement ps = m_conn.prepareStatement("INSERT INTO myRecords(TITLE) VALUES( ? )");
ps.setString(1,s);
ps.executeUpdate();
ps = m_conn.prepareStatement("select title from myRecords where title like ?");
ps.setString(1,s);
rs = ps.executeQuery();
if (rs.next()) {
String title = rs.getString(1);
if (title.equalsIgnoreCase(s))
System.out.println("insert worked");
else
System.out.println("insert failed: title is " + title);
} else {
System.out.println("no result set");
}