4 Replies Latest reply on May 28, 2010 3:10 PM by 775702

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

      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?