Thanks. I'd read that already but I re-read it and noticed this part here: "When a client connects, it sends to the server the name of the character set that it wants to use. The server sets the character_set_client, character_set_results, and character_set_connection variables to that character set. (In effect, the server performs a SET NAMES operation using the character set.)"
So basically on the client end when I make a connection I need to tell it to use a character set. I'll have to check my documentation. I'm connecting via JDBC so I'm guessing it must be part of the connection string. Thanks for the reply. 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]
