Re: Problem retrieving Unicode data

2004-04-21 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stormblade wrote: 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,

Re: Problem retrieving Unicode data

2004-04-21 Thread Stormblade
On Wed, 21 Apr 2004 10:35:16 -0500, Mark Matthews wrote: Stormblade, If you're using UTF-8 data and JDBC, and you _haven't_ set the _server_ charset to UTF-8, you'll need to add 'characterEncoding=UTF-8' as a property to your JDBC connection string. I have set the default charset to utf8.

Re: Problem retrieving Unicode data

2004-04-21 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stormblade wrote: On Wed, 21 Apr 2004 10:35:16 -0500, Mark Matthews wrote: Stormblade, If you're using UTF-8 data and JDBC, and you _haven't_ set the _server_ charset to UTF-8, you'll need to add 'characterEncoding=UTF-8' as a property to your

Re: Problem retrieving Unicode data

2004-04-21 Thread Stormblade
On Wed, 21 Apr 2004 14:07:48 -0500, Mark Matthews wrote: I have set the default charset to utf8. When I view my variables they all show that utf8 as their value. My URL is as follows: What does the JDBC connection _itself_ show? Execute the following query on a java.sql.Statement, and tell

Problem retrieving Unicode data

2004-04-20 Thread Stormblade
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

Re: Problem retrieving Unicode data

2004-04-20 Thread Paul DuBois
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

Re: Problem retrieving Unicode data

2004-04-20 Thread Stormblade
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

Re: Problem retrieving Unicode data

2004-04-20 Thread Stormblade
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