Uderc programming article aggregator sites

Error Connecting to MySql (character set index '49')

Tags:
Answers: Have 5 answers
Advertisement
I downloaded the Oracle Sql Developer extensions and went to Tools / Preferences / Third Part and set the location for the Jar file.
When I try and test the connection to the MySql database I get this error:
An error was encountered performing the requested operation:
Unknown initial charater set index '49' received from the server.
Initial client character set can be forced via the 'characterEncoding' property.
Vendor code 0
My dba's used Sql developer to connect to the same MySql database fine. If I use MySql Workbench, I can connect. (I prefer Sql Developer, so I was hoping to get this connection to work.)
I even tried going to MySql to get their Connection/J JDBC jar file; but the same results.
Any suggestions?
Thanks,
Mike
Advertisement
The best answer: Are your colleagues using the same sqldev/JDBC versions? Which?
Did you follow the guide on setting it up, and the driver from http://dev.mysql.com/downloads/connector/j/ ?
K.