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
-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
>>propert
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 ut
-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,
> charac
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
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 s
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 al
