OK... as I mentioned in an earlier post when I tried to upgrade to mySQL
4.1.7 I got:
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 '='"
It turns out our JDBC connection string was:
However if I just REMOVE those it works fine.
So the issue is how do I use latin1 tables but tell the JDBC driver
running with MySQL 4.1.7 to do internal encoding of UTF-8?!
Granted in a perfect world I might want to have the DB do this for us
but this would require a HUGE set of ALTER TABLEs and I also want to be
able to run MySQL 4.0 boxes until we're 100% comfortable with 4.1.7.
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!
Kevin A. Burton, Location - San Francisco, CA
AIM/YIM - sfburtonator, Web - http://peerfear.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=mailarch@xxxxxxx