Problem Retrieving Unicode Data

[Stormblade]

Hey all,

I have an existing JSP web application which retrieved data from a
SQLServer database and displayed it. The data contained Unicode chars. This
worked fine. I changed databases/JDBC drivers over to MySQL. I've set the
database to use utf8 and the tables as well. I've viewed the data in the
table and it contains unicode just fine, however, the query returns data
with all the unicode chars converted to question marks. I have searched for
a solution to this for hours and no luck so far.

I've tried passing in useUnicode=true and characterEncoding=UTF8 in the URL
connection string and this has done nothing. Then I read that by default
the driver has the useUnicode set to true. I tried setting it to false to
see if it would do anything. Nothing.

Then I came across this:

http://lists.mysql.com/java/7098

I don't know anywhere else to ask this. Even though it may not be MySQL's
problem but the driver I don't see any forums for the MySQL driver.

I'm running 4.1.1 of MySQL and 3.0.11 of the MySQL JDBC driver. Any help
would be most appreciated.

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Stormblade (Shaolin Code Warrior)
Software Developer (15+ Years Programming exp.)

My System: http://www.anandtech.com/mysystemrig.html?rigid=1683
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-