JDBC UTF8 encoding and collation errors? - Kevin A. Burton - com.mysql.lists.java

2 messages in com.mysql.lists.javaJDBC UTF8 encoding and collation errors?

From	Sent On	Attachments
Kevin A. Burton	06 Dec 2004 16:46
Kevin A. Burton	06 Dec 2004 17:19

Subject:	JDBC UTF8 encoding and collation errors?
From:	Kevin A. Burton (bur...@newsmonster.org)
Date:	12/06/2004 04:46:51 PM
List:	com.mysql.lists.java

I'm trying to upgrade to MySQL 4.1.7 with ConnectorJ 3.0.12 and I'm getting this error:

"Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

Any idea whats going on here? I could try upgrading to 3.0.16 but I have to apply some patches WRT non-closing ResultSets first... so I don't want to do this if I can avoid it.

Any ideas on this one?

I played with the connectionCollation JDBC property and set it to latin1 but it didn't take I think. The dox say this was added as of 3.0.13 but the changelog says 3.0.12...

Kevin

Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an invite! Also see irc.freenode.net #rojo if you want to chat.

Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html

If you're interested in RSS, Weblogs, Social Networking, etc... then you should work for Rojo! If you recommend someone and we hire them you'll get a free iPod!