Eclipse Community Forums: ServerTools (WTP) » Error 'character_set

Help

Home

Home » Language IDEs » ServerTools (WTP) » Error 'character_set_results'

Show: Today's Messages :: Show Polls :: Message Navigator

Error 'character_set_results' [message #74837]

Fri, 18 February 2005 17:27

Eclipse User

Originally posted by: omzeta.star.com.pe

Hi everybody, I understand that this newsgroup is not about MySQL or Java,
but I think that if you use Eclipse then use Java and MySQL. Good, my
problem is that I have installed MySQL 4.1.0 and it works normally. I have
installed mysql-connector-java-3.0.16-ga driver for Java and MySQL, and in
the code Java :

Class.forName ("com.mysql.jdbc.Driver").newInstance();
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=
");

here Eclipse throw error :

SQLException: Unknown system variable 'character_set_results'

Can anybody tell me the reason???
Regards

Report message to a moderator

Re: Error 'character_set_results' [message #76928 is a reply to message #74837]

Fri, 25 February 2005 18:29

Larry Dunnell

Messages: 19
Registered: July 2009

Junior Member

Omar Zevallos wrote:

> Hi everybody, I understand that this newsgroup is not about MySQL or Java,
> but I think that if you use Eclipse then use Java and MySQL. Good, my
> problem is that I have installed MySQL 4.1.0 and it works normally. I have
> installed mysql-connector-java-3.0.16-ga driver for Java and MySQL, and in
> the code Java :

> Class.forName ("com.mysql.jdbc.Driver").newInstance();
> Connection con =
> DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=
> ");

> here Eclipse throw error :

> SQLException: Unknown system variable 'character_set_results'

> Can anybody tell me the reason???
> Regards

I am not that familiar with MySQL, but according to the information I
found, 'character_set_results' was not supported until MySQL version
4.0.3. Sounds like a driver/server version compatibility problem.

Report message to a moderator

Previous Topic:	WTP RDB tools can only retrieve the first 50 rows of a query?
Next Topic:	Database Explorer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 11:39:55 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter