Problem with JDBC and Unicode

2004-10-25 Thread Barley
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

JDBC - how to insert Strings with mixed characterEncodings

2004-09-17 Thread Barley
Say, for example, I want to run an insert like the following: java.sql.Statement select = conn.createStatement(); select.executeUpdate("update test set observerNote='\u201C ... \u00BC'"); FWIW, u201C is an opening curly quote and u00BC is a fraction representing one quarter. If I create my JDBC