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 url like this:
jdbc:mysql://localhost/test?user=test&password=test&useUnicode=true&characte
rEncoding=cp1250
then the curly quote is successfully inserted, but not the 'one quarter'
symbol. However, if I create the url in this way:
jdbc:mysql://localhost/test?user=test&password=test&useUnicode=true&characte
rEncoding=latin1
then the 'one quarter' is inserted but not the curly quotes. I understand
that the latin1 character set includes the 'one quarter' symbol, but not the
curly quote and that the cp1250 character set includes the curly quote but
not the 'one quarter' symbol, but I want a way where I don't have to choose
a single limited pool of characters.
How can I insert a String that contains both characters? Isn't there a way
to enable JDBC/MySql ConnectorJ to be able to insert Strings containing any
combination of Unicode characters?
Many thank to anyone who can clarify this issue.
Gregg
