Well it's hours later and I still have not found a solution to this. After reading various posts on the net and the documentation I have tried several things.
I've tried passing in useUnicode=true and characterEncoding=UTF8 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. I read this: http://lists.mysql.com/java/7098 And tried making that code modification but that didn't work either. I verified that the database and tables are UTF8. I took a look at the data and saw the unicode chars in there but yet the query results contain question marks. 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. On Tue, 20 Apr 2004 18:59:51 -0500, Paul DuBois wrote: > At 19:49 -0400 4/20/04, Stormblade wrote: >>After reading a bit it seems my problem stems from the fact that although >>my database and tables are all utf8 the "connection" charset seems not to >>be. I have data that is unicode. I can view it in the database and they're >>there. When I retrieve the data all the unicode chars are converted to >>question marks. >> >>So my question is this. How do I set it so that this does not happen. So >>that the data returned is unicode? Is this something I need to set on the >>server end? Or is it a client thing that I have to have the client specify >>when it opens a connection? > > http://dev.mysql.com/doc/mysql/en/Charset-connection.html > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
